diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2018-05-08 14:14:36 +0300 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2018-06-30 16:12:45 +0200 |
| commit | 7c0779da7c37f6ef6eff2f79dda6f1b0c57e3869 (patch) | |
| tree | cf553afeb451ad6a49fee4cb262ea8362c9f0e85 /mysql-test/main/partition_alter.result | |
| parent | b5184c7efbe817be07de886b0e8bf61432f22f69 (diff) | |
| download | mariadb-git-7c0779da7c37f6ef6eff2f79dda6f1b0c57e3869.tar.gz | |
MDEV-16102 Wrong ER_DUP_ENTRY upon ADD UNIQUE KEY on versioned table
* ignore CHECK constraint for historical rows;
* FOREIGN KEY test case.
TODO:
MDEV-16301 IB: use real table name for error messages on ALTER
Closes tempesta-tech/mariadb#491
Closes #748
Diffstat (limited to 'mysql-test/main/partition_alter.result')
| -rw-r--r-- | mysql-test/main/partition_alter.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/partition_alter.result b/mysql-test/main/partition_alter.result index 448c26c7919..ca6359f94de 100644 --- a/mysql-test/main/partition_alter.result +++ b/mysql-test/main/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 @@ -84,7 +84,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 |