Re: regress test db

On Tue, 13 Nov 2001 21:27:12 -0500 (EST)
Vince Vielhaber <vev@michvhf.com> wrote:

> AFAIK the regress test database is working again.  If anyone's having
> a problem with it let me know.
Hi, VinceNot a problem, but...I pondered whether the several examples, which is used nestedEXCEPT/INTERSECT/UNION among
threeSELECTs at the "Operator precedenceand (((((extra))))) parentheses" in the ../regress/sql/union.sql,have the case
likea query returning an incorrect result in v7.1.* (e.g. See below) or not.  Finally, the reconfirmation may lead me
toconcludethat the examples can't reflect the behavior of the fixednested EXCEPT/INTERSECT(Thanks Tom).  I wish there
wassomething newto be able to demonstrate the fixed. 
 
SELECT q1 FROM int8_tblINTERSECT ALLSELECT q2 FROM int8_tblINTERSECTSELECT q2 FROM int8_tbl;
 q1----- 123           <--NG(1 row)

SELECT q1 FROM int8_tblINTERSECTSELECT q2 FROM int8_tbl INTERSECTSELECT q2 FROM int8_tbl;
 q1         ----- 123           <--NG(1 row)

SELECT q1 FROM int8_tbl INTERSECT ALLSELECT q2 FROM int8_tblEXCEPTSELECT q2 FROM int8_tbl WHERE q2 < 1000;
 q1----(0 rows)           <--NG

SELECT q1 FROM int8_tblINTERSECTSELECT q2 FROM int8_tblEXCEPT ALLSELECT q2 FROM int8_tbl WHERE q2 < 1000;
 q1----(0 rows)           <--NG


TIA,Masaru Sugawara