Missing null fields in query result

Missing null fields in query result

Postby ez » Thu 05 Mar 2015 09:59


Queries containing constant fields in the select clause do not return fields if the constant is NULL. All NULL fields are stripped from the result set.

tbl is a table with several records

select null from tbl
select null, null from tbl
--> return nothing (no rows, no fields)

select 1, null from tbl
--> returns rows, but only 1 field containing the value 1

select 1, null, 2, null from tbl
--> returns only 2 fields containing 1 and 2

Delphi 7
Oracle 11gR2, 12c
dbxoda (sql*net) 4.70, 6.3.6, 6.5.8
Posts: 11
Joined: Tue 01 Dec 2009 12:56

Re: Missing null fields in query result

Postby AlexP » Tue 10 Mar 2015 11:50


Thank you for the sample. We have reproduced the described case and will investigate the reason for such behavior. We will inform you as soon as we have any results.
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Return to dbExpress driver for Oracle