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'
8 ORDER BY table_schema,table_name,constraint_name;
9 CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE
10 def mysql PRIMARY mysql columns_priv PRIMARY KEY
11 def mysql PRIMARY mysql column_stats PRIMARY KEY
12 def mysql PRIMARY mysql db PRIMARY KEY
13 def mysql PRIMARY mysql event PRIMARY KEY
14 def mysql PRIMARY mysql func PRIMARY KEY
15 def mysql PRIMARY mysql global_priv PRIMARY KEY
16 def mysql Priv mysql global_priv CHECK
17 def mysql PRIMARY mysql gtid_slave_pos PRIMARY KEY
18 def mysql name mysql help_category UNIQUE
19 def mysql PRIMARY mysql help_category PRIMARY KEY
20 def mysql name mysql help_keyword UNIQUE
21 def mysql PRIMARY mysql help_keyword PRIMARY KEY
22 def mysql PRIMARY mysql help_relation PRIMARY KEY
23 def mysql name mysql help_topic UNIQUE
24 def mysql PRIMARY mysql help_topic PRIMARY KEY
25 def mysql PRIMARY mysql index_stats PRIMARY KEY
26 def mysql PRIMARY mysql innodb_index_stats PRIMARY KEY
27 def mysql PRIMARY mysql innodb_table_stats PRIMARY KEY
28 def mysql PRIMARY mysql plugin PRIMARY KEY
29 def mysql PRIMARY mysql proc PRIMARY KEY
30 def mysql PRIMARY mysql procs_priv PRIMARY KEY
31 def mysql PRIMARY mysql proxies_priv PRIMARY KEY
32 def mysql Host mysql roles_mapping UNIQUE
33 def mysql Options mysql servers CHECK
34 def mysql PRIMARY mysql servers PRIMARY KEY
35 def mysql PRIMARY mysql tables_priv PRIMARY KEY
36 def mysql PRIMARY mysql table_stats PRIMARY KEY
37 def mysql PRIMARY mysql time_zone PRIMARY KEY
38 def mysql PRIMARY mysql time_zone_leap_second PRIMARY KEY
39 def mysql PRIMARY mysql time_zone_name PRIMARY KEY
40 def mysql PRIMARY mysql time_zone_transition PRIMARY KEY
41 def mysql PRIMARY mysql time_zone_transition_type PRIMARY KEY
42 def mysql commit_id mysql transaction_registry UNIQUE
43 def mysql PRIMARY mysql transaction_registry PRIMARY KEY
44 connect testuser1,localhost,testuser1,,db_datadict;
45 SELECT * FROM information_schema.table_constraints
46 WHERE table_schema = 'mysql'
47 ORDER BY table_schema,table_name,constraint_name;
48 CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE
49 connection default;
50 disconnect testuser1;
51 DROP USER testuser1@localhost;
52 DROP DATABASE db_datadict;