mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
50 lines
1.2 KiB
Text
50 lines
1.2 KiB
Text
#
|
|
# DESCRIBE statement
|
|
#
|
|
# Note: the output might well be different
|
|
# (depending on default values for the engine).
|
|
# Examine mismatch carefully and, if columns are shown
|
|
# with correct options, add an rdiff.
|
|
# If you create combinations (with different startup options),
|
|
# you might have to add an rdiff for each of them.
|
|
#
|
|
|
|
--source have_engine.inc
|
|
|
|
--disable_warnings
|
|
DROP TABLE IF EXISTS t1, t2, t3;
|
|
--enable_warnings
|
|
|
|
--let $create_definition = a $int_col, b $char_col
|
|
--let $table_options = CHARACTER SET utf8
|
|
--source create_table.inc
|
|
if ($mysql_errname)
|
|
{
|
|
--let $functionality = CHARACTER SET
|
|
--source unexpected_result.inc
|
|
}
|
|
if (!$mysql_errname)
|
|
{
|
|
INSERT INTO t1 (a,b) VALUES (100,'foo'),(2, 'b');
|
|
|
|
--let $create_definition = a $int_col, b $char_col
|
|
--let $table_options = CHARACTER SET utf8
|
|
--let $table_name = t2
|
|
--source create_table.inc
|
|
|
|
INSERT INTO t2 (a,b) VALUES (1, 'bar');
|
|
|
|
--let $create_definition = a $int_col, b $char_col
|
|
--let $table_name = t3
|
|
--let $table_options = CHARACTER SET utf8
|
|
--source create_table.inc
|
|
|
|
DESCRIBE t1;
|
|
DESC t2 a;
|
|
DESCRIBE t3 '%';
|
|
|
|
DROP TABLE t1, t2, t3;
|
|
}
|
|
|
|
--source cleanup_engine.inc
|
|
|