summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2018-12-19 02:30:22 +0100
committerSergei Golubchik <serg@mariadb.org>2018-12-20 08:06:55 +0100
commita79183b01e4e1f3af55abd102715560cecbbddae (patch)
tree08976463978c063746324d732b7cec3d36b16983 /mysql-test
parentfca44b7c1ffe5e32a94e8d4449bd1d9f91492c3a (diff)
downloadmariadb-git-a79183b01e4e1f3af55abd102715560cecbbddae.tar.gz
correct table name in CHECK failures during ALTER TABLE
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/partition_alter.result4
-rw-r--r--mysql-test/t/partition_alter.test2
2 files changed, 2 insertions, 4 deletions
diff --git a/mysql-test/r/partition_alter.result b/mysql-test/r/partition_alter.result
index 6aa0039c8d2..d272381bc08 100644
--- a/mysql-test/r/partition_alter.result
+++ b/mysql-test/r/partition_alter.result
@@ -59,7 +59,7 @@ partition p2 values less than ('2020-10-19'));
insert t1 values (0, '2000-01-02', 0);
insert t1 values (1, '2020-01-02', 10);
alter table t1 add check (b in (0, 1));
-ERROR 23000: CONSTRAINT `CONSTRAINT_1` failed for `test`.`#sql-temporary`
+ERROR 23000: CONSTRAINT `CONSTRAINT_1` failed for `test`.`t1`
alter table t1 add check (b in (0, 10));
show create table t1;
Table Create Table
@@ -83,7 +83,7 @@ partition p2 values less than ('2020-10-19'));
insert t1 values (0, '2000-01-02', 0);
insert t1 values (1, '2020-01-02', 10);
alter table t1 add check (b in (0, 1));
-ERROR 23000: CONSTRAINT `CONSTRAINT_1` failed for `test`.`#sql-temporary`
+ERROR 23000: CONSTRAINT `CONSTRAINT_1` failed for `test`.`t1`
alter table t1 add check (b in (0, 10));
show create table t1;
Table Create Table
diff --git a/mysql-test/t/partition_alter.test b/mysql-test/t/partition_alter.test
index ce6672c4b9d..1235e5b8dc2 100644
--- a/mysql-test/t/partition_alter.test
+++ b/mysql-test/t/partition_alter.test
@@ -79,7 +79,6 @@ partition p1 values less than ('2016-10-18'),
partition p2 values less than ('2020-10-19'));
insert t1 values (0, '2000-01-02', 0);
insert t1 values (1, '2020-01-02', 10);
---replace_regex /#sql-[0-9a-f_]*/#sql-temporary/
--error ER_CONSTRAINT_FAILED
alter table t1 add check (b in (0, 1));
alter table t1 add check (b in (0, 10));
@@ -96,7 +95,6 @@ partition p1 values less than ('2016-10-18'),
partition p2 values less than ('2020-10-19'));
insert t1 values (0, '2000-01-02', 0);
insert t1 values (1, '2020-01-02', 10);
---replace_regex /#sql-[0-9a-f_]*/#sql-temporary/
--error ER_CONSTRAINT_FAILED
alter table t1 add check (b in (0, 1));
alter table t1 add check (b in (0, 10));