Debian Codegraph @

mysql-test/suite/funcs_1/r/is_table_constraints_mysql.result

raw
1 DROP DATABASE IF EXISTS db_datadict;
2 CREATE DATABASE db_datadict;
3 DROP USER testuser1@localhost;
4 CREATE USER testuser1@localhost;
5 GRANT SELECT ON db_datadict.* TO testuser1@localhost;
6 SELECT * FROM information_schema.table_constraints
7 WHERE table_schema = 'mysql' AND table_name != 'ndb_binlog_index'
8 ORDER BY table_schema,table_name,constraint_name COLLATE utf8_general_ci;
9 CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE ENFORCED
10 def mysql PRIMARY mysql columns_priv PRIMARY KEY YES
11 def mysql PRIMARY mysql component PRIMARY KEY YES
12 def mysql PRIMARY mysql db PRIMARY KEY YES
13 def mysql PRIMARY mysql default_roles PRIMARY KEY YES
14 def mysql PRIMARY mysql engine_cost PRIMARY KEY YES
15 def mysql PRIMARY mysql func PRIMARY KEY YES
16 def mysql PRIMARY mysql global_grants PRIMARY KEY YES
17 def mysql PRIMARY mysql gtid_executed PRIMARY KEY YES
18 def mysql name mysql help_category UNIQUE YES
19 def mysql PRIMARY mysql help_category PRIMARY KEY YES
20 def mysql name mysql help_keyword UNIQUE YES
21 def mysql PRIMARY mysql help_keyword PRIMARY KEY YES
22 def mysql PRIMARY mysql help_relation PRIMARY KEY YES
23 def mysql name mysql help_topic UNIQUE YES
24 def mysql PRIMARY mysql help_topic PRIMARY KEY YES
25 def mysql PRIMARY mysql innodb_index_stats PRIMARY KEY YES
26 def mysql PRIMARY mysql innodb_table_stats PRIMARY KEY YES
27 def mysql PRIMARY mysql password_history PRIMARY KEY YES
28 def mysql PRIMARY mysql plugin PRIMARY KEY YES
29 def mysql PRIMARY mysql procs_priv PRIMARY KEY YES
30 def mysql PRIMARY mysql proxies_priv PRIMARY KEY YES
31 def mysql PRIMARY mysql replication_asynchronous_connection_failover PRIMARY KEY YES
32 def mysql PRIMARY mysql replication_asynchronous_connection_failover_managed PRIMARY KEY YES
33 def mysql PRIMARY mysql replication_group_configuration_version PRIMARY KEY YES
34 def mysql PRIMARY mysql replication_group_member_actions PRIMARY KEY YES
35 def mysql PRIMARY mysql role_edges PRIMARY KEY YES
36 def mysql PRIMARY mysql server_cost PRIMARY KEY YES
37 def mysql PRIMARY mysql servers PRIMARY KEY YES
38 def mysql PRIMARY mysql slave_master_info PRIMARY KEY YES
39 def mysql PRIMARY mysql slave_relay_log_info PRIMARY KEY YES
40 def mysql PRIMARY mysql slave_worker_info PRIMARY KEY YES
41 def mysql PRIMARY mysql tables_priv PRIMARY KEY YES
42 def mysql PRIMARY mysql time_zone PRIMARY KEY YES
43 def mysql PRIMARY mysql time_zone_leap_second PRIMARY KEY YES
44 def mysql PRIMARY mysql time_zone_name PRIMARY KEY YES
45 def mysql PRIMARY mysql time_zone_transition PRIMARY KEY YES
46 def mysql PRIMARY mysql time_zone_transition_type PRIMARY KEY YES
47 def mysql PRIMARY mysql user PRIMARY KEY YES
48 # Establish connection testuser1 (user=testuser1)
49 SELECT * FROM information_schema.table_constraints
50 WHERE table_schema = 'mysql' AND table_name != 'ndb_binlog_index'
51 ORDER BY table_schema,table_name,constraint_name COLLATE utf8_general_ci;
52 CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE ENFORCED
53 # Switch to connection default and close connection testuser1
54 DROP USER testuser1@localhost;
55 DROP DATABASE db_datadict;