diff options
Diffstat (limited to 'mysql-test/suite/engines/iuds/t/update_year.test')
-rw-r--r-- | mysql-test/suite/engines/iuds/t/update_year.test | 12 |
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; |