Subject Re: [firebird-support] const field in result set
Author Martijn Tonies

> im using Firebird (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

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

Database questions? Check the forum: