diff options
Diffstat (limited to 'mysql-test/suite/parts/r/partition_alter2_2_1_innodb.result')
| -rw-r--r-- | mysql-test/suite/parts/r/partition_alter2_2_1_innodb.result | 280 |
1 files changed, 156 insertions, 124 deletions
diff --git a/mysql-test/suite/parts/r/partition_alter2_2_1_innodb.result b/mysql-test/suite/parts/r/partition_alter2_2_1_innodb.result index 1f4642f63ec..2c8ec37d844 100644 --- a/mysql-test/suite/parts/r/partition_alter2_2_1_innodb.result +++ b/mysql-test/suite/parts/r/partition_alter2_2_1_innodb.result @@ -11,8 +11,8 @@ SELECT @max_row DIV 4 INTO @max_row_div4; SET @max_int_4 = 2147483647; DROP TABLE IF EXISTS t0_template; CREATE TABLE t0_template ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) , @@ -27,8 +27,8 @@ file_list VARBINARY(10000), PRIMARY KEY (state) ) ENGINE = MEMORY; DROP TABLE IF EXISTS t0_aux; -CREATE TABLE t0_aux ( f_int1 INTEGER, -f_int2 INTEGER, +CREATE TABLE t0_aux ( f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) ) @@ -48,8 +48,8 @@ SET @@session.sql_mode= ''; # 2.1.1 no PRIMARY KEY or UNIQUE INDEX exists DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -68,7 +68,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -506,8 +506,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -526,7 +526,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -964,8 +964,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -992,7 +992,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -1437,8 +1437,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -1463,7 +1463,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -1902,8 +1902,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -1926,7 +1926,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -2369,8 +2369,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -2397,7 +2397,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -2843,8 +2843,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -2871,7 +2871,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -3321,8 +3321,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -3345,7 +3345,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -3788,8 +3788,8 @@ TRUNCATE t1; DROP TABLE t1; DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -3809,7 +3809,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -4250,6 +4250,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -4282,8 +4284,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -4303,7 +4305,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -4744,6 +4746,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -4776,8 +4780,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -4805,7 +4809,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -5253,6 +5257,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -5285,8 +5291,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -5312,7 +5318,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -5754,6 +5760,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -5786,8 +5794,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -5811,7 +5819,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -6257,6 +6265,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -6289,8 +6299,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -6318,7 +6328,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -6767,6 +6777,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -6799,8 +6811,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -6828,7 +6840,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -7281,6 +7293,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -7313,8 +7327,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -7338,7 +7352,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -7783,6 +7797,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -7816,8 +7832,8 @@ TRUNCATE t1; DROP TABLE t1; DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -7837,7 +7853,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -8278,6 +8294,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -8310,8 +8328,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -8331,7 +8349,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -8772,6 +8790,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -8804,8 +8824,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -8833,7 +8853,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -9281,6 +9301,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -9313,8 +9335,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -9340,7 +9362,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -9782,6 +9804,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -9814,8 +9838,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -9839,7 +9863,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -10285,6 +10309,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -10317,8 +10343,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -10346,7 +10372,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -10795,6 +10821,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -10827,8 +10855,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -10856,7 +10884,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -11309,6 +11337,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -11341,8 +11371,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -11366,7 +11396,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` mediumint(9) NOT NULL DEFAULT '0', + `f_int2` mediumint(9) NOT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, @@ -11811,6 +11841,8 @@ SELECT CAST(f_int1 AS CHAR), CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; +Warnings: +Warning 1364 Field 'f_int2' doesn't have a default value DROP TRIGGER trg_3; # check trigger-12 success: 1 @@ -11845,8 +11877,8 @@ DROP TABLE t1; # 2.1.3 UNIQUE INDEX exists DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -11865,7 +11897,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -12355,8 +12387,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -12375,7 +12407,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -12865,8 +12897,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -12893,7 +12925,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -13390,8 +13422,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -13416,7 +13448,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -13907,8 +13939,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -13931,7 +13963,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -14426,8 +14458,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -14454,7 +14486,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -14952,8 +14984,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -14980,7 +15012,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -15482,8 +15514,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -15506,7 +15538,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -16001,8 +16033,8 @@ TRUNCATE t1; DROP TABLE t1; DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -16021,7 +16053,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -16511,8 +16543,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -16531,7 +16563,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -17021,8 +17053,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -17049,7 +17081,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -17546,8 +17578,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -17572,7 +17604,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -18063,8 +18095,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -18087,7 +18119,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -18582,8 +18614,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -18610,7 +18642,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -19108,8 +19140,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -19136,7 +19168,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, @@ -19638,8 +19670,8 @@ TRUNCATE t1; # End usability test (inc/partition_check.inc) DROP TABLE t1; CREATE TABLE t1 ( -f_int1 INTEGER, -f_int2 INTEGER, +f_int1 INTEGER DEFAULT 0, +f_int2 INTEGER DEFAULT 0, f_char1 CHAR(20), f_char2 CHAR(20), f_charbig VARCHAR(1000) @@ -19662,7 +19694,7 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT NULL, + `f_int1` int(11) DEFAULT '0', `f_int2` mediumint(9) DEFAULT NULL, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, |