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
15DROP 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
21if ($mysql_errname)
22{
23  --let $functionality = CHARACTER SET
24  --source unexpected_result.inc
25}
26if (!$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
51