diff options
Diffstat (limited to 'mysql-test/suite/funcs_1')
| -rw-r--r-- | mysql-test/suite/funcs_1/r/innodb_views.result | 456 | ||||
| -rw-r--r-- | mysql-test/suite/funcs_1/r/is_tables_is.result | 160 | ||||
| -rw-r--r-- | mysql-test/suite/funcs_1/r/is_tables_is_embedded.result | 160 | ||||
| -rw-r--r-- | mysql-test/suite/funcs_1/r/memory_views.result | 456 | ||||
| -rw-r--r-- | mysql-test/suite/funcs_1/r/myisam_views-big.result | 456 | ||||
| -rw-r--r-- | mysql-test/suite/funcs_1/r/storedproc.result | 2 | ||||
| -rw-r--r-- | mysql-test/suite/funcs_1/views/views_master.inc | 10 |
7 files changed, 850 insertions, 850 deletions
diff --git a/mysql-test/suite/funcs_1/r/innodb_views.result b/mysql-test/suite/funcs_1/r/innodb_views.result index fa9d9df59d9..4a563089922 100644 --- a/mysql-test/suite/funcs_1/r/innodb_views.result +++ b/mysql-test/suite/funcs_1/r/innodb_views.result @@ -8001,7 +8001,7 @@ Drop view if exists test.v1 ; CREATE VIEW test.v1 AS SELECT f59,f60 FROM test.tb2 where f59 = 195 WITH CHECK OPTION ; UPDATE test.v1 SET f59 = 198 where f59=195 ; -ERROR HY000: CHECK OPTION failed 'test.v1' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' SELECT * FROM test.v1 order by f59 ; f59 f60 195 87 @@ -8015,7 +8015,7 @@ CREATE VIEW test.v1 AS SELECT f59,f60 FROM test.tb2 where F59 = 0987 WITH LOCAL CHECK OPTION ; CREATE VIEW test.v2 as SELECT * FROM test.v1 ; UPDATE test.v1 SET F59 = 919 where f59 = 0987 ; -ERROR HY000: CHECK OPTION failed 'test.v1' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' SELECT * FROM test.v1 order by f59 ; f59 f60 987 41 @@ -8050,9 +8050,9 @@ f1 f2 A 2 B 2 UPDATE v1 SET f2 = 4; -ERROR HY000: CHECK OPTION failed 'test.v1' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' INSERT INTO v1 VALUES('B',3); -ERROR HY000: CHECK OPTION failed 'test.v1' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' SELECT * FROM v1 order by f1, f2; f1 f2 A 2 @@ -8166,7 +8166,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -8200,7 +8200,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -8278,21 +8278,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -8306,11 +8306,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -8386,21 +8386,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -8414,11 +8414,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -8611,7 +8611,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -8645,7 +8645,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -8723,21 +8723,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -8751,11 +8751,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -8831,21 +8831,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -8859,11 +8859,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9056,7 +9056,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9090,7 +9090,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9168,21 +9168,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9196,11 +9196,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9276,21 +9276,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9304,11 +9304,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9501,7 +9501,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9535,7 +9535,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9613,21 +9613,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9641,11 +9641,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9721,21 +9721,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9749,11 +9749,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9949,7 +9949,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9983,7 +9983,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10061,21 +10061,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10089,11 +10089,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10169,21 +10169,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10197,11 +10197,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10394,7 +10394,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10428,7 +10428,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10506,21 +10506,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10534,11 +10534,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10614,21 +10614,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10642,11 +10642,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10839,7 +10839,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10873,7 +10873,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10951,21 +10951,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10979,11 +10979,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11059,21 +11059,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11087,11 +11087,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11284,7 +11284,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11318,7 +11318,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11396,21 +11396,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11424,11 +11424,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11504,21 +11504,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11532,11 +11532,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11732,7 +11732,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11766,7 +11766,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11844,21 +11844,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11872,11 +11872,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11952,21 +11952,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11980,11 +11980,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12177,7 +12177,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12211,7 +12211,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12289,21 +12289,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12317,11 +12317,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12397,21 +12397,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12425,11 +12425,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12622,7 +12622,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12656,7 +12656,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12734,21 +12734,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12762,11 +12762,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12842,21 +12842,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12870,11 +12870,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13067,7 +13067,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13101,7 +13101,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13179,21 +13179,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13207,11 +13207,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13287,21 +13287,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13315,11 +13315,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13515,7 +13515,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13549,7 +13549,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13627,21 +13627,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13655,11 +13655,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13735,21 +13735,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13763,11 +13763,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13960,7 +13960,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13994,7 +13994,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14072,21 +14072,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14100,11 +14100,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14180,21 +14180,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14208,11 +14208,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14405,7 +14405,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14439,7 +14439,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14517,21 +14517,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14545,11 +14545,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14625,21 +14625,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14653,11 +14653,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14850,7 +14850,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14884,7 +14884,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14962,21 +14962,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14990,11 +14990,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -15070,21 +15070,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -15098,11 +15098,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; diff --git a/mysql-test/suite/funcs_1/r/is_tables_is.result b/mysql-test/suite/funcs_1/r/is_tables_is.result index a0f2424c07c..54bc727fb74 100644 --- a/mysql-test/suite/funcs_1/r/is_tables_is.result +++ b/mysql-test/suite/funcs_1/r/is_tables_is.result @@ -17,7 +17,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ALL_PLUGINS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -40,7 +40,7 @@ TABLE_SCHEMA information_schema TABLE_NAME APPLICABLE_ROLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -63,7 +63,7 @@ TABLE_SCHEMA information_schema TABLE_NAME CHARACTER_SETS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -86,7 +86,7 @@ TABLE_SCHEMA information_schema TABLE_NAME CLIENT_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -109,7 +109,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLLATIONS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -132,7 +132,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLLATION_CHARACTER_SET_APPLICABILITY TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -155,7 +155,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLUMNS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -178,7 +178,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLUMN_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -201,7 +201,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ENABLED_ROLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -224,7 +224,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ENGINES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -247,7 +247,7 @@ TABLE_SCHEMA information_schema TABLE_NAME EVENTS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -270,7 +270,7 @@ TABLE_SCHEMA information_schema TABLE_NAME FILES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -293,7 +293,7 @@ TABLE_SCHEMA information_schema TABLE_NAME GEOMETRY_COLUMNS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -316,7 +316,7 @@ TABLE_SCHEMA information_schema TABLE_NAME GLOBAL_STATUS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -339,7 +339,7 @@ TABLE_SCHEMA information_schema TABLE_NAME GLOBAL_VARIABLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -362,7 +362,7 @@ TABLE_SCHEMA information_schema TABLE_NAME INDEX_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -385,7 +385,7 @@ TABLE_SCHEMA information_schema TABLE_NAME KEY_CACHES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -408,7 +408,7 @@ TABLE_SCHEMA information_schema TABLE_NAME KEY_COLUMN_USAGE TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -431,7 +431,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PARAMETERS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -454,7 +454,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PARTITIONS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -477,7 +477,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PLUGINS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -500,7 +500,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PROCESSLIST TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -523,7 +523,7 @@ TABLE_SCHEMA information_schema TABLE_NAME REFERENTIAL_CONSTRAINTS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -546,7 +546,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ROUTINES TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -569,7 +569,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SCHEMATA TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -592,7 +592,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SCHEMA_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -615,7 +615,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SESSION_STATUS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -638,7 +638,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SESSION_VARIABLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -661,7 +661,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SPATIAL_REF_SYS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -684,7 +684,7 @@ TABLE_SCHEMA information_schema TABLE_NAME STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -707,7 +707,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SYSTEM_VARIABLES TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -730,7 +730,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -753,7 +753,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLESPACES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -776,7 +776,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLE_CONSTRAINTS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -799,7 +799,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLE_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -822,7 +822,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLE_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -845,7 +845,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TRIGGERS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -868,7 +868,7 @@ TABLE_SCHEMA information_schema TABLE_NAME USER_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -891,7 +891,7 @@ TABLE_SCHEMA information_schema TABLE_NAME USER_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -914,7 +914,7 @@ TABLE_SCHEMA information_schema TABLE_NAME VIEWS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -953,7 +953,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ALL_PLUGINS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -976,7 +976,7 @@ TABLE_SCHEMA information_schema TABLE_NAME APPLICABLE_ROLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -999,7 +999,7 @@ TABLE_SCHEMA information_schema TABLE_NAME CHARACTER_SETS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1022,7 +1022,7 @@ TABLE_SCHEMA information_schema TABLE_NAME CLIENT_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1045,7 +1045,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLLATIONS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1068,7 +1068,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLLATION_CHARACTER_SET_APPLICABILITY TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1091,7 +1091,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLUMNS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1114,7 +1114,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLUMN_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1137,7 +1137,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ENABLED_ROLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1160,7 +1160,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ENGINES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1183,7 +1183,7 @@ TABLE_SCHEMA information_schema TABLE_NAME EVENTS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1206,7 +1206,7 @@ TABLE_SCHEMA information_schema TABLE_NAME FILES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1229,7 +1229,7 @@ TABLE_SCHEMA information_schema TABLE_NAME GEOMETRY_COLUMNS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1252,7 +1252,7 @@ TABLE_SCHEMA information_schema TABLE_NAME GLOBAL_STATUS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1275,7 +1275,7 @@ TABLE_SCHEMA information_schema TABLE_NAME GLOBAL_VARIABLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1298,7 +1298,7 @@ TABLE_SCHEMA information_schema TABLE_NAME INDEX_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1321,7 +1321,7 @@ TABLE_SCHEMA information_schema TABLE_NAME KEY_CACHES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1344,7 +1344,7 @@ TABLE_SCHEMA information_schema TABLE_NAME KEY_COLUMN_USAGE TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1367,7 +1367,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PARAMETERS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1390,7 +1390,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PARTITIONS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1413,7 +1413,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PLUGINS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1436,7 +1436,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PROCESSLIST TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1459,7 +1459,7 @@ TABLE_SCHEMA information_schema TABLE_NAME REFERENTIAL_CONSTRAINTS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1482,7 +1482,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ROUTINES TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1505,7 +1505,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SCHEMATA TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1528,7 +1528,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SCHEMA_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1551,7 +1551,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SESSION_STATUS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1574,7 +1574,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SESSION_VARIABLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1597,7 +1597,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SPATIAL_REF_SYS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1620,7 +1620,7 @@ TABLE_SCHEMA information_schema TABLE_NAME STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1643,7 +1643,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SYSTEM_VARIABLES TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1666,7 +1666,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1689,7 +1689,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLESPACES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1712,7 +1712,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLE_CONSTRAINTS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1735,7 +1735,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLE_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1758,7 +1758,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLE_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1781,7 +1781,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TRIGGERS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1804,7 +1804,7 @@ TABLE_SCHEMA information_schema TABLE_NAME USER_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1827,7 +1827,7 @@ TABLE_SCHEMA information_schema TABLE_NAME USER_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1850,7 +1850,7 @@ TABLE_SCHEMA information_schema TABLE_NAME VIEWS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# diff --git a/mysql-test/suite/funcs_1/r/is_tables_is_embedded.result b/mysql-test/suite/funcs_1/r/is_tables_is_embedded.result index a0f2424c07c..54bc727fb74 100644 --- a/mysql-test/suite/funcs_1/r/is_tables_is_embedded.result +++ b/mysql-test/suite/funcs_1/r/is_tables_is_embedded.result @@ -17,7 +17,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ALL_PLUGINS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -40,7 +40,7 @@ TABLE_SCHEMA information_schema TABLE_NAME APPLICABLE_ROLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -63,7 +63,7 @@ TABLE_SCHEMA information_schema TABLE_NAME CHARACTER_SETS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -86,7 +86,7 @@ TABLE_SCHEMA information_schema TABLE_NAME CLIENT_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -109,7 +109,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLLATIONS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -132,7 +132,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLLATION_CHARACTER_SET_APPLICABILITY TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -155,7 +155,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLUMNS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -178,7 +178,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLUMN_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -201,7 +201,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ENABLED_ROLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -224,7 +224,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ENGINES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -247,7 +247,7 @@ TABLE_SCHEMA information_schema TABLE_NAME EVENTS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -270,7 +270,7 @@ TABLE_SCHEMA information_schema TABLE_NAME FILES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -293,7 +293,7 @@ TABLE_SCHEMA information_schema TABLE_NAME GEOMETRY_COLUMNS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -316,7 +316,7 @@ TABLE_SCHEMA information_schema TABLE_NAME GLOBAL_STATUS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -339,7 +339,7 @@ TABLE_SCHEMA information_schema TABLE_NAME GLOBAL_VARIABLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -362,7 +362,7 @@ TABLE_SCHEMA information_schema TABLE_NAME INDEX_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -385,7 +385,7 @@ TABLE_SCHEMA information_schema TABLE_NAME KEY_CACHES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -408,7 +408,7 @@ TABLE_SCHEMA information_schema TABLE_NAME KEY_COLUMN_USAGE TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -431,7 +431,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PARAMETERS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -454,7 +454,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PARTITIONS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -477,7 +477,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PLUGINS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -500,7 +500,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PROCESSLIST TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -523,7 +523,7 @@ TABLE_SCHEMA information_schema TABLE_NAME REFERENTIAL_CONSTRAINTS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -546,7 +546,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ROUTINES TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -569,7 +569,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SCHEMATA TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -592,7 +592,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SCHEMA_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -615,7 +615,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SESSION_STATUS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -638,7 +638,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SESSION_VARIABLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -661,7 +661,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SPATIAL_REF_SYS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -684,7 +684,7 @@ TABLE_SCHEMA information_schema TABLE_NAME STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -707,7 +707,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SYSTEM_VARIABLES TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -730,7 +730,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -753,7 +753,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLESPACES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -776,7 +776,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLE_CONSTRAINTS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -799,7 +799,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLE_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -822,7 +822,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLE_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -845,7 +845,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TRIGGERS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -868,7 +868,7 @@ TABLE_SCHEMA information_schema TABLE_NAME USER_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -891,7 +891,7 @@ TABLE_SCHEMA information_schema TABLE_NAME USER_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -914,7 +914,7 @@ TABLE_SCHEMA information_schema TABLE_NAME VIEWS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -953,7 +953,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ALL_PLUGINS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -976,7 +976,7 @@ TABLE_SCHEMA information_schema TABLE_NAME APPLICABLE_ROLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -999,7 +999,7 @@ TABLE_SCHEMA information_schema TABLE_NAME CHARACTER_SETS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1022,7 +1022,7 @@ TABLE_SCHEMA information_schema TABLE_NAME CLIENT_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1045,7 +1045,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLLATIONS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1068,7 +1068,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLLATION_CHARACTER_SET_APPLICABILITY TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1091,7 +1091,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLUMNS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1114,7 +1114,7 @@ TABLE_SCHEMA information_schema TABLE_NAME COLUMN_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1137,7 +1137,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ENABLED_ROLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1160,7 +1160,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ENGINES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1183,7 +1183,7 @@ TABLE_SCHEMA information_schema TABLE_NAME EVENTS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1206,7 +1206,7 @@ TABLE_SCHEMA information_schema TABLE_NAME FILES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1229,7 +1229,7 @@ TABLE_SCHEMA information_schema TABLE_NAME GEOMETRY_COLUMNS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1252,7 +1252,7 @@ TABLE_SCHEMA information_schema TABLE_NAME GLOBAL_STATUS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1275,7 +1275,7 @@ TABLE_SCHEMA information_schema TABLE_NAME GLOBAL_VARIABLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1298,7 +1298,7 @@ TABLE_SCHEMA information_schema TABLE_NAME INDEX_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1321,7 +1321,7 @@ TABLE_SCHEMA information_schema TABLE_NAME KEY_CACHES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1344,7 +1344,7 @@ TABLE_SCHEMA information_schema TABLE_NAME KEY_COLUMN_USAGE TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1367,7 +1367,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PARAMETERS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1390,7 +1390,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PARTITIONS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1413,7 +1413,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PLUGINS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1436,7 +1436,7 @@ TABLE_SCHEMA information_schema TABLE_NAME PROCESSLIST TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1459,7 +1459,7 @@ TABLE_SCHEMA information_schema TABLE_NAME REFERENTIAL_CONSTRAINTS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1482,7 +1482,7 @@ TABLE_SCHEMA information_schema TABLE_NAME ROUTINES TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1505,7 +1505,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SCHEMATA TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1528,7 +1528,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SCHEMA_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1551,7 +1551,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SESSION_STATUS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1574,7 +1574,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SESSION_VARIABLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1597,7 +1597,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SPATIAL_REF_SYS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1620,7 +1620,7 @@ TABLE_SCHEMA information_schema TABLE_NAME STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1643,7 +1643,7 @@ TABLE_SCHEMA information_schema TABLE_NAME SYSTEM_VARIABLES TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1666,7 +1666,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1689,7 +1689,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLESPACES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1712,7 +1712,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLE_CONSTRAINTS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1735,7 +1735,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLE_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1758,7 +1758,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TABLE_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1781,7 +1781,7 @@ TABLE_SCHEMA information_schema TABLE_NAME TRIGGERS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1804,7 +1804,7 @@ TABLE_SCHEMA information_schema TABLE_NAME USER_PRIVILEGES TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1827,7 +1827,7 @@ TABLE_SCHEMA information_schema TABLE_NAME USER_STATISTICS TABLE_TYPE SYSTEM VIEW ENGINE MEMORY -VERSION 10 +VERSION 11 ROW_FORMAT Fixed TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# @@ -1850,7 +1850,7 @@ TABLE_SCHEMA information_schema TABLE_NAME VIEWS TABLE_TYPE SYSTEM VIEW ENGINE MYISAM_OR_MARIA -VERSION 10 +VERSION 11 ROW_FORMAT DYNAMIC_OR_PAGE TABLE_ROWS #TBLR# AVG_ROW_LENGTH #ARL# diff --git a/mysql-test/suite/funcs_1/r/memory_views.result b/mysql-test/suite/funcs_1/r/memory_views.result index 989f533af16..7ee9dce9ccc 100644 --- a/mysql-test/suite/funcs_1/r/memory_views.result +++ b/mysql-test/suite/funcs_1/r/memory_views.result @@ -8003,7 +8003,7 @@ Drop view if exists test.v1 ; CREATE VIEW test.v1 AS SELECT f59,f60 FROM test.tb2 where f59 = 195 WITH CHECK OPTION ; UPDATE test.v1 SET f59 = 198 where f59=195 ; -ERROR HY000: CHECK OPTION failed 'test.v1' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' SELECT * FROM test.v1 order by f59 ; f59 f60 195 87 @@ -8017,7 +8017,7 @@ CREATE VIEW test.v1 AS SELECT f59,f60 FROM test.tb2 where F59 = 0987 WITH LOCAL CHECK OPTION ; CREATE VIEW test.v2 as SELECT * FROM test.v1 ; UPDATE test.v1 SET F59 = 919 where f59 = 0987 ; -ERROR HY000: CHECK OPTION failed 'test.v1' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' SELECT * FROM test.v1 order by f59 ; f59 f60 987 41 @@ -8052,9 +8052,9 @@ f1 f2 A 2 B 2 UPDATE v1 SET f2 = 4; -ERROR HY000: CHECK OPTION failed 'test.v1' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' INSERT INTO v1 VALUES('B',3); -ERROR HY000: CHECK OPTION failed 'test.v1' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' SELECT * FROM v1 order by f1, f2; f1 f2 A 2 @@ -8168,7 +8168,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -8202,7 +8202,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -8280,21 +8280,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -8308,11 +8308,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -8388,21 +8388,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -8416,11 +8416,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -8613,7 +8613,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -8647,7 +8647,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -8725,21 +8725,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -8753,11 +8753,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -8833,21 +8833,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -8861,11 +8861,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9058,7 +9058,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9092,7 +9092,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9170,21 +9170,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9198,11 +9198,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9278,21 +9278,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9306,11 +9306,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9503,7 +9503,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9537,7 +9537,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9615,21 +9615,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9643,11 +9643,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9723,21 +9723,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9751,11 +9751,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9951,7 +9951,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9985,7 +9985,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10063,21 +10063,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10091,11 +10091,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10171,21 +10171,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10199,11 +10199,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10396,7 +10396,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10430,7 +10430,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10508,21 +10508,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10536,11 +10536,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10616,21 +10616,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10644,11 +10644,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10841,7 +10841,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10875,7 +10875,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10953,21 +10953,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10981,11 +10981,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11061,21 +11061,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11089,11 +11089,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11286,7 +11286,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11320,7 +11320,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11398,21 +11398,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11426,11 +11426,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11506,21 +11506,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11534,11 +11534,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11734,7 +11734,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11768,7 +11768,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11846,21 +11846,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11874,11 +11874,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11954,21 +11954,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11982,11 +11982,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12179,7 +12179,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12213,7 +12213,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12291,21 +12291,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12319,11 +12319,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12399,21 +12399,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12427,11 +12427,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12624,7 +12624,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12658,7 +12658,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12736,21 +12736,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12764,11 +12764,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12844,21 +12844,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12872,11 +12872,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13069,7 +13069,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13103,7 +13103,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13181,21 +13181,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13209,11 +13209,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13289,21 +13289,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13317,11 +13317,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13517,7 +13517,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13551,7 +13551,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13629,21 +13629,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13657,11 +13657,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13737,21 +13737,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13765,11 +13765,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13962,7 +13962,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13996,7 +13996,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14074,21 +14074,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14102,11 +14102,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14182,21 +14182,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14210,11 +14210,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14407,7 +14407,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14441,7 +14441,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14519,21 +14519,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14547,11 +14547,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14627,21 +14627,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14655,11 +14655,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14852,7 +14852,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14886,7 +14886,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14964,21 +14964,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14992,11 +14992,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -15072,21 +15072,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -15100,11 +15100,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; diff --git a/mysql-test/suite/funcs_1/r/myisam_views-big.result b/mysql-test/suite/funcs_1/r/myisam_views-big.result index c642a05b332..c4f18de6fc1 100644 --- a/mysql-test/suite/funcs_1/r/myisam_views-big.result +++ b/mysql-test/suite/funcs_1/r/myisam_views-big.result @@ -8870,7 +8870,7 @@ Drop view if exists test.v1 ; CREATE VIEW test.v1 AS SELECT f59,f60 FROM test.tb2 where f59 = 195 WITH CHECK OPTION ; UPDATE test.v1 SET f59 = 198 where f59=195 ; -ERROR HY000: CHECK OPTION failed 'test.v1' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' SELECT * FROM test.v1 order by f59 ; f59 f60 195 87 @@ -8884,7 +8884,7 @@ CREATE VIEW test.v1 AS SELECT f59,f60 FROM test.tb2 where F59 = 0987 WITH LOCAL CHECK OPTION ; CREATE VIEW test.v2 as SELECT * FROM test.v1 ; UPDATE test.v1 SET F59 = 919 where f59 = 0987 ; -ERROR HY000: CHECK OPTION failed 'test.v1' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' SELECT * FROM test.v1 order by f59 ; f59 f60 987 41 @@ -8919,9 +8919,9 @@ f1 f2 A 2 B 2 UPDATE v1 SET f2 = 4; -ERROR HY000: CHECK OPTION failed 'test.v1' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' INSERT INTO v1 VALUES('B',3); -ERROR HY000: CHECK OPTION failed 'test.v1' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' SELECT * FROM v1 order by f1, f2; f1 f2 A 2 @@ -9035,7 +9035,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9069,7 +9069,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9147,21 +9147,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9175,11 +9175,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9255,21 +9255,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9283,11 +9283,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9480,7 +9480,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9514,7 +9514,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9592,21 +9592,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9620,11 +9620,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9700,21 +9700,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9728,11 +9728,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -9925,7 +9925,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -9959,7 +9959,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10037,21 +10037,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10065,11 +10065,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10145,21 +10145,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10173,11 +10173,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10370,7 +10370,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10404,7 +10404,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10482,21 +10482,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10510,11 +10510,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10590,21 +10590,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10618,11 +10618,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10818,7 +10818,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10852,7 +10852,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -10930,21 +10930,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -10958,11 +10958,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11038,21 +11038,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11066,11 +11066,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11263,7 +11263,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11297,7 +11297,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11375,21 +11375,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11403,11 +11403,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11483,21 +11483,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11511,11 +11511,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11708,7 +11708,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11742,7 +11742,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11820,21 +11820,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11848,11 +11848,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -11928,21 +11928,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -11956,11 +11956,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12153,7 +12153,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12187,7 +12187,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12265,21 +12265,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12293,11 +12293,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12373,21 +12373,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12401,11 +12401,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12601,7 +12601,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12635,7 +12635,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12713,21 +12713,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12741,11 +12741,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -12821,21 +12821,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -12849,11 +12849,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13046,7 +13046,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13080,7 +13080,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13158,21 +13158,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13186,11 +13186,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13266,21 +13266,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13294,11 +13294,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13491,7 +13491,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13525,7 +13525,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13603,21 +13603,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13631,11 +13631,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13711,21 +13711,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13739,11 +13739,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -13936,7 +13936,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -13970,7 +13970,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14048,21 +14048,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14076,11 +14076,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14156,21 +14156,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14184,11 +14184,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14384,7 +14384,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14418,7 +14418,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14496,21 +14496,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14524,11 +14524,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14604,21 +14604,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14632,11 +14632,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14829,7 +14829,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14863,7 +14863,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -14941,21 +14941,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -14969,11 +14969,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -15049,21 +15049,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -15077,11 +15077,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -15274,7 +15274,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -15308,7 +15308,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -15386,21 +15386,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -15414,11 +15414,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -15494,21 +15494,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -15522,11 +15522,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -15719,7 +15719,7 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -15753,7 +15753,7 @@ affected rows: 1 INSERT INTO v3 VALUES(0, 'zero'); affected rows: 1 INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -15831,21 +15831,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -15859,11 +15859,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; @@ -15939,21 +15939,21 @@ f1 f2 DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 7 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 0 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight DELETE FROM t1; INSERT INTO t1 VALUES(8, 'eight'); UPDATE v3 SET my_col1 = 16 WHERE my_col1 = 8; -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' SELECT * FROM t1; f1 f2 8 eight @@ -15967,11 +15967,11 @@ f1 f2 10 eight DELETE FROM t1; INSERT INTO v3 VALUES(16, 'sixteen'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CHECK OPTION failed 'test.v3' +ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; diff --git a/mysql-test/suite/funcs_1/r/storedproc.result b/mysql-test/suite/funcs_1/r/storedproc.result index 47abc84ec57..6f2ab852d37 100644 --- a/mysql-test/suite/funcs_1/r/storedproc.result +++ b/mysql-test/suite/funcs_1/r/storedproc.result @@ -4981,7 +4981,7 @@ CREATE PROCEDURE sp1() not:BEGIN SELECT @x; END// -ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':BEGIN +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'not:BEGIN SELECT @x; END' at line 2 DROP PROCEDURE IF EXISTS sp1; diff --git a/mysql-test/suite/funcs_1/views/views_master.inc b/mysql-test/suite/funcs_1/views/views_master.inc index 54e7f2af54b..7bcec45531e 100644 --- a/mysql-test/suite/funcs_1/views/views_master.inc +++ b/mysql-test/suite/funcs_1/views/views_master.inc @@ -1838,7 +1838,7 @@ Drop view if exists test.v1 ; CREATE VIEW test.v1 AS SELECT f59,f60 FROM test.tb2 where f59 = 195 WITH CHECK OPTION ; ---error ER_VIEW_CHECK_FAILED +--error ER_CONSTRAINT_FAILED UPDATE test.v1 SET f59 = 198 where f59=195 ; SELECT * FROM test.v1 order by f59 ; @@ -1863,7 +1863,7 @@ FROM test.tb2 where F59 = 0987 WITH LOCAL CHECK OPTION ; CREATE VIEW test.v2 as SELECT * FROM test.v1 ; # This UPDATE violates the definition of VIEW test.v1. ---error ER_VIEW_CHECK_FAILED +--error ER_CONSTRAINT_FAILED UPDATE test.v1 SET F59 = 919 where f59 = 0987 ; SELECT * FROM test.v1 order by f59 ; @@ -1909,9 +1909,9 @@ INSERT INTO v1 VALUES('B',2); SELECT * FROM v1 order by f1, f2; # negative cases --enable_info ---error ER_VIEW_CHECK_FAILED +--error ER_CONSTRAINT_FAILED UPDATE v1 SET f2 = 4; ---error ER_VIEW_CHECK_FAILED +--error ER_CONSTRAINT_FAILED INSERT INTO v1 VALUES('B',3); --disable_info # Bug#11771: View over InnoDB table, wrong result SELECT on VIEW, @@ -2292,7 +2292,7 @@ WHERE v3_to_v1_options LIKE 'WITH %' AND v3_to_v1_options NOT LIKE 'WITH LOCAL % AND v3_to_v1_violation NOT LIKE ' _ _ ' AND errno = 0 ORDER BY v3_to_v1_options; # 5. There must be NO failing INSERT/UPDATE getting a -# sql_errno <> 1369 (ER_VIEW_CHECK_FAILED). +# sql_errno <> 1369 (ER_CONSTRAINT_FAILED). SELECT * FROM t1_results WHERE errno <> 0 AND errno <> 1369 ORDER BY v3_to_v1_options; |