fb server die when carry out the LEFT + INNER JOIN
--------------------------------------------------
Key: CORE-3798
URL: http://tracker.firebirdsql.org/browse/CORE-3798
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Alpha 1
Environment: Windows 7 32 bit, IBExpert
Reporter: Simonov Denis
CREATE TABLE TABLE1 (
ID INTEGER NOT NULL,
NAME VARCHAR(30),
ID_BREED INTEGER
);
ALTER TABLE TABLE1 ADD CONSTRAINT PK_TABLE1 PRIMARY KEY (ID);
CREATE TABLE TABLE2 (
ID INTEGER NOT NULL,
ID_TABLE1 INTEGER
);
ALTER TABLE TABLE2 ADD CONSTRAINT PK_TABLE2 PRIMARY KEY (ID);
CREATE TABLE TABLE3 (
ID INTEGER NOT NULL,
ID_BREED INTEGER
);
ALTER TABLE TABLE3 ADD CONSTRAINT PK_TABLE3 PRIMARY KEY (ID);
When execute or prepare this query fb server die
SELECT TABLE2.ID
FROM TABLE2
LEFT JOIN TABLE1 ON TABLE1.ID = TABLE2.ID_TABLE1
INNER JOIN TABLE3 ON TABLE1.ID_BREED = TABLE3.ID_BREED
WHERE TABLE1.ID = :ID
--
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
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
