Обсуждение: BUG #4090: ECPG Selecting table with NULL values
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 Details: 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.
> 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!