HiWhy "list(x.tbl2_pk_id)"?Result of list is a blob string with one single value like '1,2,3' not a 3 records '1', '2', '3'.And using "in" is not a good choice here. Change query to e.g. 'exists' or better some 'join'Regards,Karol Bieniaszewski null
RE: [firebird-support] Plan problem en CTE
liviuslivius [email protected] [firebird-support] Tue, 31 Dec 2019 02:15:23 -0800
- [firebird-supp... Germán Balbi [email protected] [firebird-support]
- Re: [fire... Dimitry Sibiryakov [email protected] [firebird-support]
- Re: [fire... Mark Rotteveel [email protected] [firebird-support]
- Re: [fire... setysvar [email protected] [firebird-support]
- RE: [fire... liviuslivius [email protected] [firebird-support]
