System versioning doesn't support correct work for engine=connect and doesn't always give any warnings/errors

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;

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