[MDEV-19985] Test system versioning against UDFs and nested selects Created: 2019-07-08  Updated: 2019-07-08

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Nikita Malyavin Assignee: Aleksey Midenkov
Resolution: Unresolved Votes: 0
Labels: None


 Description   

The purpose of the task is to add tests with expressions that can transform, say, during optimization.

Good example to start:

create or replace table t (x int) with system versioning engine=myisam;
 
insert into t values(1);
 
select * from t for system_time as of (select row_start from t where x in (select x from t));

The syntax is currently allowed. ... IN (SELECT ...) can be transformed to join.
There is also string constants which transforming and single select like (SELECT 1).

 Comments   
Comment by Oleksandr Byelkin [ 2019-07-08 ]

it would be nice to check IN on the top level something like
select * from t for system_time as of (x in (select x from t));
the query is stupid, but it is corner case which better to check.
or test select * from t for system_time as of (select 1)); which also transform.
Transformation can be checked by explain extended (in warnings).

Generated at Thu Feb 08 08:55:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.