Minor beta buglet "unrecognized node type: 302"

Started by Ian Lawrence Barwickover 22 years ago2 messagesbugs
Jump to latest
#1Ian Lawrence Barwick
barwick@gmail.com

through my patented unit testing technology (caffein and sleep deprivation)
I came across this:
db=> SELECT 1 FROM object WHERE object IS NOT NULL;
ERROR: unrecognized node type: 302

where I was expecting something more like this:
db=> SELECT 1 FROM object WHERE mispelt_column IS NOT NULL;
ERROR: column "mispelt_column" does not exist

Occurs when a valid table name is present in the WHERE clause
where a column name would be expected.

Present in 7.4beta5 (and also in 7.3.4 with the message
"expression_tree_walker: Unexpected node type 711").

Ian Barwick
barwick@gmx.net

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Ian Lawrence Barwick (#1)
Re: Minor beta buglet "unrecognized node type: 302"

Ian Barwick <barwick@gmx.net> writes:

I came across this:
db=> SELECT 1 FROM object WHERE object IS NOT NULL;
ERROR: unrecognized node type: 302

Okay, now it says

ERROR: relation reference "object" cannot be used in an expression

regards, tom lane