Re: [HACKERS] Open 6.5 items - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Open 6.5 items
Date
Msg-id 15980.928469712@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Open 6.5 items  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] Open 6.5 items
List pgsql-hackers
Bruce Momjian <maillist@candle.pha.pa.us> writes:
> The issue is the issue:
>     test=> drop table test;
>     DROP
>     test=> create table test(x int);
>     CREATE
>     test=> insert into test values (3);
>     INSERT 72169 1
>     test=> select * from test where test in (select x from test);
>     NOTICE:  unknown node tag 704 in fireRIRonSubselect()
>     NOTICE:  Node is: { IDENT "test" }
>     ERROR:  ExecEvalExpr: unknown expression type 704

Hmm.  Doesn't happen if one does
select * from test where x in (select x from test);

Is there any rational interpretation to the first query?  test is not an
available column name, so I don't know what it is supposed to mean.

I'm having a hard time seeing this as a showstopper bug... at best it's
an error that needs to be caught somewhere where a better error message
can be given...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Open 6.5 items
Next
From: Don Baccus
Date:
Subject: Re: [HACKERS] Priorities for 6.6