mirror of
https://github.com/MariaDB/server.git
synced 2025-02-18 19:35:36 +01:00
284 lines
17 KiB
Text
284 lines
17 KiB
Text
--disable_warnings
|
|
DROP TABLE IF EXISTS t4;
|
|
--enable_warnings
|
|
CREATE TABLE t4(c1 TINYINT ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 INT ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 INTEGER ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 BIGINT ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DEC ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 FIXED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 REAL ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DOUBLE PRECISION ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 FLOAT ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DEC ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 FIXED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DOUBLE PRECISION ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
|
|
SHOW TABLES;
|
|
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
|
|
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
|
|
SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
|
|
|