1 files changed, 17 insertions, 17 deletions
diff --git a/mysql-test/suite/engines/funcs/t/date_function.test b/mysql-test/suite/engines/funcs/t/date_function.test
index 360dc898731..39698fa4870 100644
--- a/mysql-test/suite/engines/funcs/t/date_function.test
+++ b/mysql-test/suite/engines/funcs/t/date_function.test
@@ -18,7 +18,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT DATE(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -42,7 +42,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT DAYNAME(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -66,7 +66,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT DAYOFMONTH(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -90,7 +90,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT DAYOFWEEK(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -114,7 +114,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT DAYOFYEAR(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -138,7 +138,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT FROM_DAYS(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -162,7 +162,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT LAST_DAY(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -186,7 +186,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT MONTH(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -210,7 +210,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT MONTHNAME(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -234,7 +234,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT QUARTER(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -258,7 +258,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT TIMESTAMP(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -282,7 +282,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT TO_DAYS(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -306,7 +306,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT WEEK(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -330,7 +330,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT WEEKDAY(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -354,7 +354,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT WEEKOFYEAR(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -378,7 +378,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT YEAR(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');
@@ -402,7 +402,7 @@ INSERT INTO t3 VALUES('2008-02-29');
 SELECT YEARWEEK(c1) FROM t3;
 DROP TABLE t3;
 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
-INSERT INTO t3 VALUES('1000-01-01');
+INSERT IGNORE INTO t3 VALUES('1000-01-01');
 INSERT INTO t3 VALUES('1999-12-31');
 INSERT INTO t3 VALUES('2000-01-01');
 INSERT INTO t3 VALUES('2006-12-25');