Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5
-
None
Description
install soname 'ha_rocksdb'; |
create table t1 (pk int, a int, s date, e date, period for se(s,e), primary key(pk, se without overlaps)) engine=RocksDB; |
insert into t1 values |
(1, 10, DATE '2001-07-27', DATE '2004-07-27'), |
(1, 10, DATE '2004-07-27', DATE '2006-07-27'); |
UPDATE t1 SET a = 10 WHERE pk = 1; |
10.5 5193c1b5 |
mysqltest: At line 6: query 'UPDATE t1 SET a = 10 WHERE pk = 1' failed: 4025: CONSTRAINT `se` failed for `test`.`t1` |
The same UPDATE works all right on InnoDB, MyISAM and Aria tables.