Subject RE: [firebird-support] Left join and computed columns
Author Leyne, Sean
Rick,

> It happens in 2.5.1. How do I file a bug report?
>
> 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

There is nothing wrong with the results, as far as I can tell.

What do you think should be the expected result?


Sean