[MDEV-4758] 10.0-monty tree: ALTER TABLE CHANGE COLUMN doesn't drop EITS stats Created: 2013-07-04  Updated: 2013-07-09  Resolved: 2013-07-09

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Sergei Petrunia Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-3932 5.6 merge Closed

 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.


Generated at Thu Feb 08 06:58:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.