[MDEV-9251] Fix MySQL Bug#20755615 Created: 2015-12-09  Updated: 2015-12-11  Resolved: 2015-12-11

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Affects Version/s: 5.5, 10.0, 10.1
Fix Version/s: 5.5.48, 10.0.23, 10.1.10

Type: Bug Priority: Major
Reporter: Sergei Golubchik Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

InnoDB compares column names case sensitively, while according to Storage Engine API column names should be compared case insensitively. This can cause FRM and InnoDB data dictionary to go out of sync:

CREATE TABLE t1 (D INT) ENGINE=innodb;
 
INSERT INTO t1 VALUES (10);
 
ALTER TABLE t1 MODIFY COLUMN d INT;
 
ALTER TABLE t1 ADD INDEX (d);
 
DROP TABLE t1;



 Comments   
Comment by Jan Lindström (Inactive) [ 2015-12-11 ]

commit c19972fc8708778bd6070715b449351a39edb0cc
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Fri Dec 11 14:33:41 2015 +0200

MDEV-9251: Fix MySQL Bug#20755615: InnoDB compares column names case sensitively,
while according to Storage Engine API column names should be compared
case insensitively. This can cause FRM and InnoDB data dictionary to
go out of sync.

Generated at Thu Feb 08 07:33:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.