From 8b2e642aa214db729161252b96f36bfbae3add21 Mon Sep 17 00:00:00 2001 From: Nirbhay Choubey Date: Wed, 8 Feb 2017 15:28:00 -0500 Subject: MDEV-7635: Update tests to adapt to the new default sql_mode --- mysql-test/suite/sys_vars/r/sql_warnings_func.result | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'mysql-test/suite/sys_vars/r/sql_warnings_func.result') diff --git a/mysql-test/suite/sys_vars/r/sql_warnings_func.result b/mysql-test/suite/sys_vars/r/sql_warnings_func.result index 91a4e8b28c0..16be59755de 100644 --- a/mysql-test/suite/sys_vars/r/sql_warnings_func.result +++ b/mysql-test/suite/sys_vars/r/sql_warnings_func.result @@ -5,17 +5,17 @@ CREATE TEMPORARY TABLE t1(a varchar(5), b varchar(20)); '#-----------------------------FN_DYNVARS_167_01------------#' SET @@sql_warnings = DEFAULT; affected rows: 0 -INSERT INTO t1 VALUES('abcdef', 'val1'); +INSERT IGNORE INTO t1 VALUES('abcdef', 'val1'); affected rows: 1 '#-----------------------------FN_DYNVARS_167_02------------------#' SET @@sql_warnings = 0; affected rows: 0 -INSERT INTO t1 VALUES('abcdef', 'val1'); +INSERT IGNORE INTO t1 VALUES('abcdef', 'val1'); affected rows: 1 '#-----------------------------FN_DYNVARS_167_03---------------#' SET @@sql_warnings = 1; affected rows: 0 -INSERT INTO t1 VALUES('abcdef', 'val1'); +INSERT IGNORE INTO t1 VALUES('abcdef', 'val1'); affected rows: 1 info: Records: 1 Duplicates: 0 Warnings: 1 '#----------------------------FN_DYNVARS_167_04---------------#' -- cgit v1.2.1