Re: [HACKERS] Open 6.5 items

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