BUG #4090: ECPG Selecting table with NULL values

In ECPG when I have "$select a into :a from table where b = :b;" this query
raises an error if the value a is NULL.
If I have added the indicator value "$select a int :a, :a_ind from table
where b = :b;" this also raises the same error. I cannot read rows including
null values without raising this error. From the documentation the
indicator value should prevent raising this error but it is not.

I compile with INFORMIX compablity mode from ESQL sourcecode ported to
PostgreSQL.

Could you send us a test case? Does it work when not using INFORMIX
mode? Do you use the "-r no_indicator" option?

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!

On Fri, Apr 04, 2008 at 12:32:44PM +0000, Mikael Omma wrote:

The following bug has been logged online:

Bug reference: 4090
Logged by: Mikael Omma
Email address: mikael.omma@ge.com
PostgreSQL version: 8.2.6
Operating system: SUSE Linux 10
Description: ECPG Selecting table with NULL values
...

This proofed to be a typo in the test case. Bug solved.

Michael

--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!