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

Re: [PORTS] Port Bug Report: Query processing seems broken

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Joerg Fischer <fischer(at)zkm(dot)de>
Cc: pgsql-ports(at)postgreSQL(dot)org
Subject: Re: [PORTS] Port Bug Report: Query processing seems broken
Date: 1999-05-10 17:22:04
Message-ID: 199905101722.NAA08998@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-ports
I tried this in 6.5beta, and it worked:


select relname from pg_class where relname in 
        (select relname from pg_class where relname in 
                (select relname from pg_class)
        )
 union select relname from pg_class;


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


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist(at)candle(dot)pha(dot)pa(dot)us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-ports by date

Next:From: Bruce MomjianDate: 1999-05-10 17:26:49
Subject: Re: [BUGS] did this ever get integrated ? (for OpenBSD)
Previous:From: Bruce MomjianDate: 1999-05-10 16:44:38
Subject: Re: [PORTS] Port Bug Report: Regexp does not allow alternation in CHECK clause

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