15
15
CREATE TABLE t1 (col1 date);
16
16
INSERT INTO t1 VALUES('2004-01-01'),('2004-02-29');
18
17
INSERT INTO t1 VALUES('0000-10-31');
20
19
# All test cases expected to fail should return
101
100
CREATE TABLE t1 (col1 datetime);
102
101
INSERT INTO t1 VALUES('2004-10-31 15:30:00'),('2004-02-29 15:30:00');
104
102
INSERT INTO t1 VALUES('0000-10-31 15:30:00');
106
104
# All test cases expected to fail should return
1208
1200
comment '123456789*123456789*123456789*123456789*123456789*123456789*';
1209
1201
show create table t1;
1205
# Bug #26359: Strings becoming truncated and converted to numbers under STRICT mode
1207
set sql_mode= 'traditional';
1208
create table t1(col1 tinyint, col2 tinyint unsigned,
1209
col3 smallint, col4 smallint unsigned,
1210
col5 mediumint, col6 mediumint unsigned,
1211
col7 int, col8 int unsigned,
1212
col9 bigint, col10 bigint unsigned);
1214
insert into t1(col1) values('-');
1216
insert into t1(col2) values('+');
1218
insert into t1(col3) values('-');
1220
insert into t1(col4) values('+');
1222
insert into t1(col5) values('-');
1224
insert into t1(col6) values('+');
1226
insert into t1(col7) values('-');
1228
insert into t1(col8) values('+');
1230
insert into t1(col9) values('-');
1232
insert into t1(col10) values('+');
1236
# Bug #27176: Assigning a string to an year column has unexpected results
1238
set sql_mode='traditional';
1239
create table t1(a year);
1241
insert into t1 values ('-');
1243
insert into t1 values ('+');
1245
insert into t1 values ('');
1247
insert into t1 values ('2000a');
1249
insert into t1 values ('2E3x');
1253
# Bug#27069 set with identical elements are created
1255
set sql_mode='traditional';
1257
create table t1 (f1 set('a','a'));
1259
create table t1 (f1 enum('a','a'));
1262
# Bug #22824: strict, datetime, NULL, wrong warning
1264
set @@sql_mode='NO_ZERO_DATE';
1265
create table t1(a datetime not null);
1266
select count(*) from t1 where a is null;
1269
--echo End of 5.0 tests