Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.4.3
-
None
-
All
Description
CREATE TABLE t1 (data VARCHAR(4), unique(data) using hash) with system versioning; |
|
INSERT INTO t1 VALUES ('A'),('B'); |
SELECT * INTO OUTFILE 'load.data' from t1; |
|
select * from t1; |
LOAD DATA INFILE 'load.data' INTO TABLE t1; |
select * from t1; |
DROP TABLE t1; |
--let $datadir= `select @@datadir`
|
--remove_file $datadir/test/load.data
|
|
CREATE TABLE t1 (data VARCHAR(4), unique(data) using hash) with system versioning; |
INSERT INTO t1 VALUES ('A'),('B'); |
SELECT * INTO OUTFILE 'load.data' from t1; |
select * from t1; |
data
|
A
|
B
|
LOAD DATA INFILE 'load.data' INTO TABLE t1; |
select * from t1; |
data
|
A
|
B
|
A
|
B
|
DROP TABLE t1; |
main.abc [ pass ] 12
|
|
Attachments
Issue Links
- causes
-
MDEV-18901 Wrong results after ADD UNIQUE INDEX(blob_column)
- Closed
- is caused by
-
MDEV-371 Unique indexes for blobs
- Closed
- is duplicated by
-
MDEV-18910 Hash value unique long column is miscalculated from versioning timestamp
- Closed