summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2016-06-26 15:46:36 +0200
committerSergei Golubchik <serg@mariadb.org>2016-06-30 11:43:02 +0200
commit99e48cb1d94e2d884b257b13f792323d3d633322 (patch)
tree0571ed63973349b091a9b306e2dc472254928a60
parentc87e002bbb946907b4c9504612b3b3c2a0a19e51 (diff)
downloadmariadb-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
-rw-r--r--mysql-test/include/function_defaults.inc4
-rw-r--r--mysql-test/r/alter_table.result20
-rw-r--r--mysql-test/r/check_constraint.result20
-rw-r--r--mysql-test/r/constraints.result6
-rw-r--r--mysql-test/r/create_drop_binlog.result2
-rw-r--r--mysql-test/r/create_drop_index.result2
-rw-r--r--mysql-test/r/function_defaults.result8
-rw-r--r--mysql-test/r/function_defaults_innodb.result8
-rw-r--r--mysql-test/r/key.result2
-rw-r--r--mysql-test/r/partition_explicit_prune.result4
-rw-r--r--mysql-test/r/replace.result2
-rw-r--r--mysql-test/r/subselect.result2
-rw-r--r--mysql-test/r/subselect_no_exists_to_in.result2
-rw-r--r--mysql-test/r/subselect_no_mat.result2
-rw-r--r--mysql-test/r/subselect_no_opts.result2
-rw-r--r--mysql-test/r/subselect_no_scache.result2
-rw-r--r--mysql-test/r/subselect_no_semijoin.result2
-rw-r--r--mysql-test/r/view.result78
-rw-r--r--mysql-test/suite/funcs_1/r/innodb_views.result456
-rw-r--r--mysql-test/suite/funcs_1/r/memory_views.result456
-rw-r--r--mysql-test/suite/funcs_1/r/myisam_views-big.result456
-rw-r--r--mysql-test/suite/funcs_1/r/processlist_priv_no_prot.result4
-rw-r--r--mysql-test/suite/funcs_1/views/views_master.inc10
-rw-r--r--mysql-test/suite/innodb/r/innodb-index.result4
-rw-r--r--mysql-test/suite/rpl/r/rpl_extra_col_master_innodb.result2
-rw-r--r--mysql-test/suite/rpl/r/rpl_extra_col_master_myisam.result2
-rw-r--r--mysql-test/suite/vcol/r/vcol_view_innodb.result6
-rw-r--r--mysql-test/suite/vcol/r/vcol_view_myisam.result6
-rw-r--r--mysql-test/t/partition_explicit_prune.test4
-rw-r--r--mysql-test/t/subselect.test2
-rw-r--r--mysql-test/t/view.test50
-rw-r--r--sql/share/errmsg-utf8.txt69
-rw-r--r--sql/table.cc34
-rw-r--r--storage/connect/mysql-test/connect/r/xml_mdev5261.result4
-rw-r--r--storage/tokudb/mysql-test/rpl/r/rpl_extra_col_master_tokudb.result2
35 files changed, 860 insertions, 875 deletions
diff --git a/mysql-test/include/function_defaults.inc b/mysql-test/include/function_defaults.inc
index 8d2387f1cb6..7c5d43b6e74 100644
--- a/mysql-test/include/function_defaults.inc
+++ b/mysql-test/include/function_defaults.inc
@@ -1058,7 +1058,7 @@ SELECT * FROM v1;
--echo # 1970-01-01 03:33:20
SET TIMESTAMP = 2000.000234;
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
UPDATE v1 SET a = 2;
SELECT * FROM t1;
@@ -1083,7 +1083,7 @@ SELECT * FROM v1;
SET TIMESTAMP = 1.126789;
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
INSERT INTO v1 ( c ) VALUES ( 1 ) ON DUPLICATE KEY UPDATE c = 2;
SELECT * FROM v1;
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result
index 7c1686379fe..6a91103279c 100644
--- a/mysql-test/r/alter_table.result
+++ b/mysql-test/r/alter_table.result
@@ -414,12 +414,12 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `b` (`b`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
ALTER TABLE t1 DROP PRIMARY KEY;
-ERROR 42000: Can't DROP 'PRIMARY'; check that constraint/column/key exists
+ERROR 42000: Can't DROP `PRIMARY`; check that it exists
DROP TABLE t1;
create table t1 (a int, b int, key(a));
insert into t1 values (1,1), (2,2);
alter table t1 drop key no_such_key;
-ERROR 42000: Can't DROP 'no_such_key'; check that constraint/column/key exists
+ERROR 42000: Can't DROP `no_such_key`; check that it exists
alter table t1 drop key a;
drop table t1;
CREATE TABLE T12207(a int) ENGINE=MYISAM;
@@ -1374,7 +1374,7 @@ Note 1060 Duplicate column name 'lol'
ALTER TABLE t1 DROP COLUMN IF EXISTS lol;
ALTER TABLE t1 DROP COLUMN IF EXISTS lol;
Warnings:
-Note 1091 Can't DROP 'lol'; check that constraint/column/key exists
+Note 1091 Can't DROP `lol`; check that it exists
ALTER TABLE t1 ADD KEY IF NOT EXISTS x_param(x_param);
ALTER TABLE t1 ADD KEY IF NOT EXISTS x_param(x_param);
Warnings:
@@ -1385,7 +1385,7 @@ Note 1054 Unknown column 'lol' in 't1'
DROP INDEX IF EXISTS x_param ON t1;
DROP INDEX IF EXISTS x_param ON t1;
Warnings:
-Note 1091 Can't DROP 'x_param'; check that constraint/column/key exists
+Note 1091 Can't DROP `x_param`; check that it exists
CREATE INDEX IF NOT EXISTS x_param1 ON t1(x_param);
CREATE INDEX IF NOT EXISTS x_param1 ON t1(x_param);
Warnings:
@@ -1416,7 +1416,7 @@ Note 1060 Duplicate column name 'lol'
ALTER TABLE t1 DROP COLUMN IF EXISTS lol;
ALTER TABLE t1 DROP COLUMN IF EXISTS lol;
Warnings:
-Note 1091 Can't DROP 'lol'; check that constraint/column/key exists
+Note 1091 Can't DROP `lol`; check that it exists
ALTER TABLE t1 ADD KEY IF NOT EXISTS x_param(x_param);
ALTER TABLE t1 ADD KEY IF NOT EXISTS x_param(x_param);
Warnings:
@@ -1427,7 +1427,7 @@ Note 1054 Unknown column 'lol' in 't1'
DROP INDEX IF EXISTS x_param ON t1;
DROP INDEX IF EXISTS x_param ON t1;
Warnings:
-Note 1091 Can't DROP 'x_param'; check that constraint/column/key exists
+Note 1091 Can't DROP `x_param`; check that it exists
CREATE INDEX IF NOT EXISTS x_param1 ON t1(x_param);
CREATE INDEX IF NOT EXISTS x_param1 ON t1(x_param);
Warnings:
@@ -1447,7 +1447,7 @@ Note 1061 Duplicate key name 'fk'
ALTER TABLE t2 DROP FOREIGN KEY IF EXISTS fk;
ALTER TABLE t2 DROP FOREIGN KEY IF EXISTS fk;
Warnings:
-Note 1091 Can't DROP 'fk'; check that constraint/column/key exists
+Note 1091 Can't DROP `fk`; check that it exists
SHOW CREATE TABLE t2;
Table Create Table
t2 CREATE TABLE `t2` (
@@ -1461,7 +1461,7 @@ Note 1061 Duplicate key name 't2_ibfk_1'
ALTER TABLE t2 DROP FOREIGN KEY IF EXISTS t2_ibfk_1;
ALTER TABLE t2 DROP FOREIGN KEY IF EXISTS t2_ibfk_1;
Warnings:
-Note 1091 Can't DROP 't2_ibfk_1'; check that constraint/column/key exists
+Note 1091 Can't DROP `t2_ibfk_1`; check that it exists
SHOW CREATE TABLE t2;
Table Create Table
t2 CREATE TABLE `t2` (
@@ -1486,10 +1486,10 @@ t2 CREATE TABLE `t2` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1
ALTER TABLE t2 DROP KEY k_id, DROP KEY IF EXISTS k_id;
Warnings:
-Note 1091 Can't DROP 'k_id'; check that constraint/column/key exists
+Note 1091 Can't DROP `k_id`; check that it exists
ALTER TABLE t2 DROP COLUMN a, DROP COLUMN IF EXISTS a;
Warnings:
-Note 1091 Can't DROP 'a'; check that constraint/column/key exists
+Note 1091 Can't DROP `a`; check that it exists
SHOW CREATE TABLE t2;
Table Create Table
t2 CREATE TABLE `t2` (
diff --git a/mysql-test/r/check_constraint.result b/mysql-test/r/check_constraint.result
index 657c9326c38..a9e8b1138e9 100644
--- a/mysql-test/r/check_constraint.result
+++ b/mysql-test/r/check_constraint.result
@@ -10,15 +10,15 @@ t1 CREATE TABLE `t1` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1
insert into t1 values (100,100);
insert into t1 values (1,1);
-ERROR HY000: CONSTRAINT 'a' failed for 'test.t1'
+ERROR 23000: CONSTRAINT `a` failed for `test`.`t1`
insert into t1 values (20,1);
-ERROR HY000: CONSTRAINT 'b' failed for 'test.t1'
+ERROR 23000: CONSTRAINT `b` failed for `test`.`t1`
insert into t1 values (20,30);
-ERROR HY000: CONSTRAINT 'min' failed for 'test.t1'
+ERROR 23000: CONSTRAINT `min` failed for `test`.`t1`
insert into t1 values (500,500);
-ERROR HY000: CONSTRAINT 'max' failed for 'test.t1'
+ERROR 23000: CONSTRAINT `max` failed for `test`.`t1`
insert into t1 values (101,101),(102,102),(600,600),(103,103);
-ERROR HY000: CONSTRAINT 'max' failed for 'test.t1'
+ERROR 23000: CONSTRAINT `max` failed for `test`.`t1`
select * from t1;
a b
100 100
@@ -27,7 +27,7 @@ a b
truncate table t1;
insert ignore into t1 values (101,101),(102,102),(600,600),(103,103);
Warnings:
-Warning 1369 CONSTRAINT 'max' failed for 'test.t1'
+Warning 4016 CONSTRAINT `max` failed for `test`.`t1`
select * from t1;
a b
101 101
@@ -44,7 +44,7 @@ a b
103 103
set check_constraint_checks=@save_check_constraint;
alter table t1 add c int default 0 check (c < 10);
-ERROR HY000: CONSTRAINT 'max' failed for table
+ERROR 23000: CONSTRAINT `max` failed for table
set check_constraint_checks=0;
alter table t1 add c int default 0 check (c < 10);
alter table t1 add check (a+b+c < 500);
@@ -60,9 +60,9 @@ t1 CREATE TABLE `t1` (
CONSTRAINT `CONSTRAINT_1` CHECK (a+b+c < 500)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
insert into t1 values(105,105,105);
-ERROR HY000: CONSTRAINT 'c' failed for 'test.t1'
+ERROR 23000: CONSTRAINT `c` failed for `test`.`t1`
insert into t1 values(249,249,9);
-ERROR HY000: CONSTRAINT 'CONSTRAINT_1' failed for 'test.t1'
+ERROR 23000: CONSTRAINT `CONSTRAINT_1` failed for `test`.`t1`
insert into t1 values(105,105,9);
select * from t1;
a b c
@@ -83,7 +83,7 @@ t2 CREATE TABLE `t2` (
CONSTRAINT `CONSTRAINT_1` CHECK (a+b+c < 500)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
alter table t2 drop constraint c;
-ERROR 42000: Can't DROP 'c'; check that constraint/column/key exists
+ERROR 42000: Can't DROP `c`; check that it exists
alter table t2 drop constraint min;
show create table t2;
Table Create Table
diff --git a/mysql-test/r/constraints.result b/mysql-test/r/constraints.result
index 2c101a209ef..9fcb8a0f4d7 100644
--- a/mysql-test/r/constraints.result
+++ b/mysql-test/r/constraints.result
@@ -7,7 +7,7 @@ t1 CREATE TABLE `t1` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1
insert into t1 values (1);
insert into t1 values (0);
-ERROR HY000: CONSTRAINT 'a' failed for 'test.t1'
+ERROR 23000: CONSTRAINT `a` failed for `test`.`t1`
drop table t1;
create table t1 (a int, b int, check (a>b));
show create table t1;
@@ -19,7 +19,7 @@ t1 CREATE TABLE `t1` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1
insert into t1 values (1,0);
insert into t1 values (0,1);
-ERROR HY000: CONSTRAINT 'CONSTRAINT_1' failed for 'test.t1'
+ERROR 23000: CONSTRAINT `CONSTRAINT_1` failed for `test`.`t1`
drop table t1;
create table t1 (a int ,b int, constraint abc check (a>b));
show create table t1;
@@ -31,7 +31,7 @@ t1 CREATE TABLE `t1` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1
insert into t1 values (1,0);
insert into t1 values (0,1);
-ERROR HY000: CONSTRAINT 'abc' failed for 'test.t1'
+ERROR 23000: CONSTRAINT `abc` failed for `test`.`t1`
drop table t1;
create table t1 (a int null);
show create table t1;
diff --git a/mysql-test/r/create_drop_binlog.result b/mysql-test/r/create_drop_binlog.result
index bc08ea82809..e8e8094a347 100644
--- a/mysql-test/r/create_drop_binlog.result
+++ b/mysql-test/r/create_drop_binlog.result
@@ -363,7 +363,7 @@ t1 CREATE TABLE `t1` (
DROP INDEX IF EXISTS i1 ON t1;
DROP INDEX IF EXISTS i1 ON t1;
Warnings:
-Note 1091 Can't DROP 'i1'; check that constraint/column/key exists
+Note 1091 Can't DROP `i1`; check that it exists
DROP TABLE t1;
DROP TABLE IF EXISTS t1;
Warnings:
diff --git a/mysql-test/r/create_drop_index.result b/mysql-test/r/create_drop_index.result
index f7b9ac02da6..a38ab7f6aed 100644
--- a/mysql-test/r/create_drop_index.result
+++ b/mysql-test/r/create_drop_index.result
@@ -16,7 +16,7 @@ t1 CREATE TABLE `t1` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP INDEX IF EXISTS i1 ON t1;
Warnings:
-Note 1091 Can't DROP 'i1'; check that constraint/column/key exists
+Note 1091 Can't DROP `i1`; check that it exists
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
diff --git a/mysql-test/r/function_defaults.result b/mysql-test/r/function_defaults.result
index a5367c4c591..6840e5bbb6c 100644
--- a/mysql-test/r/function_defaults.result
+++ b/mysql-test/r/function_defaults.result
@@ -1443,7 +1443,7 @@ a b
# 1970-01-01 03:33:20
SET TIMESTAMP = 2000.000234;
UPDATE v1 SET a = 2;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
SELECT * FROM t1;
a b
1 1970-01-01 03:16:40
@@ -1466,7 +1466,7 @@ a c
1973-08-14 09:11:22 1
SET TIMESTAMP = 1.126789;
INSERT INTO v1 ( c ) VALUES ( 1 ) ON DUPLICATE KEY UPDATE c = 2;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
SELECT * FROM v1;
a c
1973-08-14 09:11:22 1
@@ -2989,7 +2989,7 @@ a b
# 1970-01-01 03:33:20
SET TIMESTAMP = 2000.000234;
UPDATE v1 SET a = 2;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
SELECT * FROM t1;
a b
1 1970-01-01 03:16:40.123456
@@ -3012,7 +3012,7 @@ a c
1973-08-14 09:11:22.089786 1
SET TIMESTAMP = 1.126789;
INSERT INTO v1 ( c ) VALUES ( 1 ) ON DUPLICATE KEY UPDATE c = 2;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
SELECT * FROM v1;
a c
1973-08-14 09:11:22.089786 1
diff --git a/mysql-test/r/function_defaults_innodb.result b/mysql-test/r/function_defaults_innodb.result
index ee89d847a5c..a877d27dba7 100644
--- a/mysql-test/r/function_defaults_innodb.result
+++ b/mysql-test/r/function_defaults_innodb.result
@@ -1444,7 +1444,7 @@ a b
# 1970-01-01 03:33:20
SET TIMESTAMP = 2000.000234;
UPDATE v1 SET a = 2;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
SELECT * FROM t1;
a b
1 1970-01-01 03:16:40
@@ -1467,7 +1467,7 @@ a c
1973-08-14 09:11:22 1
SET TIMESTAMP = 1.126789;
INSERT INTO v1 ( c ) VALUES ( 1 ) ON DUPLICATE KEY UPDATE c = 2;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
SELECT * FROM v1;
a c
1973-08-14 09:11:22 1
@@ -2990,7 +2990,7 @@ a b
# 1970-01-01 03:33:20
SET TIMESTAMP = 2000.000234;
UPDATE v1 SET a = 2;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
SELECT * FROM t1;
a b
1 1970-01-01 03:16:40.123456
@@ -3013,7 +3013,7 @@ a c
1973-08-14 09:11:22.089786 1
SET TIMESTAMP = 1.126789;
INSERT INTO v1 ( c ) VALUES ( 1 ) ON DUPLICATE KEY UPDATE c = 2;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
SELECT * FROM v1;
a c
1973-08-14 09:11:22.089786 1
diff --git a/mysql-test/r/key.result b/mysql-test/r/key.result
index 806cc7a7b1a..0d6e7d046e7 100644
--- a/mysql-test/r/key.result
+++ b/mysql-test/r/key.result
@@ -467,7 +467,7 @@ alter table t1 drop index c2, add index (c2(4),c3(7));
alter table t1 add primary key (c1, c2), drop primary key;
alter table t1 drop primary key;
alter table t1 add primary key (c1, c2), drop primary key;
-ERROR 42000: Can't DROP 'PRIMARY'; check that constraint/column/key exists
+ERROR 42000: Can't DROP `PRIMARY`; check that it exists
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
diff --git a/mysql-test/r/partition_explicit_prune.result b/mysql-test/r/partition_explicit_prune.result
index 1719556d9c8..ef196bcae0c 100644
--- a/mysql-test/r/partition_explicit_prune.result
+++ b/mysql-test/r/partition_explicit_prune.result
@@ -126,7 +126,7 @@ HANDLER_WRITE 2
# 4 locks (1 table, 1 partition lock/unlock)
FLUSH STATUS;
INSERT INTO v1 VALUES (31);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS
WHERE VARIABLE_NAME LIKE 'HANDLER_%' AND VARIABLE_VALUE > 0;
VARIABLE_NAME VARIABLE_VALUE
@@ -135,7 +135,7 @@ HANDLER_TMP_WRITE 22
# 2 locks (1 table, all partitions pruned)
FLUSH STATUS;
INSERT INTO v1 VALUES (32);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS
WHERE VARIABLE_NAME LIKE 'HANDLER_%' AND VARIABLE_VALUE > 0;
VARIABLE_NAME VARIABLE_VALUE
diff --git a/mysql-test/r/replace.result b/mysql-test/r/replace.result
index 2c1fc263b2d..9590a97e10a 100644
--- a/mysql-test/r/replace.result
+++ b/mysql-test/r/replace.result
@@ -27,6 +27,6 @@ drop table t1;
CREATE TABLE t1 (f1 INT);
CREATE VIEW v1 AS SELECT f1 FROM t1 WHERE f1 = 0 WITH CHECK OPTION;
REPLACE INTO v1 (f1) VALUES (1);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
DROP TABLE t1;
DROP VIEW v1;
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result
index 45daac4fa10..bd30c04f272 100644
--- a/mysql-test/r/subselect.result
+++ b/mysql-test/r/subselect.result
@@ -5001,7 +5001,7 @@ CREATE VIEW v2 (a,b) AS
SELECT t2.id, t2.c AS c FROM t1, t2
WHERE t1.id=t2.id AND 1 IN (SELECT id FROM t1) WITH CHECK OPTION;
INSERT INTO v2(a,b) VALUES (2,2);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
SELECT * FROM v1;
c
1
diff --git a/mysql-test/r/subselect_no_exists_to_in.result b/mysql-test/r/subselect_no_exists_to_in.result
index f95704a28b1..8ef7fe90a40 100644
--- a/mysql-test/r/subselect_no_exists_to_in.result
+++ b/mysql-test/r/subselect_no_exists_to_in.result
@@ -5003,7 +5003,7 @@ CREATE VIEW v2 (a,b) AS
SELECT t2.id, t2.c AS c FROM t1, t2
WHERE t1.id=t2.id AND 1 IN (SELECT id FROM t1) WITH CHECK OPTION;
INSERT INTO v2(a,b) VALUES (2,2);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
SELECT * FROM v1;
c
1
diff --git a/mysql-test/r/subselect_no_mat.result b/mysql-test/r/subselect_no_mat.result
index d2a412caa1d..3b4d54b12e9 100644
--- a/mysql-test/r/subselect_no_mat.result
+++ b/mysql-test/r/subselect_no_mat.result
@@ -5001,7 +5001,7 @@ CREATE VIEW v2 (a,b) AS
SELECT t2.id, t2.c AS c FROM t1, t2
WHERE t1.id=t2.id AND 1 IN (SELECT id FROM t1) WITH CHECK OPTION;
INSERT INTO v2(a,b) VALUES (2,2);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
SELECT * FROM v1;
c
1
diff --git a/mysql-test/r/subselect_no_opts.result b/mysql-test/r/subselect_no_opts.result
index f06e2d8e554..8f5a967c516 100644
--- a/mysql-test/r/subselect_no_opts.result
+++ b/mysql-test/r/subselect_no_opts.result
@@ -4997,7 +4997,7 @@ CREATE VIEW v2 (a,b) AS
SELECT t2.id, t2.c AS c FROM t1, t2
WHERE t1.id=t2.id AND 1 IN (SELECT id FROM t1) WITH CHECK OPTION;
INSERT INTO v2(a,b) VALUES (2,2);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
SELECT * FROM v1;
c
1
diff --git a/mysql-test/r/subselect_no_scache.result b/mysql-test/r/subselect_no_scache.result
index ab27af586aa..4a50b01e9b3 100644
--- a/mysql-test/r/subselect_no_scache.result
+++ b/mysql-test/r/subselect_no_scache.result
@@ -5007,7 +5007,7 @@ CREATE VIEW v2 (a,b) AS
SELECT t2.id, t2.c AS c FROM t1, t2
WHERE t1.id=t2.id AND 1 IN (SELECT id FROM t1) WITH CHECK OPTION;
INSERT INTO v2(a,b) VALUES (2,2);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
SELECT * FROM v1;
c
1
diff --git a/mysql-test/r/subselect_no_semijoin.result b/mysql-test/r/subselect_no_semijoin.result
index d3be251a9e5..d253f48d593 100644
--- a/mysql-test/r/subselect_no_semijoin.result
+++ b/mysql-test/r/subselect_no_semijoin.result
@@ -4997,7 +4997,7 @@ CREATE VIEW v2 (a,b) AS
SELECT t2.id, t2.c AS c FROM t1, t2
WHERE t1.id=t2.id AND 1 IN (SELECT id FROM t1) WITH CHECK OPTION;
INSERT INTO v2(a,b) VALUES (2,2);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
SELECT * FROM v1;
c
1
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result
index 1bf740698fe..8ab215fd99a 100644
--- a/mysql-test/r/view.result
+++ b/mysql-test/r/view.result
@@ -253,7 +253,7 @@ drop view v1;
drop table t1;
create table t1 (a int);
create view v1 as select distinct a from t1 WITH CHECK OPTION;
-ERROR HY000: CHECK OPTION on non-updatable view 'test.v1'
+ERROR HY000: CHECK OPTION on non-updatable view `test`.`v1`
create view v1 as select a from t1 WITH CHECK OPTION;
create view v2 as select a from t1 WITH CASCADED CHECK OPTION;
create view v3 as select a from t1 WITH LOCAL CHECK OPTION;
@@ -1134,11 +1134,11 @@ create table t1 (a int);
create view v1 as select * from t1 where a < 2 with check option;
insert into v1 values(1);
insert into v1 values(3);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
insert ignore into v1 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
1
@@ -1146,20 +1146,20 @@ a
delete from t1;
insert into v1 SELECT 1;
insert into v1 SELECT 3;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
create table t2 (a int);
insert into t2 values (2),(3),(0);
insert ignore into v1 SELECT a from t2;
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 order by a desc;
a
1
0
update v1 set a=-1 where a=0;
update v1 set a=2 where a=1;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
select * from t1 order by a desc;
a
1
@@ -1174,7 +1174,7 @@ a
update v1 set a=a+1;
update ignore v1,t2 set v1.a=v1.a+1 where v1.a=t2.a;
Warnings:
-Warning 1369 CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+Warning 1369 CHECK OPTION failed `test`.`v1`
select * from t1;
a
1
@@ -1188,12 +1188,12 @@ create view v3 as select * from v1 where a > 0 with cascaded check option;
insert into v2 values (1);
insert into v3 values (1);
insert into v2 values (0);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
insert into v3 values (0);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3'
+ERROR 44000: CHECK OPTION failed `test`.`v3`
insert into v2 values (2);
insert into v3 values (2);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v3'
+ERROR 44000: CHECK OPTION failed `test`.`v3`
select * from t1;
a
1
@@ -1205,10 +1205,10 @@ create table t1 (a int, primary key (a));
create view v1 as select * from t1 where a < 2 with check option;
insert into v1 values (1) on duplicate key update a=2;
insert into v1 values (1) on duplicate key update a=2;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
insert ignore into v1 values (1) on duplicate key update a=2;
Warnings:
-Warning 1369 CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+Warning 1369 CHECK OPTION failed `test`.`v1`
select * from t1;
a
1
@@ -1263,7 +1263,7 @@ s1
alter view v2 as select * from t2 where s1 in (select s1 from t1) with check option;
insert into v2 values (5);
update v2 set s1 = 1;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
insert into t1 values (1);
update v2 set s1 = 1;
select * from v2;
@@ -1300,16 +1300,16 @@ create table t1 (s1 tinyint);
create view v1 as select * from t1 where s1 <> 0 with local check option;
create view v2 as select * from v1 with cascaded check option;
insert into v2 values (0);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
drop view v2, v1;
drop table t1;
create table t1 (s1 int);
create view v1 as select * from t1 where s1 < 5 with check option;
insert ignore into v1 values (6);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
insert ignore into v1 values (6),(3);
Warnings:
-Warning 1369 CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+Warning 1369 CHECK OPTION failed `test`.`v1`
select * from t1;
s1
3
@@ -1319,7 +1319,7 @@ create table t1 (s1 tinyint);
create trigger t1_bi before insert on t1 for each row set new.s1 = 500;
create view v1 as select * from t1 where s1 <> 127 with check option;
insert into v1 values (0);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
select * from v1;
s1
select * from t1;
@@ -1331,7 +1331,7 @@ create table t1 (s1 tinyint);
create view v1 as select * from t1 where s1 <> 0;
create view v2 as select * from v1 where s1 <> 1 with cascaded check option;
insert into v2 values (0);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
select * from v2;
s1
select * from t1;
@@ -1341,7 +1341,7 @@ drop table t1;
create table t1 (a int, b char(10));
create view v1 as select * from t1 where a != 0 with check option;
load data infile '../../std_data/loaddata3.dat' into table v1 fields terminated by '' enclosed by '' ignore 1 lines;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
select * from t1;
a b
1 row 1
@@ -1356,10 +1356,10 @@ Warnings:
Note 1265 Data truncated for column 'a' at row 1
Note 1265 Data truncated for column 'a' at row 2
Warning 1366 Incorrect integer value: 'error ' for column 'a' at row 3
-Warning 1369 CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+Warning 1369 CHECK OPTION failed `test`.`v1`
Note 1265 Data truncated for column 'a' at row 3
Warning 1366 Incorrect integer value: 'wrong end ' for column 'a' at row 4
-Warning 1369 CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+Warning 1369 CHECK OPTION failed `test`.`v1`
select * from t1 order by a,b;
a b
1 row 1
@@ -1375,7 +1375,7 @@ drop table t1;
create table t1 (a text, b text);
create view v1 as select * from t1 where a <> 'Field A' with check option;
load data infile '../../std_data/loaddata2.dat' into table v1 fields terminated by ',' enclosed by '''';
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
select concat('|',a,'|'), concat('|',b,'|') from t1;
concat('|',a,'|') concat('|',b,'|')
select concat('|',a,'|'), concat('|',b,'|') from v1;
@@ -1383,7 +1383,7 @@ concat('|',a,'|') concat('|',b,'|')
delete from t1;
load data infile '../../std_data/loaddata2.dat' ignore into table v1 fields terminated by ',' enclosed by '''';
Warnings:
-Warning 1369 CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+Warning 1369 CHECK OPTION failed `test`.`v1`
Warning 1261 Row 2 doesn't contain data for all columns
select concat('|',a,'|'), concat('|',b,'|') from t1;
concat('|',a,'|') concat('|',b,'|')
@@ -3047,9 +3047,9 @@ CREATE VIEW v1 AS SELECT id, val FROM t1 WHERE val >= 1 AND val <= 5 WITH CHECK
INSERT INTO v1 (val) VALUES (2);
INSERT INTO v1 (val) VALUES (4);
INSERT INTO v1 (val) VALUES (6);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
UPDATE v1 SET val=6 WHERE id=2;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
DROP VIEW v1;
DROP TABLE t1;
DROP VIEW IF EXISTS v1, v2;
@@ -3135,7 +3135,7 @@ b
1
2
UPDATE v1 SET b=3;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
SELECT * FROM v1;
b
1
@@ -3467,14 +3467,14 @@ a1 c
1 0
2 0
UPDATE v1 SET c=3;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
PREPARE t FROM 'UPDATE v1 SET c=3';
EXECUTE t;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
EXECUTE t;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
INSERT INTO v1(a1, c) VALUES (3, 3);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v1'
+ERROR 44000: CHECK OPTION failed `test`.`v1`
UPDATE v1 SET c=1 WHERE a1=1;
SELECT * FROM v1;
a1 c
@@ -3493,14 +3493,14 @@ a1 c
1 1
2 0
UPDATE v2 SET c=3;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
PREPARE t FROM 'UPDATE v2 SET c=3';
EXECUTE t;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
EXECUTE t;
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
INSERT INTO v2(a1, c) VALUES (3, 3);
-ERROR HY000: CONSTRAINT 'WITH CHECK OPTION' failed for 'test.v2'
+ERROR 44000: CHECK OPTION failed `test`.`v2`
UPDATE v2 SET c=2 WHERE a1=1;
SELECT * FROM v2;
a1 c
@@ -4746,13 +4746,13 @@ drop view if exists v_9801;
create table t_9801 (s1 int);
create view v_9801 as
select sum(s1) from t_9801 with check option;
-ERROR HY000: CHECK OPTION on non-updatable view 'test.v_9801'
+ERROR HY000: CHECK OPTION on non-updatable view `test`.`v_9801`
create view v_9801 as
select sum(s1) from t_9801 group by s1 with check option;
-ERROR HY000: CHECK OPTION on non-updatable view 'test.v_9801'
+ERROR HY000: CHECK OPTION on non-updatable view `test`.`v_9801`
create view v_9801 as
select sum(s1) from t_9801 group by s1 with rollup with check option;
-ERROR HY000: CHECK OPTION on non-updatable view 'test.v_9801'
+ERROR HY000: CHECK OPTION on non-updatable view `test`.`v_9801`
drop table t_9801;
#
# Bug #47335 assert in get_table_share
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
diff --git a/mysql-test/t/partition_explicit_prune.test b/mysql-test/t/partition_explicit_prune.test
index 36ae47a027a..68b829fbcc3 100644
--- a/mysql-test/t/partition_explicit_prune.test
+++ b/mysql-test/t/partition_explicit_prune.test
@@ -68,12 +68,12 @@ INSERT INTO v1 VALUES (30);
eval $get_handler_status_counts;
--echo # 4 locks (1 table, 1 partition lock/unlock)
FLUSH STATUS;
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
INSERT INTO v1 VALUES (31);
eval $get_handler_status_counts;
--echo # 2 locks (1 table, all partitions pruned)
FLUSH STATUS;
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
INSERT INTO v1 VALUES (32);
eval $get_handler_status_counts;
--echo # 4 locks (1 table, 1 partition lock/unlock)
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test
index 111fb51d961..c19613da493 100644
--- a/mysql-test/t/subselect.test
+++ b/mysql-test/t/subselect.test
@@ -4129,7 +4129,7 @@ CREATE VIEW v2 (a,b) AS
SELECT t2.id, t2.c AS c FROM t1, t2
WHERE t1.id=t2.id AND 1 IN (SELECT id FROM t1) WITH CHECK OPTION;
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
INSERT INTO v2(a,b) VALUES (2,2);
# disabled for now as this refers to old content of t2
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test
index 9086240ade8..e2bc2168385 100644
--- a/mysql-test/t/view.test
+++ b/mysql-test/t/view.test
@@ -1051,7 +1051,7 @@ create table t1 (a int);
create view v1 as select * from t1 where a < 2 with check option;
# simple insert
insert into v1 values(1);
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
insert into v1 values(3);
# simple insert with ignore
insert ignore into v1 values (2),(3),(0);
@@ -1060,7 +1060,7 @@ select * from t1;
delete from t1;
# INSERT SELECT test
insert into v1 SELECT 1;
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
insert into v1 SELECT 3;
# prepare data for next check
create table t2 (a int);
@@ -1070,7 +1070,7 @@ insert ignore into v1 SELECT a from t2;
select * from t1 order by a desc;
# simple UPDATE test
update v1 set a=-1 where a=0;
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
update v1 set a=2 where a=1;
select * from t1 order by a desc;
# prepare data for next check
@@ -1097,12 +1097,12 @@ create view v2 as select * from v1 where a > 0 with local check option;
create view v3 as select * from v1 where a > 0 with cascaded check option;
insert into v2 values (1);
insert into v3 values (1);
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
insert into v2 values (0);
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
insert into v3 values (0);
insert into v2 values (2);
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
insert into v3 values (2);
select * from t1;
drop view v3,v2,v1;
@@ -1114,7 +1114,7 @@ drop table t1;
create table t1 (a int, primary key (a));
create view v1 as select * from t1 where a < 2 with check option;
insert into v1 values (1) on duplicate key update a=2;
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
insert into v1 values (1) on duplicate key update a=2;
insert ignore into v1 values (1) on duplicate key update a=2;
select * from t1;
@@ -1168,7 +1168,7 @@ select * from t2;
# check it with check option
alter view v2 as select * from t2 where s1 in (select s1 from t1) with check option;
insert into v2 values (5);
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
update v2 set s1 = 1;
insert into t1 values (1);
update v2 set s1 = 1;
@@ -1200,7 +1200,7 @@ drop table t1;
create table t1 (s1 tinyint);
create view v1 as select * from t1 where s1 <> 0 with local check option;
create view v2 as select * from v1 with cascaded check option;
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
insert into v2 values (0);
drop view v2, v1;
drop table t1;
@@ -1211,7 +1211,7 @@ drop table t1;
create table t1 (s1 int);
create view v1 as select * from t1 where s1 < 5 with check option;
#single value
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
insert ignore into v1 values (6);
#several values
insert ignore into v1 values (6),(3);
@@ -1225,7 +1225,7 @@ drop table t1;
create table t1 (s1 tinyint);
create trigger t1_bi before insert on t1 for each row set new.s1 = 500;
create view v1 as select * from t1 where s1 <> 127 with check option;
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
insert into v1 values (0);
select * from v1;
select * from t1;
@@ -1239,7 +1239,7 @@ drop table t1;
create table t1 (s1 tinyint);
create view v1 as select * from t1 where s1 <> 0;
create view v2 as select * from v1 where s1 <> 1 with cascaded check option;
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
insert into v2 values (0);
select * from v2;
select * from t1;
@@ -1252,7 +1252,7 @@ drop table t1;
# fixed length fields
create table t1 (a int, b char(10));
create view v1 as select * from t1 where a != 0 with check option;
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
load data infile '../../std_data/loaddata3.dat' into table v1 fields terminated by '' enclosed by '' ignore 1 lines;
select * from t1;
select * from v1;
@@ -1265,7 +1265,7 @@ drop table t1;
# variable length fields
create table t1 (a text, b text);
create view v1 as select * from t1 where a <> 'Field A' with check option;
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
load data infile '../../std_data/loaddata2.dat' into table v1 fields terminated by ',' enclosed by '''';
select concat('|',a,'|'), concat('|',b,'|') from t1;
select concat('|',a,'|'), concat('|',b,'|') from v1;
@@ -3017,9 +3017,9 @@ CREATE TABLE t1(id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, val INT UNS
CREATE VIEW v1 AS SELECT id, val FROM t1 WHERE val >= 1 AND val <= 5 WITH CHECK OPTION;
INSERT INTO v1 (val) VALUES (2);
INSERT INTO v1 (val) VALUES (4);
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
INSERT INTO v1 (val) VALUES (6);
--- error ER_CONSTRAINT_FAILED
+-- error ER_VIEW_CHECK_FAILED
UPDATE v1 SET val=6 WHERE id=2;
DROP VIEW v1;
DROP TABLE t1;
@@ -3122,7 +3122,7 @@ CREATE VIEW v1 AS
SELECT t2.b FROM t1,t2 WHERE t1.a = t2.b WITH CHECK OPTION;
SELECT * FROM v1;
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
UPDATE v1 SET b=3;
SELECT * FROM v1;
SELECT * FROM t1;
@@ -3396,14 +3396,14 @@ CREATE VIEW v1 AS
SELECT t1.a1, t1.c FROM t1 JOIN t2 ON t1.a1=t2.a2 AND t1.c < 3
WITH CHECK OPTION;
SELECT * FROM v1;
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
UPDATE v1 SET c=3;
PREPARE t FROM 'UPDATE v1 SET c=3';
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
EXECUTE t;
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
EXECUTE t;
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
INSERT INTO v1(a1, c) VALUES (3, 3);
UPDATE v1 SET c=1 WHERE a1=1;
SELECT * FROM v1;
@@ -3414,14 +3414,14 @@ CREATE VIEW v2 AS SELECT t1.a1, t1.c
JOIN (t3 JOIN t4 ON t3.a3=t4.a4)
ON t2.a2=t3.a3 WITH CHECK OPTION;
SELECT * FROM v2;
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
UPDATE v2 SET c=3;
PREPARE t FROM 'UPDATE v2 SET c=3';
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
EXECUTE t;
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
EXECUTE t;
---error ER_CONSTRAINT_FAILED
+--error ER_VIEW_CHECK_FAILED
INSERT INTO v2(a1, c) VALUES (3, 3);
UPDATE v2 SET c=2 WHERE a1=1;
SELECT * FROM v2;
diff --git a/sql/share/errmsg-utf8.txt b/sql/share/errmsg-utf8.txt
index 9bdcf154848..ba75a6a9149 100644
--- a/sql/share/errmsg-utf8.txt
+++ b/sql/share/errmsg-utf8.txt
@@ -2071,29 +2071,29 @@ ER_CANT_REMOVE_ALL_FIELDS 42000
swe "Man kan inte radera alla fält med ALTER TABLE. Använd DROP TABLE istället"
ukr "Не можливо видалити всі стовбці за допомогою ALTER TABLE. Для цього скористайтеся DROP TABLE"
ER_CANT_DROP_FIELD_OR_KEY 42000
- cze "Nemohu zrušit '%-.192s' (provést DROP). Zkontrolujte, zda neexistují záznamy/klíče"
- dan "Kan ikke udføre DROP '%-.192s'. Undersøg om feltet/nøglen eksisterer."
- nla "Kan '%-.192s' niet weggooien. Controleer of het veld of de zoeksleutel daadwerkelijk bestaat."
- eng "Can't DROP '%-.192s'; check that constraint/column/key exists"
- est "Ei suuda kustutada '%-.192s'. Kontrolli kas tulp/võti eksisteerib"
- fre "Ne peut effacer (DROP) '%-.192s'. Vérifiez s'il existe"
- ger "Kann '%-.192s' nicht löschen. Existiert die Spalte oder der Schlüssel?"
- greek "Αδύνατη η διαγραφή (DROP) '%-.192s'. Παρακαλώ ελέγξτε αν το πεδίο/κλειδί υπάρχει"
- hun "A DROP '%-.192s' nem lehetseges. Ellenorizze, hogy a mezo/kulcs letezik-e"
- ita "Impossibile cancellare '%-.192s'. Controllare che il campo chiave esista"
- jpn "'%-.192s' を削除できません。列/索引の存在を確認して下さい。"
- kor "'%-.192s'를 DROP할 수 없습니다. 칼럼이나 키가 존재하는지 채크하세요."
- nor "Kan ikke DROP '%-.192s'. Undersøk om felt/nøkkel eksisterer."
- norwegian-ny "Kan ikkje DROP '%-.192s'. Undersøk om felt/nøkkel eksisterar."
- pol "Nie można wykonać operacji DROP '%-.192s'. SprawdĽ, czy to pole/klucz istnieje"
- por "Não se pode fazer DROP '%-.192s'. Confira se esta coluna/chave existe"
- rum "Nu pot sa DROP '%-.192s'. Verifica daca coloana/cheia exista"
- rus "Невозможно удалить (DROP) '%-.192s'. Убедитесь что столбец/ключ действительно существует"
- serbian "Ne mogu da izvršim komandu drop 'DROP' na '%-.192s'. Proverite da li ta kolona (odnosno ključ) postoji"
- slo "Nemôžem zrušiť (DROP) '%-.192s'. Skontrolujte, či neexistujú záznamy/kľúče"
- spa "No puedo ELIMINAR '%-.192s'. compuebe que el campo/clave existe"
- swe "Kan inte ta bort '%-.192s'. Kontrollera att begränsningen/fältet/nyckel finns"
- ukr "Не можу DROP '%-.192s'. Перевірте, чи цей стовбець/ключ існує"
+ cze "Nemohu zrušit %`-.192s (provést DROP). Zkontrolujte, zda neexistují záznamy/klíče"
+ dan "Kan ikke udføre DROP %`-.192s. Undersøg om feltet/nøglen eksisterer."
+ nla "Kan %`-.192s niet weggooien. Controleer of het veld of de zoeksleutel daadwerkelijk bestaat."
+ eng "Can't DROP %`-.192s; check that it exists"
+ est "Ei suuda kustutada %`-.192s. Kontrolli kas tulp/võti eksisteerib"
+ fre "Ne peut effacer (DROP) %`-.192s. Vérifiez s'il existe"
+ ger "Kann %`-.192s nicht löschen. Existiert es?"
+ greek "Αδύνατη η διαγραφή (DROP) %`-.192s. Παρακαλώ ελέγξτε αν το πεδίο/κλειδί υπάρχει"
+ hun "A DROP %`-.192s nem lehetseges. Ellenorizze, hogy a mezo/kulcs letezik-e"
+ ita "Impossibile cancellare %`-.192s. Controllare che il campo chiave esista"
+ jpn "%`-.192s を削除できません。列/索引の存在を確認して下さい。"
+ kor "%`-.192s를 DROP할 수 없습니다. 칼럼이나 키가 존재하는지 채크하세요."
+ nor "Kan ikke DROP %`-.192s. Undersøk om felt/nøkkel eksisterer."
+ norwegian-ny "Kan ikkje DROP %`-.192s. Undersøk om felt/nøkkel eksisterar."
+ pol "Nie można wykonać operacji DROP %`-.192s. SprawdĽ, czy to pole/klucz istnieje"
+ por "Não se pode fazer DROP %`-.192s. Confira se esta coluna/chave existe"
+ rum "Nu pot sa DROP %`-.192s. Verifica daca coloana/cheia exista"
+ rus "Невозможно удалить (DROP) %`-.192s. Убедитесь что он действительно существует"
+ serbian "Ne mogu da izvršim komandu drop 'DROP' na %`-.192s. Proverite da li ta kolona (odnosno ključ) postoji"
+ slo "Nemôžem zrušiť (DROP) %`-.192s. Skontrolujte, či neexistujú záznamy/kľúče"
+ spa "No puedo ELIMINAR %`-.192s. compuebe que el campo/clave existe"
+ swe "Kan inte ta bort %`-.192s. Kontrollera att begränsningen/fältet/nyckel finns"
+ ukr "Не можу DROP %`-.192s. Перевірте, чи він існує"
ER_INSERT_INFO
cze "Záznamů: %ld Zdvojených: %ld Varování: %ld"
dan "Poster: %ld Ens: %ld Advarsler: %ld"
@@ -5286,15 +5286,15 @@ ER_ILLEGAL_VALUE_FOR_TYPE 22007
eng "Illegal %s '%-.192s' value found during parsing"
ger "Nicht zulässiger %s-Wert '%-.192s' beim Parsen gefunden"
ER_VIEW_NONUPD_CHECK
- eng "CHECK OPTION on non-updatable view '%-.192s.%-.192s'"
- ger "CHECK OPTION auf nicht-aktualisierbarem View '%-.192s.%-.192s'"
- rus "CHECK OPTION для необновляемого VIEW '%-.192s.%-.192s'"
- ukr "CHECK OPTION для VIEW '%-.192s.%-.192s' що не може бути оновленним"
-ER_CONSTRAINT_FAILED
- eng "CONSTRAINT '%s' failed for '%-.192s.%-.192s'"
- ger "CONSTRAINT '%s' fehlgeschlagen: '%-.192s.%-.192s'"
- rus "проверка CONSTRAINT '%s' для '%-.192s.%-.192s' провалилась"
- ukr "Перевірка CONSTRAINT '%s' для '%-.192s.%-.192s' не пройшла"
+ eng "CHECK OPTION on non-updatable view %`-.192s.%`-.192s"
+ ger "CHECK OPTION auf nicht-aktualisierbarem View %`-.192s.%`-.192s"
+ rus "CHECK OPTION для необновляемого VIEW %`-.192s.%`-.192s"
+ ukr "CHECK OPTION для VIEW %`-.192s.%`-.192s що не може бути оновленним"
+ER_VIEW_CHECK_FAILED 44000
+ eng "CHECK OPTION failed %`-.192s.%`-.192s"
+ ger "CHECK OPTION fehlgeschlagen: %`-.192s.%`-.192s"
+ rus "Проверка CHECK OPTION для VIEW %`-.192s.%`-.192s провалилась"
+ ukr "Перевірка CHECK OPTION для VIEW %`-.192s.%`-.192s не пройшла"
ER_PROCACCESS_DENIED_ERROR 42000
eng "%-.32s command denied to user '%s'@'%s' for routine '%-.192s'"
ger "Befehl %-.32s nicht zulässig für Benutzer '%s'@'%s' in Routine '%-.192s'"
@@ -7203,6 +7203,11 @@ ER_WINDOW_FUNCTION_DONT_HAVE_FRAME
eng "This window function may not have a window frame"
ER_INVALID_NTILE_ARGUMENT
eng "Argument of NTILE must be greater than 0"
+ER_CONSTRAINT_FAILED 23000
+ eng "CONSTRAINT %`s failed for %`-.192s.%`-.192s"
+ ger "CONSTRAINT %`s fehlgeschlagen: %`-.192s.%`-.192s"
+ rus "проверка CONSTRAINT %`s для %`-.192s.%`-.192s провалилась"
+ ukr "Перевірка CONSTRAINT %`s для %`-.192s.%`-.192s не пройшла"
ER_EXPRESSION_IS_TOO_BIG
eng "%s expression is too big for '%s'"
ER_ERROR_EVALUATING_EXPRESSION
diff --git a/sql/table.cc b/sql/table.cc
index 45d4ec1ab16..d1508751fb3 100644
--- a/sql/table.cc
+++ b/sql/table.cc
@@ -4973,26 +4973,6 @@ void TABLE_LIST::cleanup_items()
}
-static int check_constraint_error(THD *thd, const char *db_name,
- const char *table_name,
- const LEX_STRING *constraint_name,
- bool ignore_failure)
-{
- if (ignore_failure)
- {
- push_warning_printf(thd, Sql_condition::WARN_LEVEL_WARN,
- ER_CONSTRAINT_FAILED,
- ER_THD(thd, ER_CONSTRAINT_FAILED),
- constraint_name->str ? constraint_name->str : "",
- db_name, table_name);
- return(VIEW_CHECK_SKIP);
- }
- my_error(ER_CONSTRAINT_FAILED, MYF(0),
- constraint_name->str ? constraint_name->str : "",
- db_name, table_name);
- return VIEW_CHECK_ERROR;
-}
-
/*
check CHECK OPTION condition both for view and underlying table
@@ -5019,8 +4999,9 @@ int TABLE_LIST::view_check_option(THD *thd, bool ignore_failure)
main_view->db);
const char *name_table= (main_view->view ? main_view->view_name.str :
main_view->table_name);
- return check_constraint_error(thd, name_db, name_table, &view_check_name,
- ignore_failure);
+ my_error(ER_VIEW_CHECK_FAILED, MYF(ignore_failure ? ME_JUST_WARNING : 0),
+ name_db, name_table);
+ return ignore_failure ? VIEW_CHECK_SKIP : VIEW_CHECK_ERROR;
}
return table->verify_constraints(ignore_failure);
}
@@ -5036,11 +5017,10 @@ int TABLE::verify_constraints(bool ignore_failure)
{
if ((*chk)->expr_item->val_int() == 0)
{
- return check_constraint_error(in_use,
- s->db.str,
- s->table_name.str,
- &(*chk)->name,
- ignore_failure);
+ my_error(ER_CONSTRAINT_FAILED,
+ MYF(ignore_failure ? ME_JUST_WARNING : 0), (*chk)->name.str,
+ s->db.str, s->table_name.str);
+ return ignore_failure ? VIEW_CHECK_SKIP : VIEW_CHECK_ERROR;
}
}
}
diff --git a/storage/connect/mysql-test/connect/r/xml_mdev5261.result b/storage/connect/mysql-test/connect/r/xml_mdev5261.result
index 39288a91c1e..2a3ecedcb3a 100644
--- a/storage/connect/mysql-test/connect/r/xml_mdev5261.result
+++ b/storage/connect/mysql-test/connect/r/xml_mdev5261.result
@@ -19,7 +19,7 @@ SELECT * FROM t1 WHERE i = 5;
i
5
ALTER TABLE t1 DROP INDEX i;
-ERROR 42000: Can't DROP 'i'; check that constraint/column/key exists
+ERROR 42000: Can't DROP `i`; check that it exists
DROP INDEX i ON t1;
-ERROR 42000: Can't DROP 'i'; check that constraint/column/key exists
+ERROR 42000: Can't DROP `i`; check that it exists
DROP TABLE t1;
diff --git a/storage/tokudb/mysql-test/rpl/r/rpl_extra_col_master_tokudb.result b/storage/tokudb/mysql-test/rpl/r/rpl_extra_col_master_tokudb.result
index 3f3f59c7620..13613f7e334 100644
--- a/storage/tokudb/mysql-test/rpl/r/rpl_extra_col_master_tokudb.result
+++ b/storage/tokudb/mysql-test/rpl/r/rpl_extra_col_master_tokudb.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;