Re: [HACKERS] Bug on complex join

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 just GOSUB without RETURN.