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@earthling.net Programmers don't die, they
justGOSUB without RETURN.