============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Andriy I Pilipenko
Your email address : bamby@marka.net.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:
---------
--------------------------------------------------------------------------