Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL)
Description
If add for engine=connect "system versioning" there is no any warnings/errors on creating table and inserting data, but "select" gives an empty result, "update" doesn't change value and "delete" fails with error:
Test:
create table t2 (
|
x int,
|
y int
|
) engine=connect table_type=FIX file_name='test.txt' with system versioning;
|
|
insert into t2 values (1,1),(2,2),(3,3),(4,4),(5,5);
|
select * from t2;
|
|
update t2 set x=10 where y=4;
|
select * from t2;
|
delete from t2 where x=1;
|
select * from t2;
|
|
drop table t2;
|
Result:
create table t2 (
|
x int,
|
y int
|
) engine=connect table_type=FIX file_name='/test.txt' with system versioning;
|
insert into t2 values (1,1),(2,2),(3,3),(4,4),(5,5);
|
select * from t2;
|
x y
|
update t2 set x=10 where y=4;
|
select * from t2;
|
x y
|
delete from t2 where x=1;
|
|
mysqltest: At line 11: query 'delete from t2 where x=1' failed: ER_CRASHED_ON_USAGE (1194): Table 't2' is marked as crashed and should be repaired
|
Attachments
Issue Links
- relates to
-
MDEV-15968 System versioning and CONNECT engine don't work well together: current data is not returned
- Confirmed
-
MDEV-17554 Auto-create history partitions for system-versioned tables
- Closed