[MDEV-14832] CTE does not work with system versioning fields - Jira

CREATE OR REPLACE TABLE t1 (i INT) WITH SYSTEM VERSIONING;

WITH cte AS ( SELECT sys_trx_start FROM t1 ) SELECT * FROM cte;

# Cleanup

DROP TABLE t1;

MariaDB [test]> WITH cte AS ( SELECT sys_trx_start FROM t1 ) SELECT * FROM cte;

ERROR 1096 (HY000): No tables used

I assume it's specific to versioning and not to our implementation of hidden columns, because this works:

set statement debug_dbug= "+d,test_pseudo_invisible"

  for create or replace table t1 (a int);

with cte as ( select invisible from t1 ) select * from cte;

relates to

MDEV-14820 System versioning is applied incorrectly to CTEs

There are no comments yet on this issue.

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server