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

Port Bug Report: Query processing seems broken

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 (view raw or flat)
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:
---------


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


Responses

pgsql-ports by date

Next:From: Unprivileged userDate: 1999-05-06 21:52:57
Subject: Port Bug Report: Can't create table because of "no amop" error on index.
Previous:From: Unprivileged userDate: 1999-05-06 14:45:31
Subject: Port Bug Report: unable to delete table due to "heap_delete" error

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