Details
Description
The following sql reproduces the issue. The create table is not really needed since it doesn't get that far. It crashes before it knows whether the table exists. It seems that it works ok if the last cte is used as the main query instead. So it has something to do with one cte having two references to the previous cte and the previous cte selecting from a table with the same name as itself.
create or replace table t (id int primary key) |
as select seq as id from seq_1_to_10; |
|
|
with t as ( |
select * from t |
), crash as ( |
select t1.id t1id, t2.id t2id |
from t t1 |
cross join t t2 |
)
|
select * from crash; |
When it crashes there are no messages in the error log, the server just dies.