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