As soon as i add the ROWS clause to a CTE FB cannot use indices available in
the CTEs tables.
Is this a bug, or as designed?
This:
with low as (
select igc.issue_id, ia.occasion
from issues_groups igc
left join issues_groups igb on (igb.issue_significant_id =
Did you have a setup (version of FB and ICU) that passes these tests? I do not
use CI so i have not suffered from the potential disasters you point put above.
IMHO looks like bugs.
HTH,
/D
I am using FB3.0.2 with swedish collation, but with the unicode libs that
worked with FB2.5. I have not had the time to research the use of newer
versions of these libraries. This is what i do:
Put the icudt44.dll, icuin44.dll and icuuc44.dll lib files in Firebird_3_0
(might have typos here,