BUG #9227: Error on SELECT ROW OVERLAPS ROW with single ROW argument

From: pythonesque(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #9227: Error on SELECT ROW OVERLAPS ROW with single ROW argument
Date: 2014-02-15 03:55:49
Message-ID: 20140215035549.24618.37927@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 9227
Logged by: Joshua Yanovski
Email address: pythonesque(at)gmail(dot)com
PostgreSQL version: 9.3.2
Operating system: Ubuntu 12.0.4
Description:

# SELECT ROW (1) OVERLAPS ROW (2);
ERROR: XX000: unrecognized node type: 656
LOCATION: transformExprRecurse, parse_expr.c:359

I'm not sure why this even parses, as it's not documented to do so. I do
notice, however, that in makeOverlaps in gram.y creates a recursive list
when largs or args has only one argument, which seems wrong to me.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2014-02-15 04:01:11 Re: BUG #8461: PostgreSQL 9.3 pg_dump heap corruptions
Previous Message Claudio Freire 2014-02-14 23:16:25 Re: BUG #9161: wal_writer_delay is limited to 10s