1
# Drizzle's data dictionary.
5
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
6
SELECT count(*) FROM columns;
8
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
9
SELECT count(*) FROM indexes;
11
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
12
SELECT count(*) FROM index_parts;
14
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
15
SELECT SCHEMA_NAME FROM schemas;
17
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
18
SELECT COLUMN_NAME FROM columns;
20
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
21
SELECT count(*) FROM REFERENTIAL_CONSTRAINTS;
23
--replace_column 1 # 6 # 7 # 8 # 9 # 10 #
24
SELECT count(*) FROM TABLE_CONSTRAINTS;
26
# Make sure we don't change the names of the columns
28
show create table COLUMNS ;
29
show create table INDEXES ;
30
show create table INDEX_PARTS ;
31
show create table REFERENTIAL_CONSTRAINTS ;
32
show create table SCHEMAS ;
33
show create table SCHEMA_NAMES;
34
show create table TABLES ;
35
show create table TABLE_CONSTRAINTS ;
37
# Test that the data dictionary is not leaking its tables to other schema
40
create table A (a int);
41
SELECT COUNT(*) FROM data_dictionary.tables WHERE TABLE_NAME = "A";