Issue Details (XML | Word | Printable)

Key: CORE-3874
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Firebird admin @ RxStrategies Inc
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Computed column appears in non-existant rows of left join

Created: 22/Jun/12 12:52 PM   Updated: 13/Jul/15 04:24 AM
Component/s: Engine
Affects Version/s: 2.5.0, 2.5.1, 2.5.2, 2.5.2 Update 1
Fix Version/s: 3.0 Alpha 1, 2.5.3

Environment: RedHat, Suse, and CentOS
Issue Links:
Relate

QA Status: Done successfully


 Description  « Hide
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


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 03/Jul/13 06:33 AM
Backported into v2.5.3.