diff options
Diffstat (limited to 'mysql-test/r/update.result')
| -rw-r--r-- | mysql-test/r/update.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/update.result b/mysql-test/r/update.result index 73ebb73e313..1172c1cfdec 100644 --- a/mysql-test/r/update.result +++ b/mysql-test/r/update.result @@ -354,6 +354,8 @@ a b drop table t1; create table t1 (f1 date not null); insert into t1 values('2000-01-01'),('0000-00-00'); +Warnings: +Warning 1264 Out of range value for column 'f1' at row 2 update t1 set f1='2002-02-02' where f1 is null; select * from t1; f1 @@ -399,6 +401,7 @@ create table t1(f1 int); update t1 set f2=1 order by f2; ERROR 42S22: Unknown column 'f2' in 'order clause' drop table t1; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; CREATE TABLE t1 ( request_id int unsigned NOT NULL auto_increment, user_id varchar(12) default NULL, @@ -416,6 +419,7 @@ INSERT INTO t1(user_id) SELECT user_id FROM t1; INSERT INTO t1(user_id) SELECT user_id FROM t1; INSERT INTO t1(user_id) SELECT user_id FROM t1; INSERT INTO t1(user_id) SELECT user_id FROM t1; +SET sql_mode = DEFAULT; flush status; SELECT user_id FROM t1 WHERE request_id=9999999999999; user_id |