[libgda/LIBGDA_5.2] MySQL meta data: fixed case where schema is incomplete in MySQL database

[Vivien Malerba <vivien src gnome org>]

commit e2541feb6bd41559fce7757c2b3b738625828b34
Author: Vivien Malerba <malerba gnome-db org>
Date:   Sun Aug 23 14:33:53 2015 +0200

    MySQL meta data: fixed case where schema is incomplete in MySQL database

 providers/reuseable/mysql/gda-mysql-meta.c |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)
---
diff --git a/providers/reuseable/mysql/gda-mysql-meta.c b/providers/reuseable/mysql/gda-mysql-meta.c
index 551f2fd..61d2411 100644
--- a/providers/reuseable/mysql/gda-mysql-meta.c
+++ b/providers/reuseable/mysql/gda-mysql-meta.c
@@ -147,10 +147,10 @@ static gchar *internal_sql[] = {
        "SELECT " CATALOG_NAME " AS constraint_catalog, constraint_schema, constraint_name, " CATALOG_NAME " 
AS table_catalog, table_schema, table_name, constraint_type, NULL, FALSE, FALSE FROM 
INFORMATION_SCHEMA.table_constraints WHERE constraint_schema = BINARY ##schema::string AND table_name = 
BINARY ##name::string AND constraint_name = BINARY ##name2::string",
 
         /* I_STMT_REF_CONSTRAINTS */
-       "select " CATALOG_NAME " AS constraint_catalog, constraint_schema, table_name, constraint_name, " 
CATALOG_NAME " AS ref_table_cat, constraint_schema, referenced_table_name, unique_constraint_name, 
match_option, update_rule, delete_rule from information_schema.referential_constraints WHERE 
constraint_schema = BINARY ##schema::string AND table_name = BINARY ##name::string AND constraint_name = 
BINARY ##name2::string",
+       "select " CATALOG_NAME " AS constraint_catalog, constraint_schema, table_name, constraint_name, " 
CATALOG_NAME " AS ref_table_cat, constraint_schema, referenced_table_name, unique_constraint_name, 
match_option, update_rule, delete_rule from information_schema.referential_constraints WHERE 
constraint_schema = BINARY ##schema::string AND table_name = BINARY ##name::string AND constraint_name = 
BINARY ##name2::string AND unique_constraint_name IS NOT NULL",
 
         /* I_STMT_REF_CONSTRAINTS_ALL */
-       "select " CATALOG_NAME " AS constraint_catalog, constraint_schema, table_name, constraint_name, " 
CATALOG_NAME " AS ref_table_cat, constraint_schema, referenced_table_name, unique_constraint_name, 
match_option, update_rule, delete_rule from information_schema.referential_constraints",
+       "select " CATALOG_NAME " AS constraint_catalog, constraint_schema, table_name, constraint_name, " 
CATALOG_NAME " AS ref_table_cat, constraint_schema, referenced_table_name, unique_constraint_name, 
match_option, update_rule, delete_rule from information_schema.referential_constraints WHERE 
unique_constraint_name IS NOT NULL",
 
         /* I_STMT_KEY_COLUMN_USAGE */
        "SELECT " CATALOG_NAME " AS table_catalog, table_schema, table_name, constraint_name, column_name, 
ordinal_position FROM INFORMATION_SCHEMA.key_column_usage WHERE table_schema = BINARY ##schema::string AND 
table_name = BINARY ##name::string AND constraint_name = BINARY ##name2::string",