Debian Codegraph @

mysql-test/suite/storage_engine/show_table_status.test

raw
1 #
2 # SHOW TABLE STATUS statement
3 #
4 # Note: the output might be different if even with such tiny tables
5 # the number of rows is approximate. In this case rdiff will be needed
6 #
7
8 --source have_engine.inc
9
10 --disable_warnings
11 DROP TABLE IF EXISTS t1, t2, t3;
12 --enable_warnings
13
14 --source create_table.inc
15 INSERT INTO t1 (a,b) VALUES (100,'a'),(2,'foo');
16
17 --let $table_name = t2
18 --source create_table.inc
19 INSERT INTO t2 (a,b) VALUES (1,'bar');
20
21 --let $table_name = t3
22 --let $table_options = CHARACTER SET utf8
23 --source create_table.inc
24
25 --replace_column 2 <STORAGE_ENGINE> 4 ### 6 ### 7 ### 8 ### 9 ### 10 ### 12 ### 13 ### 19 ###
26 --query_vertical SHOW TABLE STATUS WHERE name IN ( 't1', 't2', 't3' )
27 DROP TABLE t1, t2, t3;
28
29 --source cleanup_engine.inc
30