diff options
Diffstat (limited to 'mysql-test/t/update.test')
| -rw-r--r-- | mysql-test/t/update.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/update.test b/mysql-test/t/update.test index e5ef0b11127..5d834e69715 100644 --- a/mysql-test/t/update.test +++ b/mysql-test/t/update.test @@ -322,6 +322,7 @@ drop table t1; # Bug #24035: performance degradation with condition int_field=big_decimal # +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; CREATE TABLE t1 ( request_id int unsigned NOT NULL auto_increment, user_id varchar(12) default NULL, @@ -340,6 +341,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; |