Repository navigation
Unexpected modify column cause data-index inconsistency #61668
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
CREATE TABLE `t` (
`col6bf3` double NOT NULL DEFAULT '1.7493807071127492',
`col7044` varchar(145) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'xdwzi7tpmjwxeklahyxvg3gl0mt2x08mdhxz9pbdsdnrvj8qghrckfzat38jkukpycmtwsl3n8nnw9m5hgavfeu8nnhf8e5c7yttr8',
`col397e` date DEFAULT '6275-04-28',
`colecb5` text DEFAULT NULL,
`col2611` float DEFAULT '1.6870946',
PRIMARY KEY (`col6bf3`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='4a6d1ec3'
DO DDL concurrently:
DDL1:
ALTER TABLE t ADD INDEX idx (col7044)
DDL2:
ALTER TABLE `t` modify column `col7044` VARCHAR(206) NULL DEFAULT 'emtlqampngugbkxqy' FIRST
Make DDL1 execute first.
2. What did you expect to see? (Required)
The second DDL should fail
3. What did you see instead (Required)
Both of the DDLs are successful.
4. What is your TiDB version? (Required)
master
Activity
ddl: double check collation compatibility before modifying column (#6…
ddl: double check collation compatibility before modifying column (#6…