quack.sql

quack.sql

with test(round) as (
    select 0
    union all
    select round+1 from test where round <= 20
)

select round
from
    -- delete the subselect line and it gives the expected error
    -- "Error: near line 1: Catalog Error: Table with name handshake does not exist!"
    (select round from test limit 1) as subselect, 
    test;