Computed column appears in non-existant rows of left join
---------------------------------------------------------
Key: CORE-3874
URL: http://tracker.firebirdsql.org/browse/CORE-3874
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.1
Environment: RedHat, Suse, and CentOS
Reporter: Firebird admin @ RxStrategies Inc
I expect the following script would return a single row with a single column
containing NULL, since TEST_TABLE is not populated.
Instead the computed column is returned.
CREATE TABLE TEST_TABLE
(
ID INTEGER,
COMPUTED_COL VARCHAR(6) COMPUTED BY ('FAILED')
);
SELECT t.COMPUTED_COL
FROM RDB$DATABASE r
LEFT JOIN TEST_TABLE t
ON r.RDB$RELATION_ID = t.ID
COMPUTED_COL
------------
FAILED
--
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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
