10 lines
414 B
Plaintext
10 lines
414 B
Plaintext
drop table if exists t;
|
|
create table t(d date);
|
|
replace into t values ('2004-04-31');
|
|
Error 1292 (22007): Incorrect date value: '2004-04-31' for column 'd' at row 1
|
|
replace /*+ SET_VAR(sql_mode='ALLOW_INVALID_DATES') */ into t values ('2004-04-31');
|
|
drop table if exists t;
|
|
create table t(a INT, KEY(a));
|
|
insert /*+ SET_VAR(sql_mode='') */ into t values (2);
|
|
replace /*+ SET_VAR(sql_mode='') */ into t values (2);
|