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
with recursive
b as (
select 0 rc
from rdb$database qa
union all
select b\.rc\+1
from b
join rdb$database q1 on q1\.rdb$relation\_id\*0=b\.rc\*0
join rdb$database q2 on q2\.rdb$relation\_id\*0=b\.rc\*0
where b\.rc=0
)
select * from b
Result: "Column does not belong to referenced table." (seems that it is 'b.rc' column that is source of trouble).
Same query in LI-V6.3.3.26744 Firebird 2.5 runs OK and return two rows (0 and 1).
The problem disappears if second join: "join rdb$database q2 on q2.rdb$relation_id*0=b.rc*0" - is commented out.
The text was updated successfully, but these errors were encountered:
Submitted by: @pavel-zotov
Is related to QA593
LI-T6.3.0.30889 Firebird 3.0 Alpha 2
with recursive
b as (
select 0 rc
from rdb$database qa
)
select * from b
Result: "Column does not belong to referenced table." (seems that it is 'b.rc' column that is source of trouble).
Same query in LI-V6.3.3.26744 Firebird 2.5 runs OK and return two rows (0 and 1).
The problem disappears if second join: "join rdb$database q2 on q2.rdb$relation_id*0=b.rc*0" - is commented out.
The text was updated successfully, but these errors were encountered: