You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Fix is committed into both v2.5 and v3 branches.
Note, test query fill fail in database with sql dialect 3 because of another bug CORE4144.
In database with sql dialect 1 query should run even before CORE4144 will be fixed.
Please test it and confirm, i can't verify correctness of results (while it is the same as at MSSQL 2008)
Submitted by: Frank Schlottmann-Goedde (fsg)
Votes: 1
with recursive
CTE_CNT1 as (select 0 as I
from RDB$DATABASE
union all select I + 1
from CTE_CNT1
where I < 9),
CTE_CNT2 as (select I, 0 as J
from CTE_CNT1
union all select J * 10 + c1.I, c2.J + 1
from CTE_CNT1 c1
join CTE_CNT2 c2 on c2.J < 10)
select I from CTE_CNT2;
fails with:
Statement failed, SQLSTATE = 42S22
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-C2.J
-At line 14, column 15
Commits: 0e9ff22 7f587ec FirebirdSQL/fbt-repository@9faf476 FirebirdSQL/fbt-repository@2125d51
The text was updated successfully, but these errors were encountered: