[Groonga-mysql-commit] mroonga/mroonga at 9a932a0 [master] mysql57 test: disable warnings for SQL_MODE

Back to archive index

Kouhei Sutou null+****@clear*****
Wed Apr 20 22:46:37 JST 2016


Kouhei Sutou	2016-04-20 22:46:37 +0900 (Wed, 20 Apr 2016)

  New Revision: 9a932a00edf904992fe997b8aae25b74625bd4fb
  https://github.com/mroonga/mroonga/commit/9a932a00edf904992fe997b8aae25b74625bd4fb

  Message:
    mysql57 test: disable warnings for SQL_MODE

  Modified files:
    mysql-test/mroonga/storage/update/r/virtual_column.result
    mysql-test/mroonga/storage/update/t/virtual_column.test

  Modified: mysql-test/mroonga/storage/update/r/virtual_column.result (+1 -0)
===================================================================
--- mysql-test/mroonga/storage/update/r/virtual_column.result    2016-04-20 22:45:56 +0900 (11e6ee2)
+++ mysql-test/mroonga/storage/update/r/virtual_column.result    2016-04-20 22:46:37 +0900 (70e7501)
@@ -26,3 +26,4 @@ c1	_id
 2	2
 3	3
 drop table t1;
+set sql_mode=DEFAULT;

  Modified: mysql-test/mroonga/storage/update/t/virtual_column.test (+6 -0)
===================================================================
--- mysql-test/mroonga/storage/update/t/virtual_column.test    2016-04-20 22:45:56 +0900 (83b0e41)
+++ mysql-test/mroonga/storage/update/t/virtual_column.test    2016-04-20 22:46:37 +0900 (b633a43)
@@ -27,11 +27,15 @@ insert into t1 values(1,null);
 insert into t1 values(2,null);
 insert into t1 values(3,null);
 select * from t1;
+--disable_warnings
 set sql_mode="";
+--enable_warnings
 # warning WARN_DATA_TRUNCATED
 update t1 set _id = 10 where c1 = 1;
 select * from t1;
+--disable_warnings
 set sql_mode="strict_all_tables";
+--enable_warnings
 # We can't use WARN_DATA_TRUNCATED here because "WXXX" isn't supported
 # MySQL 5.5, 5.6 and MariaDB 5.6. MariaDB 10.0 only supports it.
 # We share this test with all MySQL servers. So we use number here.
@@ -40,4 +44,6 @@ update t1 set _id = 11 where c1 = 1;
 select * from t1;
 drop table t1;
 
+set sql_mode=DEFAULT;
+
 --source ../../../include/mroonga/have_mroonga_deinit.inc
-------------- next part --------------
HTML����������������������������...
Download 



More information about the Groonga-mysql-commit mailing list
Back to archive index