From: Pavel Z. (JIRA) <tr...@fi...> - 2015-03-03 15:28:17
|
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 |