[MDEV-18922] Alter on long unique varchar column makes result null - Jira

XML

Word

Printable

#MDEV-18922 Alter on long unique varchar column makes result null

CREATE TABLE t1 (b int, a  varchar(4000));

INSERT INTO t1 VALUES (1, 2),(2,3),(3,4);

ALTER TABLE t1 ADD UNIQUE INDEX (a);

SELECT * FROM t1;

SELECT a FROM t1;

drop table t1;

Result

CREATE TABLE t1 (b int, a  varchar(4000));

INSERT INTO t1 VALUES (1, 2),(2,3),(3,4);

ALTER TABLE t1 ADD UNIQUE INDEX (a);

SELECT * FROM t1;

b       a

1       2

2       3

3       4

SELECT a FROM t1;

NULL

NULL

NULL

drop table t1;

causes

MDEV-18941 HEAP index is no longer used

is caused by

MDEV-371 Unique indexes for blobs

is part of

MDEV-18901 Wrong results after ADD UNIQUE INDEX(blob_column)

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.