|
--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.
|