Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3(EOL)
-
10.3.6-1
Description
--source include/have_partition.inc
|
|
CREATE TABLE t1 (i INT) ENGINE=MyISAM; |
INSERT IGNORE INTO t1 VALUES (1),(2); |
|
CREATE TABLE t2 (f INT) ENGINE=MyISAM |
PARTITION BY RANGE(f) ( |
PARTITION p1 VALUES LESS THAN (128), |
PARTITION p2 VALUES LESS THAN MAXVALUE |
);
|
REPLACE INTO t2 VALUES (1),(2); |
|
UPDATE t1, t2 SET f = 126 ORDER BY f LIMIT 2; |
|
# Cleanup
|
DROP TABLE t1, t2; |
MariaDB [test]> UPDATE t1, t2 SET f = 126 ORDER BY f LIMIT 2; |
ERROR 1032 (HY000): Can't find record in 't2' |
Attachments
Issue Links
- includes
-
MDEV-21112 Can't find record when using LIMIT 1 with multiple joins
- Closed
- relates to
-
MDEV-14847 Assertion `(buff[7] & 7) == HEAD_PAGE' failed in _ma_read_block_record
- Closed
-
MDEV-13911 Support ORDER BY and LIMIT in multi-table update
- Closed
-
MDEV-17573 Assertion in federatedx on multi-update
- Closed
-
MDEV-20515 multi-update tries to position updated table by null reference
- Closed