1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/subselect4.result b/mysql-test/r/subselect4.result
index 792ce657ba0..058f0808832 100644
--- a/mysql-test/r/subselect4.result
+++ b/mysql-test/r/subselect4.result
@@ -2296,12 +2296,14 @@ d varchar(255) NOT NULL,
 PRIMARY KEY (a, b), UNIQUE KEY idx(a, c)
 );
 INSERT INTO t1 VALUES ('r', 1, 'ad18832202b199728921807033a8a515', '001_cbr643');
+SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
 CREATE TABLE t2 (
 a enum('p','r') NOT NULL DEFAULT 'r',
 b int NOT NULL DEFAULT '0',
 e datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 PRIMARY KEY (a, b, e)
 );
+SET sql_mode = DEFAULT;
 INSERT INTO t2 VALUES ('r', 1, '2013-10-05 14:25:30');
 SELECT * FROM t1 AS t 
 WHERE a='r' AND (c,b) NOT IN (SELECT c,b FROM t2 WHERE (c,b)=(t.c,t.b));