Regression in parsing of CTE when select from its last (final) part and use
alias for it that matching to one of previously defined parts
-----------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-4703
URL: http://tracker.firebirdsql.org/browse/CORE-4703
Project: Firebird Core
Issue Type: Bug
Reporter: Pavel Zotov
SQL> show version;
ISQL Version: WI-T3.0.0.31690 Firebird 3.0 Beta 2
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.31690 Firebird
3.0 Beta 2"
Firebird/Windows/Intel/i386 (remote server), version "WI-T3.0.0.31690 Firebird
3.0 Beta 2/tcp (csprog)/P13"
Firebird/Windows/Intel/i386 (remote interface), version "WI-T3.0.0.31690
Firebird 3.0 Beta 2/tcp (csprog)/P13"
on disk structure version 12.0
SQL> with
CON> x as(
CON> select 1 i from rdb$database
CON> )
CON> ,y as(
CON> select i from x
CON> )
CON> select * from y
CON> as x -- <<<<<<<<<<<<<<<<<<< NB: `x` is also used for 1st part of this CTE,
but it CAN be placed here because it is finish of all query
CON> ;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-CTE 'X' has cyclic dependencies
No such error on WI-V2.5.4.26842.
There are also no errors in similar queries on MS SQL and Postgress.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
