Hi,

> im using Firebird 2.1.3.18185 (win32)
>
> i have a view (call it View1) like that:
>
> select field1, field2, 1 constField3
> from ...
>
> runs ok, 3rd field is always 1, but becouse of the data contained now in
> the database, it returns no rows: [NULL, NULL, NULL] on ibexpert

No rows is not "null, null, null". IBExpert is wrong.

> thats ok :)
>
> i made and other wiew,
>
>
> select a.[something], v.constField3
> from TableWithRows t
> left outer join View1 v on ...
>
> since View1 is an empty recordset, i was supposing to get a null COLUMN
> for v.constField3, but its =1 for any row.

I can confirm this, other columns from "v" do return NULL though.

> hope some one can understand my spaghetti english, im missing something or
> its a bug? and after all, is there a workaround to have the desidered null
> column value?
>

I think this might be considered a bug.


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com