Postgres Pro
Downloads
Home   >   mailing lists

Thread: backend crashing with INTERSECT / ORDER BY

backend crashing with INTERSECT / ORDER BY

From
Dirk Lutzebaeck
Date:
So I tried INTERSECT with ORDER BY and it crashes on 6.5 and 6.5.1:

[csmaster@kamet release0]$ psql cs1
Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: cs1

cs1=> SELECT envelope FROM docobj
cs1-> WHERE attrid=5
cs1-> INTERSECT
cs1-> SELECT envelope FROM docobj
cs1-> WHERE attrid=6
cs1-> ORDER BY attrid DESC
cs1-> ;
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.

Any clues?

Dirk

Re: [GENERAL] backend crashing with INTERSECT / ORDER BY

From
Bruce Momjian
Date:
>
> So I tried INTERSECT with ORDER BY and it crashes on 6.5 and 6.5.1:
>
> [csmaster@kamet release0]$ psql cs1
> Welcome to the POSTGRESQL interactive sql monitor:
>   Please read the file COPYRIGHT for copyright terms of POSTGRESQL
> [PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]
>
>    type \? for help on slash commands
>    type \q to quit
>    type \g or terminate with semicolon to execute query
>  You are currently connected to the database: cs1
>
> cs1=> SELECT envelope FROM docobj
> cs1-> WHERE attrid=5
> cs1-> INTERSECT
> cs1-> SELECT envelope FROM docobj
> cs1-> WHERE attrid=6
> cs1-> ORDER BY attrid DESC
> cs1-> ;
> 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.
>

Not sure.  I just tried this:

test=> select relname from pg_class intersect select relname from
    pg_class order by relname;
ERROR:  get_sortgroupclause_expr: ORDER/GROUP BY expression not found in
    targetlist

Not sure what this means either.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: [GENERAL] backend crashing with INTERSECT / ORDER BY

From
greg@proterians.net
Date:
> >
> > So I tried INTERSECT with ORDER BY and it crashes on 6.5 and 6.5.1:
> >
> > [csmaster@kamet release0]$ psql cs1
> > Welcome to the POSTGRESQL interactive sql monitor:
> >   Please read the file COPYRIGHT for copyright terms of POSTGRESQL
> > [PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]
> >
> >    type \? for help on slash commands
> >    type \q to quit
> >    type \g or terminate with semicolon to execute query
> >  You are currently connected to the database: cs1
> >
> > cs1=> SELECT envelope FROM docobj
> > cs1-> WHERE attrid=5
> > cs1-> INTERSECT
> > cs1-> SELECT envelope FROM docobj
> > cs1-> WHERE attrid=6
> > cs1-> ORDER BY attrid DESC
> > cs1-> ;
> > 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.
> >
>
> Not sure.  I just tried this:
>
> test=> select relname from pg_class intersect select relname from
>     pg_class order by relname;
> ERROR:  get_sortgroupclause_expr: ORDER/GROUP BY expression not found in
>     targetlist
>
> Not sure what this means either.
>

  On 6.5.2 ....

  test=> select relname from pg_class intersect select relname from
        pg_class order by relname;


  works fine...

  --Greg--