From: | Oleg Broytmann <phd(at)sun(dot)med(dot)ru> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Bug on complex join |
Date: | 1999-03-15 13:36:06 |
Message-ID: | Pine.SOL2.3.96.SK.990315163306.23446A-100000@sun.med.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello!
Now for those who said he cannot beleive there is a bug in join - the
following query produced two different results on two different systems
with identical data loaded:
SELECT DISTINCT p.subsec_id
FROM central cn, shops sh, districts d, positions p
WHERE cn.shop_id = sh.shop_id AND sh.distr_id = d.distr_id
AND d.city_id = 2 AND cn.pos_id = p.pos_id
;
subsec_id
---------
1
2
10
11
12
13
14
15
(8 rows)
on one system and
subsec_id
---------
(0 rows)
on the other.
First system is sparc-solrais and second is intel-linux (Debian 2.0,
glibc2). Another glibc2-realted bug?
Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Samersoff | 1999-03-15 13:36:55 | new mirror |
Previous Message | Cary O'Brien | 1999-03-15 13:09:01 | Re: postmaster dies (was Re: Very disappointing performance) |