Re: RE: Multiple On-lines

|/ hpcc01:comp.databases.informix / rridley@sin-pss.DHL.COM (Richard Ridley) / 8:48 pm Apr 11, 1993 / |RE: | |>WARNING: There are known bugs in Online 5.0 and I-Star 5.0 HP |>platform which make the above scenario unreliable. (I have no info |>on other platforms) In certain cases, outer-join select statements |>return incorrect results (while using I-Star). According to |>Informix the problem is deep in the optimizer. This problem, as of |>yet, is not fixed in the 5.01 release. | |Which 'known' bugs ? Please could you elaborate on this one :) There is a problem with outer joins on the HPUX 8.0 Online 5.0 platform (I don't know about other platforms). We've noticed this problem in an environment which is running multiple instances of OnLine and attempting to perform 'outer joins' between these instances. A select statement returns 0 rows when any one of the tables in the outer join does not have data. (The query should be returning rows). An error is not returned, just bad results. We've been told a fix for this will be release soon after the 5.01 version is out. Derek | |Cheers, | |Richard Ridley |---------- |