summaryrefslogtreecommitdiff
path: root/mysql-test/t/delayed.test
diff options
context:
space:
mode:
authorunknown <thek@adventure.(none)>2007-09-10 11:38:23 +0200
committerunknown <thek@adventure.(none)>2007-09-10 11:38:23 +0200
commit22436c86e0617ec2f6f024881a2a98ee942f7077 (patch)
treef5ad544ad32d769a3c9363be10fe35c0d19af2be /mysql-test/t/delayed.test
parentd811750fe890293970be9cd8d7b73258dd280da5 (diff)
parent44d04c81acf75ae1ea0f81caa0698a7b49e77e22 (diff)
downloadmariadb-git-22436c86e0617ec2f6f024881a2a98ee942f7077.tar.gz
Merge adventure.(none):/home/thek/Development/cpp/bug27358/my50-bug27358
into adventure.(none):/home/thek/Development/cpp/bug27358/my51-bug27358 mysql-test/r/delayed.result: Auto merged mysql-test/t/delayed.test: Auto merged sql/sql_insert.cc: SCCS merged
Diffstat (limited to 'mysql-test/t/delayed.test')
-rw-r--r--mysql-test/t/delayed.test31
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/t/delayed.test b/mysql-test/t/delayed.test
index 396c06f43e7..03b4f8b3013 100644
--- a/mysql-test/t/delayed.test
+++ b/mysql-test/t/delayed.test
@@ -251,4 +251,35 @@ CREATE TABLE t2(c1 INT) ENGINE=MERGE UNION=(t1);
--error 1031
INSERT DELAYED INTO t2 VALUES(1);
DROP TABLE t1, t2;
+#
+# Bug#27358 INSERT DELAYED does not honour SQL_MODE of the client
+#
+--disable_warnings
+DROP TABLE IF EXISTS t1,t2;
+--enable_warnings
+SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
+CREATE TABLE `t1` (
+ `id` int(11) PRIMARY KEY auto_increment,
+ `f1` varchar(10) NOT NULL UNIQUE
+);
+INSERT DELAYED INTO t1 VALUES(0,"test1");
+sleep 1;
+SELECT * FROM t1;
+SET SQL_MODE='PIPES_AS_CONCAT';
+INSERT DELAYED INTO t1 VALUES(0,'a' || 'b');
+sleep 1;
+SELECT * FROM t1;
+SET SQL_MODE='ERROR_FOR_DIVISION_BY_ZERO,STRICT_ALL_TABLES';
+--error 1365
+INSERT DELAYED INTO t1 VALUES(mod(1,0),"test3");
+CREATE TABLE t2 (
+ `id` int(11) PRIMARY KEY auto_increment,
+ `f1` date
+);
+SET SQL_MODE='NO_ZERO_DATE,STRICT_ALL_TABLES,NO_ZERO_IN_DATE';
+--error ER_TRUNCATED_WRONG_VALUE
+INSERT DELAYED INTO t2 VALUES (0,'0000-00-00');
+--error ER_TRUNCATED_WRONG_VALUE
+INSERT DELAYED INTO t2 VALUES (0,'2007-00-00');
+DROP TABLE t1,t2;