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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-ports by date

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