Thread: Backend doesn't like this query...

Hi, all.

I'm using V6.4.2 on RedHat Mandrake 6.0, and when I run the following
query, the backend says:

pqReadData() -- backend closed the channel unexpectedly

Here is the culprit:

SELECT Sno
FROM Take
    WHERE Cno = 'CS112'
    AND Cno NOT IN
    (SELECT Sno FROM Take
        WHERE Cno != 'CS112');

It's out of the book 'The Essence of SQL' by David Rozenshtein, which I am
reading and working through. Other queries from the book run fine.

I can't find any reference to the reason for this in pm.log - is there
somewhere else I should be looking?



--
Brad Crockett        Duncan BC Canada
b crockett at home dot com

bcrockett@PIII.bcrock.dynip.com (Brad Crockett) writes:
> I'm using V6.4.2 on RedHat Mandrake 6.0,

6.4.2 is ancient history --- we've fixed a lot of subselect bugs since
then.  Please update to the current release, 7.0.3.  If you still see
the problem with 7.0.3, please submit a complete script to reproduce
the crash, including table creation commands.

            regards, tom lane