ydb/yql/essentials/tests/sql/suites/seq_mode/shared_subquery_expr.sql

pragma SeqMode;
$a = select 1;
select * from $a;
select * from $a;