Обсуждение: regress test db

Поиск
Список
Период
Сортировка

regress test db

От
Vince Vielhaber
Дата:
AFAIK the regress test database is working again.  If anyone's having
a problem with it let me know.


Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net        56K Nationwide Dialup from $16.00/mo
atPop4 Networking       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================

Re: regress test db

От
Masaru Sugawara
Дата:
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