Plan returned for query with recursive CTE return wrong count of parenthesis
----------------------------------------------------------------------------
Key: CORE-3614
URL: http://tracker.firebirdsql.org/browse/CORE-3614
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.1.4, 2.1.5
Reporter: Karol Bieniaszewski
Priority: Minor
####################### metadata ###############################
CREATE TABLE TEST_TREE
(
ID INTEGER NOT NULL,
ID_HEADER INTEGER,
CONSTRAINT PK_TEST_TREE__ID PRIMARY KEY (ID)
);
CREATE INDEX IXA_TEST_TREE__ID_HEADER ON TEST_TREE (ID_HEADER);
####################### test data ###############################
INSERT INTO TEST_TREE (ID, ID_HEADER) VALUES ('1', NULL);
INSERT INTO TEST_TREE (ID, ID_HEADER) VALUES ('2', NULL);
INSERT INTO TEST_TREE (ID, ID_HEADER) VALUES ('3', NULL);
INSERT INTO TEST_TREE (ID, ID_HEADER) VALUES ('4', '1');
INSERT INTO TEST_TREE (ID, ID_HEADER) VALUES ('5', '4');
INSERT INTO TEST_TREE (ID, ID_HEADER) VALUES ('6', '2');
####################### test query ###############################
WITH RECURSIVE
R_TREE AS
(
SELECT TT.ID AS A, CAST(TT.ID AS VARCHAR(100)) AS ASUM
FROM TEST_TREE TT
WHERE TT.ID_HEADER IS NULL
UNION ALL
SELECT TT.ID AS A, RT.ASUM || '_' || TT.ID
FROM TEST_TREE TT JOIN R_TREE RT ON RT.A = TT.ID_HEADER
)
SELECT
*
FROM
R_TREE RT2 INNER JOIN TEST_TREE TT2 ON TT2.ID=RT2.A
####################### plan returned b y engine ###############################
PLAN JOIN ((R_TREE TT INDEX (IXA_TEST_TREE__ID_HEADER))
PLAN (R_TREE TT INDEX (IXA_TEST_TREE__ID_HEADER)), TT2 INDEX (PK_TEST_TREE__ID))
as you can see count of opening parenthesis are not equal to count of closing
parenthesis
--
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
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
