Debian Codegraph @

mysql-test/suite/storage_engine/describe.test

raw
1 #
2 # DESCRIBE statement
3 #
4 # Note: the output might well be different
5 # (depending on default values for the engine).
6 # Examine mismatch carefully and, if columns are shown
7 # with correct options, add an rdiff.
8 # If you create combinations (with different startup options),
9 # you might have to add an rdiff for each of them.
10 #
11
12 --source have_engine.inc
13
14 --disable_warnings
15 DROP TABLE IF EXISTS t1, t2, t3;
16 --enable_warnings
17
18 --let $create_definition = a $int_col, b $char_col
19 --let $table_options = CHARACTER SET utf8
20 --source create_table.inc
21 if ($mysql_errname)
22 {
23 --let $functionality = CHARACTER SET
24 --source unexpected_result.inc
25 }
26 if (!$mysql_errname)
27 {
28 INSERT INTO t1 (a,b) VALUES (100,'foo'),(2, 'b');
29
30 --let $create_definition = a $int_col, b $char_col
31 --let $table_options = CHARACTER SET utf8
32 --let $table_name = t2
33 --source create_table.inc
34
35 INSERT INTO t2 (a,b) VALUES (1, 'bar');
36
37 --let $create_definition = a $int_col, b $char_col
38 --let $table_name = t3
39 --let $table_options = CHARACTER SET utf8
40 --source create_table.inc
41
42 DESCRIBE t1;
43 DESC t2 a;
44 DESCRIBE t3 '%';
45
46 DROP TABLE t1, t2, t3;
47 }
48
49 --source cleanup_engine.inc
50