From: | Unprivileged user <nobody> |
---|---|
To: | pgsql-ports(at)postgresql(dot)org |
Subject: | Port Bug Report: Query processing seems broken |
Date: | 1999-05-06 15:27:07 |
Message-ID: | 199905061527.LAA43352@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ports |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Joerg Fischer
Your email address : fischer(at)zkm(dot)de
Category : runtime: back-end: SQL
Severity : serious
Summary: Query processing seems broken
System Configuration
--------------------
Operating System : SuSE Linux 6.0 (i386) - Kernel 2.0.36 (ELF)
PostgreSQL version : 6.5beta1
Compiler used : egcs-2.91.60
Hardware:
---------
Pentium II-450, 128 MB RAM, 9 GB U2W HD, Adaptec U2W Cont.
Linux salon09 2.0.36 #3 Mon Apr 26 20:44:52 CEST 1999 i686 unknown
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
--------------------------------------------------------------------------
Test Case:
----------
The following query fails with PGSQL 6.5beta1,
even though it seems correct:
select superext as name from OM_ExtendInheritance where subext in (
select superext as name from OM_ExtendInheritance where subext in (
select 'Patient' as name
)
union select 'Patient' as name
);
Postgresql reports:
ERROR: parser: parse error at or near "union"
Could there be a problem handling nested expressions?
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Unprivileged user | 1999-05-06 21:52:57 | Port Bug Report: Can't create table because of "no amop" error on index. |
Previous Message | Unprivileged user | 1999-05-06 14:45:31 | Port Bug Report: unable to delete table due to "heap_delete" error |