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