Missing null fields in query result

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
Posts: 11
Joined: Tue 01 Dec 2009 12:56

Missing null fields in query result

Post by 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

Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Missing null fields in query result

Post by 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.

Post Reply