From: | Markus Wiederkehr <wmax(at)sbox(dot)tu-graz(dot)ac(dot)at> |
---|---|
To: | pgsql-ports(at)postgresql(dot)org |
Subject: | Bug Report |
Date: | 1999-11-16 13:55:58 |
Message-ID: | 199911161355.OAA05538@fstgss05.tu-graz.ac.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ports |
Hello!
I've found a small bug (??) in PostgreSQL 6.5.3:
[PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]
SELECT SUM(1) FROM <table> WHERE <false-condition>;
I wanted to use this query to count the number of rows in a table that meet
the specified condition. Postgres crashes, if the number of rows is zero.
> table=> SELECT SUM(1) FROM nodes WHERE node_id = 172;
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> We have lost the connection to the backend, so further processing is
> impossible. Terminating.
--
Markus Wiederkehr
mailto:wmax(at)sbox(dot)tu-graz(dot)ac(dot)at
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff MacDonald | 1999-11-16 17:30:19 | MIPS |
Previous Message | Goda Attila | 1999-11-16 09:51:12 | NT Socket problem |