43
43
key (`col_text_key` (255)),
44
44
key (`col_enum_key` )) ENGINE=innodb;
45
45
set AUTOCOMMIT=OFF;
46
select SQL_BIG_RESULT table_schema,
49
48
CASE WHEN table_type = 'STANDARD' THEN 'table'
50
49
WHEN table_type = 'FUNCTION' then 'function'
81
80
DATA_DICTIONARY COLUMNS function COLUMN_DEFAULT_IS_NULL indexed
82
81
DATA_DICTIONARY COLUMNS function COLUMN_DEFAULT_UPDATE indexed
83
82
DATA_DICTIONARY COLUMNS function IS_NULLABLE indexed
83
CREATE SCHEMA randgen_query_test;
84
USE randgen_query_test;
85
CREATE TABLE t1 (a INT);
86
CREATE TABLE t2 LIKE t1;
87
CREATE TABLE t3 LIKE t1;
88
CREATE TABLE t4 (b CHAR(500));
89
CREATE TABLE t5 LIKE t4;
90
select SQL_BIG_RESULT table_schema,
92
CASE WHEN table_type = 'STANDARD' THEN 'table'
93
WHEN table_type = 'FUNCTION' then 'function'
96
CASE WHEN IS_USED_IN_PRIMARY = 'TRUE' THEN 'primary'
97
WHEN IS_INDEXED = 'TRUE' THEN 'indexed'
99
FROM data_dictionary.tables INNER JOIN
100
data_dictionary.columns USING(table_schema, table_name) WHERE table_schema NOT IN ('DATA_DICTIONARY','INFORMATION_SCHEMA')
101
ORDER BY table_schema, table_name limit 20;
102
table_schema table_name CASE WHEN table_type = 'STANDARD' THEN 'table'
103
WHEN table_type = 'FUNCTION' then 'function'
104
ELSE 'misc' END column_name CASE WHEN IS_USED_IN_PRIMARY = 'TRUE' THEN 'primary'
105
WHEN IS_INDEXED = 'TRUE' THEN 'indexed'
108
randgen_query_test t1 table a indexed
109
randgen_query_test t2 table a indexed
110
randgen_query_test t3 table a indexed
111
randgen_query_test t4 table b indexed
112
randgen_query_test t5 table b indexed
113
test t1 table col_bigint indexed
114
test t1 table col_text indexed
115
test t1 table col_char indexed
116
test t1 table col_enum indexed
117
test t1 table col_int indexed
118
test t1 table col_char_not_null indexed
119
test t1 table col_int_not_null_key indexed
120
test t1 table col_text_not_null indexed
121
test t1 table col_enum_not_null_key indexed
122
test t1 table col_int_key indexed
123
test t1 table col_char_key indexed
124
test t1 table col_enum_not_null indexed
125
test t1 table col_text_not_null_key indexed
126
test t1 table pk primary
127
test t1 table col_bigint_key indexed
128
DROP SCHEMA randgen_query_test;
84
130
select AVG(`col_int_key`) + AVG(`col_int`) AS average1,
85
131
(SUM(`col_int_key`) + SUM(`col_int`)) / COUNT(*) AS average2,
86
132
COUNT(*) AS count FROM t1;