Port Bug Report: Query processing seems broken

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

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

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