diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ai_overflow_error.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/ai_overflow_error.result | 120 |
1 files changed, 60 insertions, 60 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ai_overflow_error.result b/mysql-test/suite/engines/funcs/r/ai_overflow_error.result index 909eb4cda2c..799dbbedeec 100644 --- a/mysql-test/suite/engines/funcs/r/ai_overflow_error.result +++ b/mysql-test/suite/engines/funcs/r/ai_overflow_error.result @@ -6,7 +6,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` tinyint(4) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -24,7 +24,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` smallint(6) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -42,7 +42,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumint(9) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -60,7 +60,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -78,7 +78,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -96,7 +96,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bigint(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -114,7 +114,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` tinyint(4) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -132,7 +132,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` smallint(6) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -150,7 +150,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumint(9) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -168,7 +168,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -186,7 +186,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -204,7 +204,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bigint(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -222,7 +222,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` tinyint(4) AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -240,7 +240,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` smallint(6) AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -258,7 +258,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumint(9) AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -276,7 +276,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -294,7 +294,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -312,7 +312,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bigint(20) AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -330,7 +330,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` tinyint(4) NOT NULL AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -348,7 +348,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` smallint(6) NOT NULL AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -366,7 +366,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumint(9) NOT NULL AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -384,7 +384,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -402,7 +402,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -420,7 +420,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bigint(20) NOT NULL AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -438,7 +438,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` tinyint(4) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -456,7 +456,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` smallint(6) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -474,7 +474,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumint(9) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -492,7 +492,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -510,7 +510,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -528,7 +528,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bigint(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -546,7 +546,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -564,7 +564,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -582,7 +582,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -600,7 +600,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -618,7 +618,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -636,7 +636,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -654,7 +654,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -672,7 +672,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -690,7 +690,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -708,7 +708,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -726,7 +726,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -744,7 +744,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -762,7 +762,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` tinyint(3) unsigned AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -780,7 +780,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` smallint(5) unsigned AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -798,7 +798,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumint(8) unsigned AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -816,7 +816,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(10) unsigned AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -834,7 +834,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(10) unsigned AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -852,7 +852,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bigint(20) unsigned AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -870,7 +870,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -888,7 +888,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -906,7 +906,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -924,7 +924,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(10) unsigned NOT NULL AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -942,7 +942,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(10) unsigned NOT NULL AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -960,7 +960,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT, UNIQUE KEY `c1` (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -978,7 +978,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -996,7 +996,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -1014,7 +1014,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -1032,7 +1032,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -1050,7 +1050,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); @@ -1068,7 +1068,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci INSERT INTO t1 VALUES(111111111111111111111111111111111111); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(-1111111111111111111111111111111111111); |