Skip to content

Concurrent Column Type Change would cause inconsistent schema and data #31048

Closed
@wjhuang2016

Description

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table test(a int, b int);
insert into test values (1, 1);
alter table test change column b b double; /* in session 1 */
alter table test change column b b double; /* in session 2 */
select * from test;

2. What did you expect to see? (Required)

No error

3. What did you see instead (Required)

mysql> select * from test;
ERROR 1105 (HY000): insufficient bytes to decode value

4. What is your TiDB version? (Required)

5.1 5.2 5.3 master

Metadata

Assignees

Labels

affects-5.1This bug affects 5.1.x versions.affects-5.2This bug affects 5.2.x versions.affects-5.3This bug affects 5.3.x versions.severity/criticalsig/sql-infraSIG: SQL Infratype/bugThe issue is confirmed as a bug.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions