Horton

Thread

  1. General Bug Report: bug in planner/optimizer

    Unprivileged user <nobody> — 1999-01-25T20:50:02Z

    ============================================================================
                        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:
---------


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