You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 = http://t.ID
Submitted by: Firebird admin _ RxStrategies Inc (rxstrategies)
Relate to CORE4201
Is related to QA520
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 = http://t.ID
COMPUTED_COL
------------
FAILED
Commits: 93eb387 bfcd129 FirebirdSQL/fbt-repository@b555379 FirebirdSQL/fbt-repository@3bba0c3
The text was updated successfully, but these errors were encountered: