Skip site navigation (1) Skip section navigation (2)

General Bug Report: bug in planner/optimizer

From: Unprivileged user <nobody>
To: pgsql-bugs(at)postgresql(dot)org
Subject: General Bug Report: bug in planner/optimizer
Date: 1999-01-25 20:50:02
Message-ID: 199901252050.PAA11615@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
============================================================================
                        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:
---------


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


pgsql-bugs by date

Next:From: Unprivileged userDate: 1999-01-27 17:58:49
Subject: General Bug Report: Postmaster hangs under load
Previous:From: Unprivileged userDate: 1999-01-22 13:41:47
Subject: General Bug Report: Problem Deleting VIEWS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group