parsing error recursive query with two recursive parts [CORE2943] #3325
Labels
affect-version: 2.1.0
affect-version: 2.1.1
affect-version: 2.1.2
affect-version: 2.1.3
affect-version: 2.5 Alpha 1
affect-version: 2.5 Beta 1
affect-version: 2.5 Beta 2
affect-version: 2.5 RC1
affect-version: 2.5 RC2
component: engine
fix-version: 2.1.4
fix-version: 2.5 RC3
fix-version: 3.0 Alpha 1
priority: major
qa: done successfully
type: bug
Submitted by: Alex Bekhtin (afgm)
Is related to QA277
-- correct
with recursive
tree (NAME) as (
select r.rdb$relation_name from rdb$relations r
union all
select r2.rdb$relation_name || http://tree.NAME from rdb$relations r2, tree
where 1 = 0
)
select * from tree
-- incrorrect
with recursive
tree (NAME) as (
select r.rdb$relation_name from rdb$relations r
union all
select r2.rdb$relation_name || http://tree.NAME from rdb$relations r2, tree
where 1 = 0
),
tree_2 as (
select c.rdb$character_set_name from rdb$character_sets c
union all
select c2.rdb$character_set_name from rdb$character_sets c2, tree_2
where 1 = 0
)
select * from tree, tree_2
-------------
Dynamic SQL Error.
SQL error code = -206.
Column unknown.
http://TREE.NAME.
At line 5, column 43.
Commits: 25c5d1a 8dc2601 6d9f5e2
The text was updated successfully, but these errors were encountered: