Issue Details (XML | Word | Printable)

Key: CORE-1724
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Dmitry Yemanov
Votes: 1
Watchers: 0

If you were logged in you would be able to see more operations.
Firebird Core

Common table expressions cannot be used in computed columns and quantified predicates (IN / ANY / ALL)

Created: 04/Feb/08 05:47 AM   Updated: 29/May/15 04:15 PM
Component/s: Engine
Affects Version/s: 2.1 Alpha 1, 2.1 Beta 1, 2.1 Beta 2, 2.1 RC1
Fix Version/s: 2.1 RC2, 2.5 Alpha 1

QA Status: Done successfully

 Description  « Hide
Parser rules column_select and column_singleton should be extended to allow the WITH [RECURSIVE] clause.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Jobin Augustine added a comment - 05/Feb/08 04:07 AM
i think This is a must have feature. CTE should work like a table always.
Thank you.

Vlad Khorsun added a comment - 05/Feb/08 12:01 PM
About usage of CTE in quantified predicates :

Why do you prefer

select ... from ... where ... in (with recursive ... select ... from cte)

but not

with recursive ...
select ... from ... where ... in (select ...from cte)


Dmitry Yemanov added a comment - 05/Feb/08 01:06 PM
As for me, I would just like to see CTEs syntactically and semantically consistent with other usage cases for select expressions :-)