diff options
| author | sachinsetia1001@gmail.com <sachinsetia1001@gmail.com> | 2019-03-12 15:01:41 +0530 |
|---|---|---|
| committer | sachinsetia1001@gmail.com <sachinsetia1001@gmail.com> | 2019-03-17 13:51:46 +0530 |
| commit | 3943fe5630f276e30602def223f0661d442e1142 (patch) | |
| tree | 50c7d010189576ccb5629e5fb7d9b78ab8113cb9 /mysql-test/main/long_unique_bugs.test | |
| parent | 8995f33c0b5ee06eee47535f3c254416d4ab05a3 (diff) | |
| download | mariadb-git-3943fe5630f276e30602def223f0661d442e1142.tar.gz | |
MDEV-18888 Server crashes in Item_field::register_field_in_read_map upon...
MODIFY COLUMN
Do Not create prefix field for long unique key
Diffstat (limited to 'mysql-test/main/long_unique_bugs.test')
| -rw-r--r-- | mysql-test/main/long_unique_bugs.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/main/long_unique_bugs.test b/mysql-test/main/long_unique_bugs.test index 7ae6401ccba..6257111b3fb 100644 --- a/mysql-test/main/long_unique_bugs.test +++ b/mysql-test/main/long_unique_bugs.test @@ -196,3 +196,22 @@ insert into t1(a,b) values(2,2); insert into t1(a,b) values(2,3); insert into t1(a,b) values(3,2); drop table t1; + +# +# MDEV-18888 Server crashes in Item_field::register_field_in_read_map upon MODIFY COLUMN +# +CREATE TABLE t1 ( + a CHAR(128), + b CHAR(128) AS (a), + c DATETIME, + UNIQUE(c,b(64)) +) ENGINE=InnoDB; +ALTER TABLE t1 MODIFY COLUMN c VARCHAR(4096); +drop table t1; +CREATE TABLE t1 ( + a CHAR(128), + b CHAR(128) AS (a), + c varchar(5000), + UNIQUE(c,b(64)) +) ENGINE=InnoDB; +drop table t1; |