From: | Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it> |
---|---|
To: | Vadim Mikheev <vadim(at)krs(dot)ru>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re[2]: [HACKERS] BUG ON HAVING CLAUSE |
Date: | 1998-12-04 13:36:19 |
Message-ID: | 1608.981204@bo.nettuno.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello Vadim,
venerdì, 4 dicembre 98, you wrote:
VM> Sferacarta Software wrote:
>>
>> Hi all,
>>
>> Seems that I found a bug on HAVING clause, see attached file.
>>
VM> Could you post me data for 8342 rows ?
I think this bug is not on HAVING but on IN/ANY/ALL, I tried all these
statements and no one returns right values.
I compared it with Informix, take a look at attachment.
BTW. Thomas said me that you know something about the following
problem:
SELECT esito1,esito2
FROM brogliacci
WHERE NOT esito1 IS NULL AND NOT esito2 IS NULL;
esito1|esito2
------+------
N |N
(1 row)
SELECT esito1,esito2
FROM brogliacci
WHERE NOT esito1 IS NULL OR NOT esito2 IS NULL;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally before or while pr
ocessing the request.
We have lost the connection to the backend, so further processing is impossible.
Terminating.
May you help me?
-Jose'-
Attachment | Content-Type | Size |
---|---|---|
all_any_in.err | application/octet-stream | 9.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Werges | 1998-12-04 14:35:51 | Re: [GENERAL] Perl DBD / DBI modules |
Previous Message | Vadim Mikheev | 1998-12-04 07:10:52 | Re: [HACKERS] Case statement ready? |