Re: [firebird-support] Plan problem en CTE
30.12.2019 17:57, Germán Balbi bal...@yahoo.com [firebird-support] wrote: > How can I specify the right plan? Your strange query cannot work at all. Natural scan is unavoidable with it. -- WBR, SD.
[firebird-support] Plan problem en CTE
Hi.I have this problem in FB 2.5 with x as (SELECT * FROM tbl_x1 JOIN tbl_fk1 ON cond_1 WHERE cond_w1UNIONSELECT * FROM tbl_x1 JOIN tbl_fk1 ON cond_2 WHERE cond_w2) select tbl_2.pk_id from tbl_2 where tbl_2.pk_id in (select list(x.tbl2_pk_id) from x The plan in the X table is OK, bu