summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/iuds/t/update_year.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/iuds/t/update_year.test')
-rw-r--r--mysql-test/suite/engines/iuds/t/update_year.test12
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/suite/engines/iuds/t/update_year.test b/mysql-test/suite/engines/iuds/t/update_year.test
index d1f06293716..599c637e442 100644
--- a/mysql-test/suite/engines/iuds/t/update_year.test
+++ b/mysql-test/suite/engines/iuds/t/update_year.test
@@ -128,22 +128,22 @@ UPDATE t4 SET c1=99 WHERE c2 IN (01,54,65,69,null);
SELECT c1 FROM t4;
# Update outside range would be clipped to closest endpoints
-UPDATE t1 SET c2=-1 WHERE c1=2071;
+UPDATE IGNORE t1 SET c2=-1 WHERE c1=2071;
--sorted_result
SELECT c2 FROM t1;
UPDATE t1 SET c2=0 WHERE c1=2003;
--sorted_result
SELECT c2 FROM t1;
-UPDATE t1 SET c2=2156 WHERE c1=2001;
+UPDATE IGNORE t1 SET c2=2156 WHERE c1=2001;
--sorted_result
SELECT c2 FROM t1;
-UPDATE t4 SET c2=-1 WHERE c1=71;
+UPDATE IGNORE t4 SET c2=-1 WHERE c1=71;
--sorted_result
SELECT c2 FROM t4;
UPDATE t4 SET c2=0 WHERE c1=70;
--sorted_result
SELECT c2 FROM t4;
-UPDATE t4 SET c2=100 WHERE c1=79;
+UPDATE IGNORE t4 SET c2=100 WHERE c1=79;
--sorted_result
SELECT c2 FROM t4;
@@ -162,7 +162,7 @@ SET SQL_MODE=DEFAULT
#UPDATE t2 SET c1='def' WHERE c2=2064;
#--sorted_result
#SELECT c1 FROM t2;
-UPDATE t4 SET c1=-70 WHERE c2=75;
+UPDATE IGNORE t4 SET c1=-70 WHERE c2=75;
--sorted_result
SELECT c1 FROM t4;
@@ -187,7 +187,7 @@ UPDATE t1 SET t1.c2=0000 WHERE c1 BETWEEN 2000 AND 2010;
--sorted_result
SELECT * FROM t1;
# EXPLAIN SELECT * FROM t1 WHERE c1 IN (2154,2009,1979);
-UPDATE t1 SET c1=c1-1,c2=c2+1 WHERE c1 IN (2154,2009,1979);
+UPDATE IGNORE t1 SET c1=c1-1,c2=c2+1 WHERE c1 IN (2154,2009,1979);
--sorted_result
SELECT * FROM t1;