[MDEV-9251] Fix MySQL Bug#20755615 - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5(EOL), 10.0(EOL), 10.1(EOL)
Fix Version/s: 5.5.48, 10.0.23, 10.1.10
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
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;

Attachments

Issue Links

links to

upstream fix

Activity

Jan Lindström (Inactive) added a comment - 2015-12-11 14:36

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.

Jan Lindström (Inactive) added a comment - 2015-12-11 14:36 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.

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Sergei Golubchik

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2015-12-09 11:36

Updated:: 2015-12-11 15:34

Resolved:: 2015-12-11 14:36

Git Integration

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

MariaDB Server