Re: [firebird-support] Plan problem en CTE

2019-12-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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

2019-12-30 Thread Germán Balbi bal...@yahoo.com [firebird-support]
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