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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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:
---------
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Unprivileged user | 1999-01-27 17:58:49 | General Bug Report: Postmaster hangs under load |
Previous Message | Unprivileged user | 1999-01-22 13:41:47 | General Bug Report: Problem Deleting VIEWS |