Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.1.33, 10.2.15, 10.3.7
-
None
-
IMHO not important (OpenSuSE 42.3)
Description
10.1 commit 31a19683f5289f08439b848da23a28f49ff0accc
– 10.1.33-MariaDB-debug
10.2 commit 87af52d7dd733e71fc7a9e39b882a4fd44f41fec
– 10.2.15-MariaDB-debug
10.3 commit 8fce4065e542ad64438d45f60421241dd383815f
– 10.3.7-MariaDB-debug
CREATE TABLE test . t1 ( c1 INT, c2 INT AS (c1) VIRTUAL ); |
INSERT INTO test . t1 (c1) VALUES(1); |
COMMIT ; |
ALTER TABLE test . t1 ENGINE = InnoDB PARTITION BY KEY(c2) PARTITIONS 4 ; |
SHOW CREATE TABLE t1; |
Table Create Table |
t1 CREATE TABLE `t1` ( |
`c1` int(11) DEFAULT NULL, |
`c2` int(11) AS (c1) VIRTUAL |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
/*!50100 PARTITION BY KEY (c2)
|
PARTITIONS 4 */
|
CHECK TABLE t1 EXTENDED; |
Table Op Msg_type Msg_text
|
test.t1 check error Found a misplaced row
|
test.t1 check error Partition p0 returned error
|
test.t1 check error Upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it!
|
The same test works well for c2 INT AS (c1) PERSISTENT.
Attachments
Issue Links
- is duplicated by
-
MDEV-15626 Assertion on update virtual column in partitioned table
- Closed