I'll test in 2.5.1 and file a bug report.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean
Sent: Friday, May 25, 2012 1:04 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Left join and computed columns - Email
found in subject

Rick,

> A query with a left join to a table with a computed column returned
> values in the computed column even though the row didn't exist in the
> table. All other non-computed values came back as null, which was to

be expected.

> Is this a bug, or correct by SQL specifications?

I don't have a copy of SQL standard or the required decoder ring to make
sense of it.

My initial thinking was that was as expected, but in thinking further...

If no row in the LEFT table exists, then all columns for the row should
be NULL, so this would be a bug.


Sean