|
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;
|
|