| Lists: | pgsql-bugs |
|---|
| From: | "Mikael Omma" <mikael(dot)omma(at)ge(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4090: ECPG Selecting table with NULL values |
| Date: | 2008-04-04 12:32:44 |
| Message-ID: | 200804041232.m34CWiI3004947@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4090
Logged by: Mikael Omma
Email address: mikael(dot)omma(at)ge(dot)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.
| From: | Michael Meskes <meskes(at)postgresql(dot)org> |
|---|---|
| To: | Mikael Omma <mikael(dot)omma(at)ge(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4090: ECPG Selecting table with NULL values |
| Date: | 2008-04-06 14:29:05 |
| Message-ID: | 20080406142905.GA26661@feivel.credativ.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
> 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(at)jabber(dot)org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!
| From: | Michael Meskes <meskes(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4090: ECPG Selecting table with NULL values |
| Date: | 2008-04-10 14:41:36 |
| Message-ID: | 20080410144136.GA15491@feivel.credativ.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
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(dot)omma(at)ge(dot)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(at)jabber(dot)org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!