General Bug Report: bug in planner/optimizer

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Andriy I Pilipenko
Your email address : bamby(at)marka(dot)net(dot)ua

Category : runtime: back-end
Severity : serious

Summary: bug in planner/optimizer

System Configuration
--------------------
Operating System : FreeBSD 2.2.6, Linux 2.0.36 RedHat

PostgreSQL version : 6.4.2

Compiler used : gcc-2.7.2.1 and gcc-2.7.2.1

Hardware:
---------
FreeBSD: AMD K6 48M RAM, Linux: Pentium 32M RAM

Versions of other tools:
------------------------
gmake 3.76.1, flex 2.5.4

--------------------------------------------------------------------------

Problem Description:
--------------------
The following request causes coredump of backend with SEGV
SELECT <blah-blah>
WHERE table1.field = 1 OR table2.field = -1

--------------------------------------------------------------------------

Test Case:
----------
Following three requests demonstrates the bug:
CREATE TABLE a (a int);
CREATE TABLE b (b int);
SELECT * FROM a, b WHERE a = 1 OR b = -1;

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------