Skip site navigation (1) Skip section navigation (2)

Bug Report

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-ports

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

pgsql-ports by date

Next:From: Jeff MacDonaldDate: 1999-11-16 17:30:19
Subject: MIPS
Previous:From: Goda AttilaDate: 1999-11-16 09:51:12
Subject: NT Socket problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group