diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2020-05-29 11:57:59 +0300 |
|---|---|---|
| committer | Aleksey Midenkov <midenok@gmail.com> | 2020-05-29 11:57:59 +0300 |
| commit | f76a1df003da415955375172ed8e510249f8c048 (patch) | |
| tree | a29353c607664928b00ce9251e78ff65f9a21132 /mysql-test/suite/innodb | |
| parent | cdc2508ed1a5488f3b20fae7ee8a72b4275a65b6 (diff) | |
| download | mariadb-git-f76a1df003da415955375172ed8e510249f8c048.tar.gz | |
MDEV-21127 Assertion failed in key_text::key_text
Wrong condition for corner values.
Diffstat (limited to 'mysql-test/suite/innodb')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb-fk.result | 7 | ||||
| -rw-r--r-- | mysql-test/suite/innodb/t/innodb-fk.test | 8 |
2 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-fk.result b/mysql-test/suite/innodb/r/innodb-fk.result index b6e164a33f0..d3c1aa77eaf 100644 --- a/mysql-test/suite/innodb/r/innodb-fk.result +++ b/mysql-test/suite/innodb/r/innodb-fk.result @@ -199,3 +199,10 @@ b char(255), FOREIGN KEY ( a012345678901234567890123456789012345678901, b ) REFERENCES tx (ax, bx) ) ENGINE=InnoDB; ERROR HY000: Can't create table `test`.`t1` (errno: 150 "Foreign key constraint is incorrectly formed") +CREATE TABLE t1 ( +a012345678901234567 int, +b int, +c0123456789012345678 int, +FOREIGN KEY (a012345678901234567,c0123456789012345678,b) REFERENCES tx (x1,x2,x3) +) ENGINE=InnoDB; +ERROR HY000: Can't create table `test`.`t1` (errno: 150 "Foreign key constraint is incorrectly formed") diff --git a/mysql-test/suite/innodb/t/innodb-fk.test b/mysql-test/suite/innodb/t/innodb-fk.test index 4069e02d9b7..fcab4b22eb1 100644 --- a/mysql-test/suite/innodb/t/innodb-fk.test +++ b/mysql-test/suite/innodb/t/innodb-fk.test @@ -236,3 +236,11 @@ CREATE TABLE t1 ( b char(255), FOREIGN KEY ( a012345678901234567890123456789012345678901, b ) REFERENCES tx (ax, bx) ) ENGINE=InnoDB; + +--error ER_CANT_CREATE_TABLE +CREATE TABLE t1 ( + a012345678901234567 int, + b int, + c0123456789012345678 int, + FOREIGN KEY (a012345678901234567,c0123456789012345678,b) REFERENCES tx (x1,x2,x3) +) ENGINE=InnoDB; |