[#CORE-1724] Common table expressions cannot be used in computed columns and quantified predicates (IN / ANY / ALL)

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: 18/Nov/08 01:39 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

Time Tracking:

Not Specified

Planning Status:

Unspecified

Description

« Hide

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

All

Comments

Work Log

Change History

Version Control

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

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.

[ Permalink | « Hide ]

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)

?

[ Permalink | « Hide ]

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 :-)