1
drop table if exists t1,t2;
2
drop table if exists t1aa,t2aa;
3
drop database if exists mysqltest;
4
drop database if exists mysqltest1;
5
create table t1 (a int not null primary key, b int not null,c int not null, key(b,c));
6
insert into t1 values (1,2,2),(2,2,3),(3,2,4),(4,2,4);
7
-- Here we enable metadata just to check that the collation of the
8
-- resultset is non-binary for string type. This should be changed
9
-- after Bug#29394 is implemented.
11
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
12
def Table 8 512 7 Y 0 31 45
13
def Op 8 40 5 Y 0 31 45
14
def Msg_type 8 40 6 Y 0 31 45
15
def Msg_text 8 1020 2 Y 0 31 45
16
Table Op Msg_type Msg_text
17
test.t1 check status OK
19
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
20
def Table 8 512 7 Y 0 31 45
21
def Op 8 40 5 Y 0 31 45
22
def Msg_type 8 40 6 Y 0 31 45
23
def Msg_text 8 1020 2 Y 0 31 45
24
Table Op Msg_type Msg_text
25
test.t1 check status OK
26
check table t1 changed;
27
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
28
def Table 8 512 7 Y 0 31 45
29
def Op 8 40 5 Y 0 31 45
30
def Msg_type 8 40 6 Y 0 31 45
31
def Msg_text 8 1020 2 Y 0 31 45
32
Table Op Msg_type Msg_text
33
test.t1 check status OK
34
insert into t1 values (5,5,5);
35
check table t1 changed;
36
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
37
def Table 8 512 7 Y 0 31 45
38
def Op 8 40 5 Y 0 31 45
39
def Msg_type 8 40 6 Y 0 31 45
40
def Msg_text 8 1020 2 Y 0 31 45
41
Table Op Msg_type Msg_text
42
test.t1 check status OK
43
check table t1 medium;
44
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
45
def Table 8 512 7 Y 0 31 45
46
def Op 8 40 5 Y 0 31 45
47
def Msg_type 8 40 6 Y 0 31 45
48
def Msg_text 8 1020 2 Y 0 31 45
49
Table Op Msg_type Msg_text
50
test.t1 check status OK
51
check table t1 extended;
52
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
53
def Table 8 512 7 Y 0 31 45
54
def Op 8 40 5 Y 0 31 45
55
def Msg_type 8 40 6 Y 0 31 45
56
def Msg_text 8 1020 2 Y 0 31 45
57
Table Op Msg_type Msg_text
58
test.t1 check status OK
60
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
61
def STATISTICS TABLE_NAME Table 8 256 2 N 1 0 45
62
def STATISTICS NON_UNIQUE Non_unique 5 1 1 N 32769 0 63
63
def STATISTICS INDEX_NAME Key_name 8 256 7 N 1 0 45
64
def STATISTICS SEQ_IN_INDEX Seq_in_index 5 2 1 N 32769 0 63
65
def STATISTICS COLUMN_NAME Column_name 8 256 1 N 1 0 45
66
def STATISTICS COLLATION Collation 8 4 1 Y 0 0 45
67
def STATISTICS CARDINALITY Cardinality 5 21 1 Y 32768 0 63
68
def STATISTICS SUB_PART Sub_part 5 3 0 Y 32768 0 63
69
def STATISTICS PACKED Packed 8 40 0 Y 0 0 45
70
def STATISTICS NULLABLE Null 8 12 0 N 1 0 45
71
def STATISTICS INDEX_TYPE Index_type 8 64 5 N 1 0 45
72
def STATISTICS COMMENT Comment 8 64 0 Y 0 0 45
73
def STATISTICS INDEX_COMMENT Index_Comment 8 4096 0 N 1 0 45
74
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
75
t1 0 PRIMARY 1 a A 5 NULL NULL BTREE
76
t1 1 b 1 b A 5 NULL NULL BTREE
77
t1 1 b 2 c A 5 NULL NULL BTREE
78
insert into t1 values (5,5,5);
79
ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
80
-- Here we enable metadata just to check that the collation of the
81
-- resultset is non-binary for string type. This should be changed
82
-- after Bug#29394 is implemented.
84
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
85
def Table 8 512 7 Y 0 31 45
86
def Op 8 40 8 Y 0 31 45
87
def Msg_type 8 40 6 Y 0 31 45
88
def Msg_text 8 1020 2 Y 0 31 45
89
Table Op Msg_type Msg_text
90
test.t1 optimize status OK
92
Table Op Msg_type Msg_text
93
test.t1 optimize status OK
95
-- Here we enable metadata just to check that the collation of the
96
-- resultset is non-binary for string type. This should be changed
97
-- after Bug#29394 is implemented.
98
show variables like "server_id%";
99
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
100
def VARIABLES VARIABLE_NAME Variable_name 8 256 9 N 1 0 45
101
def VARIABLES VARIABLE_VALUE Value 8 65200 1 Y 0 0 45
104
show variables like "SERVER_id%";
105
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
106
def VARIABLES VARIABLE_NAME Variable_name 8 256 9 N 1 0 45
107
def VARIABLES VARIABLE_VALUE Value 8 65200 1 Y 0 0 45
110
show variables like "this_doesn't_exists%";
111
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
112
def VARIABLES VARIABLE_NAME Variable_name 8 256 0 N 1 0 45
113
def VARIABLES VARIABLE_VALUE Value 8 65200 0 Y 0 0 45
115
show table status from test like "this_doesn't_exists%";
116
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
117
def TABLES TABLE_NAME Name 8 256 0 N 1 0 45
118
def TABLES ENGINE Engine 8 256 0 Y 0 0 45
119
def TABLES VERSION Version 5 21 0 Y 32768 0 63
120
def TABLES ROW_FORMAT Row_format 8 40 0 Y 0 0 45
121
def TABLES TABLE_ROWS Rows 5 21 0 Y 32768 0 63
122
def TABLES AVG_ROW_LENGTH Avg_row_length 5 21 0 Y 32768 0 63
123
def TABLES DATA_LENGTH Data_length 5 21 0 Y 32768 0 63
124
def TABLES MAX_DATA_LENGTH Max_data_length 5 21 0 Y 32768 0 63
125
def TABLES INDEX_LENGTH Index_length 5 21 0 Y 32768 0 63
126
def TABLES DATA_FREE Data_free 5 21 0 Y 32768 0 63
127
def TABLES AUTO_INCREMENT Auto_increment 5 21 0 Y 32768 0 63
128
def TABLES CREATE_TIME Create_time 6 19 0 Y 128 0 63
129
def TABLES UPDATE_TIME Update_time 6 19 0 Y 128 0 63
130
def TABLES CHECK_TIME Check_time 6 19 0 Y 128 0 63
131
def TABLES TABLE_COLLATION Collation 8 256 0 Y 0 0 45
132
def TABLES CHECKSUM Checksum 5 21 0 Y 32768 0 63
133
def TABLES CREATE_OPTIONS Create_options 8 1020 0 Y 0 0 45
134
def TABLES TABLE_COMMENT Comment 8 8192 0 N 1 0 45
135
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
137
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
138
def SCHEMATA SCHEMA_NAME Database 8 256 18 N 1 0 45
144
show databases like "test%";
145
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
146
def SCHEMATA SCHEMA_NAME Database (test%) 8 256 4 N 1 0 45
149
create table t1 (f1 int not null, f2 int not null, f3 int not null, f4 int not null, primary key(f1,f2,f3,f4));
150
insert into t1 values (1,1,1,0),(1,1,2,0),(1,1,3,0),(1,2,1,0),(1,2,2,0),(1,2,3,0),(1,3,1,0),(1,3,2,0),(1,3,3,0),(1,1,1,1),(1,1,2,1),(1,1,3,1),(1,2,1,1),(1,2,2,1),(1,2,3,1),(1,3,1,1),(1,3,2,1),(1,3,3,1);
151
-- Here we enable metadata just to check that the collation of the
152
-- resultset is non-binary for string type. This should be changed
153
-- after Bug#29394 is implemented.
155
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
156
def Table 8 512 7 Y 0 31 45
157
def Op 8 40 7 Y 0 31 45
158
def Msg_type 8 40 6 Y 0 31 45
159
def Msg_text 8 1020 2 Y 0 31 45
160
Table Op Msg_type Msg_text
161
test.t1 analyze status OK
163
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
164
t1 0 PRIMARY 1 f1 A 18 NULL NULL BTREE
165
t1 0 PRIMARY 2 f2 A 18 NULL NULL BTREE
166
t1 0 PRIMARY 3 f3 A 18 NULL NULL BTREE
167
t1 0 PRIMARY 4 f4 A 18 NULL NULL BTREE
169
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
170
t1 0 PRIMARY 1 f1 A 18 NULL NULL BTREE
171
t1 0 PRIMARY 2 f2 A 18 NULL NULL BTREE
172
t1 0 PRIMARY 3 f3 A 18 NULL NULL BTREE
173
t1 0 PRIMARY 4 f4 A 18 NULL NULL BTREE
175
create temporary table t1 (a int not null);
176
show create table t1;
178
t1 CREATE TEMPORARY TABLE `t1` (
181
alter table t1 rename t2;
182
show create table t2;
184
t2 CREATE TEMPORARY TABLE `t2` (
189
name char(20) default 'O''Brien' comment 'O''Brien as default',
190
c int not null comment 'int column',
191
`c-b` int comment 'name with a minus',
192
`space 2` int comment 'name with a space'
193
) comment = 'it\'s a table' ;
194
show create table t1;
196
t1 CREATE TABLE `t1` (
197
`name` varchar(20) DEFAULT 'O''Brien' COMMENT 'O''Brien as default',
198
`c` int NOT NULL COMMENT 'int column',
199
`c-b` int DEFAULT NULL COMMENT 'name with a minus',
200
`space 2` int DEFAULT NULL COMMENT 'name with a space'
201
) ENGINE=DEFAULT COMMENT='it''s a table'
202
show full columns from t1;
203
Field Type Collation Null Key Default Extra Privileges Comment
204
name varchar(20) utf8_general_ci YES O'Brien O'Brien as default
205
c int NULL NO NULL int column
206
c-b int NULL YES NULL name with a minus
207
space 2 int NULL YES NULL name with a space
209
create table t1 (a int not null, unique aa (a));
210
show create table t1;
212
t1 CREATE TABLE `t1` (
214
UNIQUE KEY `aa` (`a`)
217
create table t1 (a int not null, primary key (a));
218
show create table t1;
220
t1 CREATE TABLE `t1` (
227
Database Table In_use Name_locked
228
create table t1(n int);
229
insert into t1 values (1);
231
Database Table In_use Name_locked
234
create temporary table t1 (a int not null, b VARCHAR(10), INDEX (b) ) COMMENT="test" ENGINE=MYISAM ROW_FORMAT=fixed;
235
show create table t1;
237
t1 CREATE TEMPORARY TABLE `t1` (
239
`b` varchar(10) DEFAULT NULL,
241
) ENGINE=MyISAM ROW_FORMAT=FIXED COMMENT='test'
242
alter table t1 ROW_FORMAT=dynamic;
243
show create table t1;
245
t1 CREATE TEMPORARY TABLE `t1` (
247
`b` varchar(10) DEFAULT NULL,
249
) ENGINE=MyISAM ROW_FORMAT=DYNAMIC COMMENT='test'
250
ALTER TABLE t1 COMMENT="" ROW_FORMAT=default;
251
show create table t1;
253
t1 CREATE TEMPORARY TABLE `t1` (
255
`b` varchar(10) DEFAULT NULL,
259
create table t1 (a decimal(9,2), b decimal (9,0), e double(9,2), f double(5,0), h float(3,2), i float(3,0));
260
show columns from t1;
261
Field Type Null Key Default Extra
262
a decimal(9,2) YES NULL
263
b decimal(9,0) YES NULL
264
e double(9,2) YES NULL
265
f double(5,0) YES NULL
266
h double(3,2) YES NULL
267
i double(3,0) YES NULL
268
show full columns from t1;
269
Field Type Collation Null Key Default Extra Privileges Comment
270
a decimal(9,2) NULL YES NULL
271
b decimal(9,0) NULL YES NULL
272
e double(9,2) NULL YES NULL
273
f double(5,0) NULL YES NULL
274
h double(3,2) NULL YES NULL
275
i double(3,0) NULL YES NULL
277
create temporary table t1 (
280
type_decimal decimal(5,2),
281
type_numeric numeric(5,2),
284
type_varchar varchar(10),
285
type_timestamp timestamp not null,
287
type_datetime datetime,
288
type_enum enum ('red', 'green', 'blue'),
289
type_set enum ('red', 'green', 'blue'),
292
) COMMENT="test" ENGINE=MYISAM ROW_FORMAT=fixed;
293
show create table t1;
295
t1 CREATE TEMPORARY TABLE `t1` (
296
`type_int` int DEFAULT NULL,
297
`type_bigint` bigint DEFAULT NULL,
298
`type_decimal` decimal(5,2) DEFAULT NULL,
299
`type_numeric` decimal(5,2) DEFAULT NULL,
300
`empty_char` varchar(0) DEFAULT NULL,
301
`type_char` varchar(2) DEFAULT NULL,
302
`type_varchar` varchar(10) DEFAULT NULL,
303
`type_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
304
`type_date` date DEFAULT NULL,
305
`type_datetime` datetime DEFAULT NULL,
306
`type_enum` enum('red','green','blue') DEFAULT NULL,
307
`type_set` enum('red','green','blue') DEFAULT NULL,
309
KEY `type_int` (`type_int`)
310
) ENGINE=MyISAM ROW_FORMAT=FIXED COMMENT='test'
311
insert into t1 (type_timestamp) values ("2003-02-07 10:00:01");
313
type_int type_bigint type_decimal type_numeric empty_char type_char type_varchar type_timestamp type_date type_datetime type_enum type_set type_blob
314
NULL NULL NULL NULL NULL NULL NULL 2003-02-07 10:00:01 NULL NULL NULL NULL NULL
316
create table t1 (a int not null);
317
create table t2 select max(a) from t1;
318
show columns from t2;
319
Field Type Null Key Default Extra
322
create table t1 (c decimal, d double, f float, r real);
323
show columns from t1;
324
Field Type Null Key Default Extra
325
c decimal(10,0) YES NULL
330
create table t1 (c decimal(3,3), d double(3,3), f float(3,3));
331
show columns from t1;
332
Field Type Null Key Default Extra
333
c decimal(3,3) YES NULL
334
d double(3,3) YES NULL
335
f double(3,3) YES NULL
337
CREATE TABLE ```ab``cd``` (i INT);
338
SHOW CREATE TABLE ```ab``cd```;
340
`ab`cd` CREATE TABLE ```ab``cd``` (
343
DROP TABLE ```ab``cd```;
344
CREATE TABLE ```ab````cd``` (i INT);
345
SHOW CREATE TABLE ```ab````cd```;
347
`ab``cd` CREATE TABLE ```ab````cd``` (
350
DROP TABLE ```ab````cd```;
351
CREATE TABLE ```a` (i INT);
352
SHOW CREATE TABLE ```a`;
354
`a CREATE TABLE ```a` (
358
CREATE TABLE `a.1` (i INT);
359
SHOW CREATE TABLE `a.1`;
361
a.1 CREATE TABLE `a.1` (
365
select @@max_heap_table_size;
366
@@max_heap_table_size
368
CREATE TEMPORARY TABLE t1 (
370
KEY a USING BTREE (a)
372
CREATE TEMPORARY TABLE t2 (
376
CREATE TEMPORARY TABLE t3 (
379
KEY a USING BTREE (a),
382
insert into t1 values (1),(2);
383
insert into t2 values (1),(2);
384
insert into t3 values (1,1),(2,2);
386
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
387
insert into t1 values (3),(4);
388
insert into t2 values (3),(4);
389
insert into t3 values (3,3),(4,4);
391
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
392
insert into t1 values (5);
393
insert into t2 values (5);
394
insert into t3 values (5,5);
396
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
397
delete from t1 where a=3;
398
delete from t2 where b=3;
399
delete from t3 where a=3;
401
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
406
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
407
insert into t1 values (5);
408
insert into t2 values (5);
409
insert into t3 values (5,5);
411
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
412
delete from t1 where a=5;
413
delete from t2 where b=5;
414
delete from t3 where a=5;
416
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
417
drop table t1, t2, t3;
418
CREATE TEMPORARY TABLE t1 (i int, KEY (i)) ENGINE=MEMORY;
419
SHOW CREATE TABLE t1;
421
t1 CREATE TEMPORARY TABLE `t1` (
422
`i` int DEFAULT NULL,
426
CREATE TEMPORARY TABLE t1 (i int, KEY USING HASH (i)) ENGINE=MEMORY;
427
SHOW CREATE TABLE t1;
429
t1 CREATE TEMPORARY TABLE `t1` (
430
`i` int DEFAULT NULL,
431
KEY `i` (`i`) USING HASH
434
CREATE TEMPORARY TABLE t1 (i int, KEY USING BTREE (i)) ENGINE=MEMORY;
435
SHOW CREATE TABLE t1;
437
t1 CREATE TEMPORARY TABLE `t1` (
438
`i` int DEFAULT NULL,
439
KEY `i` (`i`) USING BTREE
442
CREATE TEMPORARY TABLE t1 (i int, KEY (i)) ENGINE=MyISAM;
443
SHOW CREATE TABLE t1;
445
t1 CREATE TEMPORARY TABLE `t1` (
446
`i` int DEFAULT NULL,
450
CREATE TEMPORARY TABLE t1 (i int, KEY USING BTREE (i)) ENGINE=MyISAM;
451
SHOW CREATE TABLE t1;
453
t1 CREATE TEMPORARY TABLE `t1` (
454
`i` int DEFAULT NULL,
455
KEY `i` (`i`) USING BTREE
458
CREATE TEMPORARY TABLE t1 (i int, KEY (i)) ENGINE=MyISAM;
459
SHOW CREATE TABLE t1;
461
t1 CREATE TEMPORARY TABLE `t1` (
462
`i` int DEFAULT NULL,
465
ALTER TABLE t1 ENGINE=MEMORY;
466
SHOW CREATE TABLE t1;
468
t1 CREATE TEMPORARY TABLE `t1` (
469
`i` int DEFAULT NULL,
473
CREATE TEMPORARY TABLE t1 (i int, KEY USING BTREE (i)) ENGINE=MyISAM;
474
SHOW CREATE TABLE t1;
476
t1 CREATE TEMPORARY TABLE `t1` (
477
`i` int DEFAULT NULL,
478
KEY `i` (`i`) USING BTREE
480
ALTER TABLE t1 ENGINE=MEMORY;
481
SHOW CREATE TABLE t1;
483
t1 CREATE TEMPORARY TABLE `t1` (
484
`i` int DEFAULT NULL,
485
KEY `i` (`i`) USING BTREE
489
field1 text NOT NULL,
490
PRIMARY KEY(field1(180))
493
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
494
def STATISTICS TABLE_NAME Table 8 256 2 N 1 0 45
495
def STATISTICS NON_UNIQUE Non_unique 5 1 1 N 32769 0 63
496
def STATISTICS INDEX_NAME Key_name 8 256 7 N 1 0 45
497
def STATISTICS SEQ_IN_INDEX Seq_in_index 5 2 1 N 32769 0 63
498
def STATISTICS COLUMN_NAME Column_name 8 256 6 N 1 0 45
499
def STATISTICS COLLATION Collation 8 4 1 Y 0 0 45
500
def STATISTICS CARDINALITY Cardinality 5 21 1 Y 32768 0 63
501
def STATISTICS SUB_PART Sub_part 5 3 3 Y 32768 0 63
502
def STATISTICS PACKED Packed 8 40 0 Y 0 0 45
503
def STATISTICS NULLABLE Null 8 12 0 N 1 0 45
504
def STATISTICS INDEX_TYPE Index_type 8 64 5 N 1 0 45
505
def STATISTICS COMMENT Comment 8 64 0 Y 0 0 45
506
def STATISTICS INDEX_COMMENT Index_Comment 8 4096 0 N 1 0 45
507
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
508
t1 0 PRIMARY 1 field1 A 0 180 NULL BTREE
513
PRIMARY KEY USING HASH (c1),
514
INDEX USING BTREE(c2)
516
SHOW CREATE TABLE t1;
518
t1 CREATE TABLE `t1` (
521
PRIMARY KEY (`c1`) USING HASH,
522
KEY `c2` (`c2`) USING BTREE
526
# Bug#12183: SHOW OPEN TABLES behavior doesn't match grammar.
528
DROP DATABASE IF EXISTS mysqltest1;
529
CREATE DATABASE mysqltest1;
532
CREATE TABLE t1(a INT);
533
CREATE TABLE t2(a INT);
542
SHOW OPEN TABLES FROM mysqltest1;
543
Database Table In_use Name_locked
547
SHOW OPEN TABLES FROM mysqltest1 LIKE 'z%';
548
Database Table In_use Name_locked
550
SHOW OPEN TABLES FROM mysqltest1 LIKE 't1%';
551
Database Table In_use Name_locked
554
SHOW OPEN TABLES FROM mysqltest1 LIKE '%1%';
555
Database Table In_use Name_locked
560
DROP DATABASE mysqltest1;
563
SHOW TABLES FROM non_existing_database;
564
ERROR 42000: Unknown database 'non_existing_database'
566
SHOW TABLES FROM no_such_database;
567
ERROR 42000: Unknown database 'no_such_database'
568
SHOW COLUMNS FROM no_such_table;
569
ERROR 42S02: Table 'test.no_such_table' doesn't exist
570
show variables like 'myisam_recover_options';
573
create database `mysqlttest\1`;
574
create table `mysqlttest\1`.`a\b` (a int);
575
show tables from `mysqlttest\1`;
576
Tables_in_mysqlttest\1
578
show fields from `mysqlttest\1`.`a\b`;
579
Field Type Null Key Default Extra
581
show columns from `a\b` from `mysqlttest\1`;
582
Field Type Null Key Default Extra
584
show keys from `mysqlttest\1`.`a\b`;
585
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
586
drop table `mysqlttest\1`.`a\b`;
587
drop database `mysqlttest\1`;
588
show engine foobar status;
589
ERROR 42000: Unknown table engine 'foobar'
590
show engine foobar logs;
591
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'logs' at line 1
592
show engine foobar mutex;
593
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'mutex' at line 1
594
show engine mutex status;
595
ERROR 42000: Unknown table engine 'mutex'
596
show engine csv status;
598
drop table if exists `été`;
599
create table `été` (field1 int);
601
Tables_in_test Table_type
604
show columns from `#mysql50#????????`;
605
Got one of the listed errors