Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.3, 10.4
-
None
Description
--source include/have_partition.inc
|
|
CREATE TABLE t1 (b BINARY GENERATED ALWAYS AS ('') VIRTUAL) PARTITION BY KEY(b) PARTITIONS 2; |
INSERT INTO t1 () VALUES (); |
FLUSH TABLES;
|
SET SQL_MODE= CONCAT(@@sql_mode,',EMPTY_STRING_IS_NULL'); |
CHECK TABLE t1; |
|
# Cleanup
|
DROP TABLE t1; |
10.3 d72038a7 |
CHECK TABLE t1; |
Table Op Msg_type Msg_text |
test.t1 check error Found a misplaced row |
test.t1 check error Partition p1 returned error |
test.t1 check error Upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it! |
Reproducible with at least MyISAM and InnoDB on 10.3-10.5.
The test case is not applicable to 10.2 due to the sql mode.