summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/iuds/r/update_delete_number.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/iuds/r/update_delete_number.result')
-rw-r--r--mysql-test/suite/engines/iuds/r/update_delete_number.result52
1 files changed, 26 insertions, 26 deletions
diff --git a/mysql-test/suite/engines/iuds/r/update_delete_number.result b/mysql-test/suite/engines/iuds/r/update_delete_number.result
index 15de16ed714..ef9d9ff0d34 100644
--- a/mysql-test/suite/engines/iuds/r/update_delete_number.result
+++ b/mysql-test/suite/engines/iuds/r/update_delete_number.result
@@ -26,7 +26,7 @@ SELECT c1,c2 FROM t1 WHERE c1=120;
c1 c2
120 NULL
120 NULL
-UPDATE t1 SET c1=-120 WHERE c2=-102;
+UPDATE IGNORE t1 SET c1=-120 WHERE c2=-102;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
SELECT c1,c2 FROM t1 WHERE c2=-102;
@@ -45,7 +45,7 @@ c1 c2 c3
1 0 1
2 0 2
INSERT INTO t1 VALUES(106,-106,9),(107,-107,10),(108,-108,11),(109,-109,12),(255,127,13);
-UPDATE t1 SET c1=4294967296,c2=2147483648 WHERE c2 BETWEEN -108 AND -106;
+UPDATE IGNORE t1 SET c1=4294967296,c2=2147483648 WHERE c2 BETWEEN -108 AND -106;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
@@ -61,7 +61,7 @@ c1 c2 c3
4294967295 2147483647 10
4294967295 2147483647 11
4294967295 2147483647 9
-UPDATE t1 SET c2=-2147483649 WHERE c1=109 ORDER BY c1;
+UPDATE IGNORE t1 SET c2=-2147483649 WHERE c1=109 ORDER BY c1;
Warnings:
Warning 1264 Out of range value for column 'c2' at row 13
SELECT c1,c2 FROM t1 WHERE c1=109;
@@ -78,7 +78,7 @@ SELECT c1,c2 FROM t1 WHERE c2=-110;
c1 c2
0 -110
SET SQL_MODE=DEFAULT;
-UPDATE t1 SET c1=NULL WHERE c2=-111 /* updates to default value 0 */;
+UPDATE IGNORE t1 SET c1=NULL WHERE c2=-111 /* updates to default value 0 */;
Warnings:
Warning 1048 Column 'c1' cannot be null
SELECT * FROM t1 WHERE c1=0;
@@ -144,7 +144,7 @@ c1 c2
7 8
10 11
4294967295 2147483647
-UPDATE t2 SET c1=0,c2=-2147483648 WHERE c2=2;
+UPDATE IGNORE t2 SET c1=0,c2=-2147483648 WHERE c2=2;
Warnings:
Warning 1264 Out of range value for column 'c2' at row 1
SELECT c1,c2 FROM t1 ORDER BY c1;
@@ -1119,7 +1119,7 @@ SELECT c1,c2 FROM t1 WHERE c1=120;
c1 c2
120 NULL
120 NULL
-UPDATE t1 SET c1=-120 WHERE c2=-102;
+UPDATE IGNORE t1 SET c1=-120 WHERE c2=-102;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
SELECT c1,c2 FROM t1 WHERE c2=-102;
@@ -1139,7 +1139,7 @@ c1 c2 c3
1 0 1
2 0 2
INSERT INTO t1 VALUES(106,-106,9),(107,-107,10),(108,-108,11),(109,-109,12),(255,127,13);
-UPDATE t1 SET c1=256,c2=128 WHERE c2 BETWEEN -108 AND -106;
+UPDATE IGNORE t1 SET c1=256,c2=128 WHERE c2 BETWEEN -108 AND -106;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
@@ -1156,7 +1156,7 @@ c1 c2 c3
255 127 11
255 127 13
255 127 9
-UPDATE t1 SET c2=-129 WHERE c1=109 ORDER BY c1;
+UPDATE IGNORE t1 SET c2=-129 WHERE c1=109 ORDER BY c1;
Warnings:
Warning 1264 Out of range value for column 'c2' at row 13
SELECT c1,c2 FROM t1 WHERE c1=109;
@@ -1173,7 +1173,7 @@ SELECT c1,c2 FROM t1 WHERE c2=-110;
c1 c2
0 -110
SET SQL_MODE=DEFAULT;
-UPDATE t1 SET c1=NULL WHERE c2=-111 /* updates to default value 0 */;
+UPDATE IGNORE t1 SET c1=NULL WHERE c2=-111 /* updates to default value 0 */;
Warnings:
Warning 1048 Column 'c1' cannot be null
SELECT * FROM t1 WHERE c1=0;
@@ -1239,7 +1239,7 @@ c1 c2
7 8
10 11
255 127
-UPDATE t2 SET c1=0,c2=-128 WHERE c2=2;
+UPDATE IGNORE t2 SET c1=0,c2=-128 WHERE c2=2;
Warnings:
Warning 1264 Out of range value for column 'c2' at row 1
SELECT c1,c2 FROM t1 ORDER BY c1;
@@ -1644,7 +1644,7 @@ a b
107 7
108 8
109 9
-update mt1,mt2 set mt1.a=mt1.a+100 where mt1.a=101;
+update ignore mt1,mt2 set mt1.a=mt1.a+100 where mt1.a=101;
Warnings:
Warning 1264 Out of range value for column 'a' at row 1
select * from mt1;
@@ -1892,7 +1892,7 @@ SELECT c1,c2 FROM t1 WHERE c1=120;
c1 c2
120 NULL
120 NULL
-UPDATE t1 SET c1=-120 WHERE c2=-102;
+UPDATE IGNORE t1 SET c1=-120 WHERE c2=-102;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
SELECT c1,c2 FROM t1 WHERE c2=-102;
@@ -1911,7 +1911,7 @@ c1 c2 c3
1 0 1
2 0 2
INSERT INTO t1 VALUES(106,-106,9),(107,-107,10),(108,-108,11),(109,-109,12),(255,127,13);
-UPDATE t1 SET c1=65536,c2=32768 WHERE c2 BETWEEN -108 AND -106;
+UPDATE IGNORE t1 SET c1=65536,c2=32768 WHERE c2 BETWEEN -108 AND -106;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
@@ -1927,7 +1927,7 @@ c1 c2 c3
65535 32767 10
65535 32767 11
65535 32767 9
-UPDATE t1 SET c2=-32769 WHERE c1=109 ORDER BY c1;
+UPDATE IGNORE t1 SET c2=-32769 WHERE c1=109 ORDER BY c1;
Warnings:
Warning 1264 Out of range value for column 'c2' at row 13
SELECT c1,c2 FROM t1 WHERE c1=109;
@@ -1944,7 +1944,7 @@ SELECT c1,c2 FROM t1 WHERE c2=-110;
c1 c2
0 -110
SET SQL_MODE=DEFAULT;
-UPDATE t1 SET c1=NULL WHERE c2=-111 /* updates to default value 0 */;
+UPDATE IGNORE t1 SET c1=NULL WHERE c2=-111 /* updates to default value 0 */;
Warnings:
Warning 1048 Column 'c1' cannot be null
SELECT * FROM t1 WHERE c1=0;
@@ -2010,7 +2010,7 @@ c1 c2
7 8
10 11
65535 32767
-UPDATE t2 SET c1=0,c2=-32768 WHERE c2=2;
+UPDATE IGNORE t2 SET c1=0,c2=-32768 WHERE c2=2;
Warnings:
Warning 1264 Out of range value for column 'c2' at row 1
SELECT c1,c2 FROM t1 ORDER BY c1;
@@ -2639,7 +2639,7 @@ SELECT c1,c2 FROM t1 WHERE c1=120;
c1 c2
120 NULL
120 NULL
-UPDATE t1 SET c1=-120 WHERE c2=-102;
+UPDATE IGNORE t1 SET c1=-120 WHERE c2=-102;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
SELECT c1,c2 FROM t1 WHERE c2=-102;
@@ -2658,7 +2658,7 @@ c1 c2 c3
1 0 1
2 0 2
INSERT INTO t1 VALUES(106,-106,9),(107,-107,10),(108,-108,11),(109,-109,12),(255,127,13);
-UPDATE t1 SET c1=16777216,c2=8388608 WHERE c2 BETWEEN -108 AND -106;
+UPDATE IGNORE t1 SET c1=16777216,c2=8388608 WHERE c2 BETWEEN -108 AND -106;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
@@ -2674,7 +2674,7 @@ c1 c2 c3
16777215 8388607 10
16777215 8388607 11
16777215 8388607 9
-UPDATE t1 SET c2=-8388609 WHERE c1=109 ORDER BY c1;
+UPDATE IGNORE t1 SET c2=-8388609 WHERE c1=109 ORDER BY c1;
Warnings:
Warning 1264 Out of range value for column 'c2' at row 13
SELECT c1,c2 FROM t1 WHERE c1=109;
@@ -2691,7 +2691,7 @@ SELECT c1,c2 FROM t1 WHERE c2=-110;
c1 c2
0 -110
SET SQL_MODE=DEFAULT;
-UPDATE t1 SET c1=NULL WHERE c2=-111 /* updates to default value 0 */;
+UPDATE IGNORE t1 SET c1=NULL WHERE c2=-111 /* updates to default value 0 */;
Warnings:
Warning 1048 Column 'c1' cannot be null
SELECT * FROM t1 WHERE c1=0;
@@ -2757,7 +2757,7 @@ c1 c2
7 8
10 11
16777215 8388607
-UPDATE t2 SET c1=0,c2=-8388608 WHERE c2=2;
+UPDATE IGNORE t2 SET c1=0,c2=-8388608 WHERE c2=2;
Warnings:
Warning 1264 Out of range value for column 'c2' at row 1
SELECT c1,c2 FROM t1 ORDER BY c1;
@@ -3386,7 +3386,7 @@ SELECT c1,c2 FROM t1 WHERE c1=120;
c1 c2
120 NULL
120 NULL
-UPDATE t1 SET c1=-120 WHERE c2=-102;
+UPDATE IGNORE t1 SET c1=-120 WHERE c2=-102;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
SELECT c1,c2 FROM t1 WHERE c2=-102;
@@ -3405,7 +3405,7 @@ c1 c2 c3
1 0 1
2 0 2
INSERT INTO t1 VALUES(106,-106,9),(107,-107,10),(108,-108,11),(109,-109,12),(255,127,13);
-UPDATE t1 SET c1=18446744073709551616,c2=9223372036854775808 WHERE c2 BETWEEN -108 AND -106;
+UPDATE IGNORE t1 SET c1=18446744073709551616,c2=9223372036854775808 WHERE c2 BETWEEN -108 AND -106;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
@@ -3421,7 +3421,7 @@ c1 c2 c3
18446744073709551615 9223372036854775807 10
18446744073709551615 9223372036854775807 11
18446744073709551615 9223372036854775807 9
-UPDATE t1 SET c2=-9223372036854775809 WHERE c1=109 ORDER BY c1;
+UPDATE IGNORE t1 SET c2=-9223372036854775809 WHERE c1=109 ORDER BY c1;
Warnings:
Warning 1264 Out of range value for column 'c2' at row 13
SELECT c1,c2 FROM t1 WHERE c1=109;
@@ -3438,7 +3438,7 @@ SELECT c1,c2 FROM t1 WHERE c2=-110;
c1 c2
0 -110
SET SQL_MODE=DEFAULT;
-UPDATE t1 SET c1=NULL WHERE c2=-111 /* updates to default value 0 */;
+UPDATE IGNORE t1 SET c1=NULL WHERE c2=-111 /* updates to default value 0 */;
Warnings:
Warning 1048 Column 'c1' cannot be null
SELECT * FROM t1 WHERE c1=0;
@@ -3504,7 +3504,7 @@ c1 c2
7 8
10 11
18446744073709551615 9223372036854775807
-UPDATE t2 SET c1=0,c2=-9223372036854775808 WHERE c2=2;
+UPDATE IGNORE t2 SET c1=0,c2=-9223372036854775808 WHERE c2=2;
Warnings:
Warning 1264 Out of range value for column 'c2' at row 1
SELECT c1,c2 FROM t1 ORDER BY c1;
View Lorry Controller Status