Thread: Minor beta buglet "unrecognized node type: 302"

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

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