diff options
author | Sergei Golubchik <serg@mariadb.org> | 2016-06-26 15:46:36 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2016-06-30 11:43:02 +0200 |
commit | 99e48cb1d94e2d884b257b13f792323d3d633322 (patch) | |
tree | 0571ed63973349b091a9b306e2dc472254928a60 /mysql-test/suite | |
parent | c87e002bbb946907b4c9504612b3b3c2a0a19e51 (diff) | |
download | mariadb-git-99e48cb1d94e2d884b257b13f792323d3d633322.tar.gz |
restore ER_VIEW_CHECK_FAILED to be different from ER_CONSTRAINT_FAILED
collaterals:
* use %`s, not '%s'
* use correct SQLSTATE codes for these two errors
Diffstat (limited to 'mysql-test/suite')
-rw-r--r-- | mysql-test/suite/funcs_1/r/innodb_views.result | 456 | ||||
-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/processlist_priv_no_prot.result | 4 | ||||
-rw-r--r-- | mysql-test/suite/funcs_1/views/views_master.inc | 10 | ||||
-rw-r--r-- | mysql-test/suite/innodb/r/innodb-index.result | 4 | ||||
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_extra_col_master_innodb.result | 2 | ||||
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_extra_col_master_myisam.result | 2 | ||||
-rw-r--r-- | mysql-test/suite/vcol/r/vcol_view_innodb.result | 6 | ||||
-rw-r--r-- | mysql-test/suite/vcol/r/vcol_view_myisam.result | 6 |
10 files changed, 701 insertions, 701 deletions
diff --git a/mysql-test/suite/funcs_1/r/innodb_views.result b/mysql-test/suite/funcs_1/r/innodb_views.result index 4a563089922..93fe4dc6b5f 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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `test`.`v1` INSERT INTO v1 VALUES('B',3); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; diff --git a/mysql-test/suite/funcs_1/r/memory_views.result b/mysql-test/suite/funcs_1/r/memory_views.result index 7ee9dce9ccc..885e2a7dfe7 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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `test`.`v1` INSERT INTO v1 VALUES('B',3); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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 c4f18de6fc1..0fbbfab9c1f 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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `test`.`v1` INSERT INTO v1 VALUES('B',3); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `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: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(0, 'zero'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(7, 'seven'); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3' +ERROR 44000: CHECK OPTION failed `test`.`v3` INSERT INTO v3 VALUES(8, 'eight'); affected rows: 1 SELECT * FROM t1; diff --git a/mysql-test/suite/funcs_1/r/processlist_priv_no_prot.result b/mysql-test/suite/funcs_1/r/processlist_priv_no_prot.result index e2ab6636366..70001195e02 100644 --- a/mysql-test/suite/funcs_1/r/processlist_priv_no_prot.result +++ b/mysql-test/suite/funcs_1/r/processlist_priv_no_prot.result @@ -60,7 +60,7 @@ INSERT INTO processlist SELECT * FROM test.t_processlist; ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' DROP TABLE test.t_processlist; CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS, STAGE, MAX_STAGE, PROGRESS, MEMORY_USED, EXAMINED_ROWS, QUERY_ID, INFO_BINARY) AS SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS, STAGE, MAX_STAGE, PROGRESS, MEMORY_USED, EXAMINED_ROWS, QUERY_ID, INFO_BINARY FROM processlist WITH CHECK OPTION; -ERROR HY000: CHECK OPTION on non-updatable view 'test.v_processlist' +ERROR HY000: CHECK OPTION on non-updatable view `test`.`v_processlist` CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS, STAGE, MAX_STAGE, PROGRESS, MEMORY_USED, EXAMINED_ROWS, QUERY_ID, INFO_BINARY) AS SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS, STAGE, MAX_STAGE, PROGRESS, MEMORY_USED, EXAMINED_ROWS, QUERY_ID, INFO_BINARY FROM processlist; DROP VIEW test.v_processlist; UPDATE processlist SET user='any_user' WHERE id=1 ; @@ -136,7 +136,7 @@ INSERT INTO processlist SELECT * FROM test.t_processlist; ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database 'information_schema' DROP TABLE test.t_processlist; CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS, STAGE, MAX_STAGE, PROGRESS, MEMORY_USED, EXAMINED_ROWS, QUERY_ID, INFO_BINARY) AS SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS, STAGE, MAX_STAGE, PROGRESS, MEMORY_USED, EXAMINED_ROWS, QUERY_ID, INFO_BINARY FROM processlist WITH CHECK OPTION; -ERROR HY000: CHECK OPTION on non-updatable view 'test.v_processlist' +ERROR HY000: CHECK OPTION on non-updatable view `test`.`v_processlist` CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS, STAGE, MAX_STAGE, PROGRESS, MEMORY_USED, EXAMINED_ROWS, QUERY_ID, INFO_BINARY) AS SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS, STAGE, MAX_STAGE, PROGRESS, MEMORY_USED, EXAMINED_ROWS, QUERY_ID, INFO_BINARY FROM processlist; DROP VIEW test.v_processlist; UPDATE processlist SET user='any_user' WHERE id=1 ; diff --git a/mysql-test/suite/funcs_1/views/views_master.inc b/mysql-test/suite/funcs_1/views/views_master.inc index 7bcec45531e..54e7f2af54b 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_CONSTRAINT_FAILED +--error ER_VIEW_CHECK_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_CONSTRAINT_FAILED +--error ER_VIEW_CHECK_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_CONSTRAINT_FAILED +--error ER_VIEW_CHECK_FAILED UPDATE v1 SET f2 = 4; ---error ER_CONSTRAINT_FAILED +--error ER_VIEW_CHECK_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_CONSTRAINT_FAILED). +# sql_errno <> 1369 (ER_VIEW_CHECK_FAILED). SELECT * FROM t1_results WHERE errno <> 0 AND errno <> 1369 ORDER BY v3_to_v1_options; diff --git a/mysql-test/suite/innodb/r/innodb-index.result b/mysql-test/suite/innodb/r/innodb-index.result index 48e3138ab56..5758a8ec6b5 100644 --- a/mysql-test/suite/innodb/r/innodb-index.result +++ b/mysql-test/suite/innodb/r/innodb-index.result @@ -544,9 +544,9 @@ t2 CREATE TABLE `t2` ( delete from t1; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `dc` FOREIGN KEY (`a`) REFERENCES `t1` (`a`)) drop index dc on t4; -ERROR 42000: Can't DROP 'dc'; check that constraint/column/key exists +ERROR 42000: Can't DROP `dc`; check that it exists alter table t3 drop foreign key dc; -ERROR 42000: Can't DROP 'dc'; check that constraint/column/key exists +ERROR 42000: Can't DROP `dc`; check that it exists alter table t4 drop foreign key dc; affected rows: 0 info: Records: 0 Duplicates: 0 Warnings: 0 diff --git a/mysql-test/suite/rpl/r/rpl_extra_col_master_innodb.result b/mysql-test/suite/rpl/r/rpl_extra_col_master_innodb.result index 2bc955c508a..3102c06352f 100644 --- a/mysql-test/suite/rpl/r/rpl_extra_col_master_innodb.result +++ b/mysql-test/suite/rpl/r/rpl_extra_col_master_innodb.result @@ -643,7 +643,7 @@ c1 c3 hex(c4) c5 c6 ************ connection slave; include/wait_for_slave_sql_error.inc [errno=1091] -Last_SQL_Error = 'Error 'Can't DROP 'c7'; check that constraint/column/key exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'' +Last_SQL_Error = 'Error 'Can't DROP `c7`; check that it exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'' STOP SLAVE; RESET SLAVE; diff --git a/mysql-test/suite/rpl/r/rpl_extra_col_master_myisam.result b/mysql-test/suite/rpl/r/rpl_extra_col_master_myisam.result index 47e65c1c3c6..cfec03b45d0 100644 --- a/mysql-test/suite/rpl/r/rpl_extra_col_master_myisam.result +++ b/mysql-test/suite/rpl/r/rpl_extra_col_master_myisam.result @@ -643,7 +643,7 @@ c1 c3 hex(c4) c5 c6 ************ connection slave; include/wait_for_slave_sql_error.inc [errno=1091] -Last_SQL_Error = 'Error 'Can't DROP 'c7'; check that constraint/column/key exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'' +Last_SQL_Error = 'Error 'Can't DROP `c7`; check that it exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'' STOP SLAVE; RESET SLAVE; diff --git a/mysql-test/suite/vcol/r/vcol_view_innodb.result b/mysql-test/suite/vcol/r/vcol_view_innodb.result index 43ade0dddaf..447e2fd89b6 100644 --- a/mysql-test/suite/vcol/r/vcol_view_innodb.result +++ b/mysql-test/suite/vcol/r/vcol_view_innodb.result @@ -270,11 +270,11 @@ c int as (-a) persistent); create view v1 as select * from t1 where b > -2 && c >-2 with check option; insert into v1 (a) values (1); insert into v1 (a) values (3); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `test`.`v1` insert ignore into v1 (a) values (2),(3),(0); Warnings: -Warning 1369 CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' -Warning 1369 CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +Warning 1369 CHECK OPTION failed `test`.`v1` +Warning 1369 CHECK OPTION failed `test`.`v1` select * from t1; a b c 1 -1 -1 diff --git a/mysql-test/suite/vcol/r/vcol_view_myisam.result b/mysql-test/suite/vcol/r/vcol_view_myisam.result index acd3389e170..1b665e91a0f 100644 --- a/mysql-test/suite/vcol/r/vcol_view_myisam.result +++ b/mysql-test/suite/vcol/r/vcol_view_myisam.result @@ -270,11 +270,11 @@ c int as (-a) persistent); create view v1 as select * from t1 where b > -2 && c >-2 with check option; insert into v1 (a) values (1); insert into v1 (a) values (3); -ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +ERROR 44000: CHECK OPTION failed `test`.`v1` insert ignore into v1 (a) values (2),(3),(0); Warnings: -Warning 1369 CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' -Warning 1369 CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1' +Warning 1369 CHECK OPTION failed `test`.`v1` +Warning 1369 CHECK OPTION failed `test`.`v1` select * from t1; a b c 1 -1 -1 |