summaryrefslogtreecommitdiff
path: root/mysql-test/main/long_unique_bugs.result
diff options
context:
space:
mode:
authorsachinsetia1001@gmail.com <sachinsetia1001@gmail.com>2019-03-12 15:01:41 +0530
committersachinsetia1001@gmail.com <sachinsetia1001@gmail.com>2019-03-17 13:51:46 +0530
commit3943fe5630f276e30602def223f0661d442e1142 (patch)
tree50c7d010189576ccb5629e5fb7d9b78ab8113cb9 /mysql-test/main/long_unique_bugs.result
parent8995f33c0b5ee06eee47535f3c254416d4ab05a3 (diff)
downloadmariadb-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.result')
-rw-r--r--mysql-test/main/long_unique_bugs.result15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/main/long_unique_bugs.result b/mysql-test/main/long_unique_bugs.result
index 4ac056d8591..b3a1076804b 100644
--- a/mysql-test/main/long_unique_bugs.result
+++ b/mysql-test/main/long_unique_bugs.result
@@ -171,3 +171,18 @@ 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;
+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;