Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Description
A statement
ALTER TABLE t1 CHANGE COLUMN b x varchar(30)
used to drop column's statistics in Engine-Independent Table Statistics.
In current 10.0-monty, the EITS entry is not dropped, which causes a failure in mysql-test/t/statistics.test which looks like this:
CURRENT_TEST: main.statistics mysqltest: At line 280: query 'LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/save_column_stats' INTO TABLE mysql.column_stats FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'' failed: 1062: Duplicate entry 'test-t1-b' for key 'PRIMARY'
I guess, ALTER TABLE code merge went wrong somewhere.
Gliffy Diagrams
Attachments
Issue Links
- is part of
-
MDEV-3932 5.6 merge
-
- Closed
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
