RE: Possible bug IDS 7.30.UC7 on HPUX (Repost with typos removed :()

I can easily reproduce this in both following two cases: Environment: Informix Dynamic Server Version 7.30.UC8 SunOS confidential_node_name 5.6 Generic_105181-16 sun4u sparc SUNW,UltraAX-MP Case 1: Permanent table t1 (real life table) with index on c1, no index on c2. Temp table t2 same schema as t1 no index at all. SQL: SELECT first 700 t1.c1, t1.c2 FROM t1, t2 WHERE t1.c1 = t2.c1 ORDER BY t1.c2 Case 2: Two temp tables without any index. I can easily notice that the result rows are in wrong order, but haven't got time to check duplicates. In my test the result rows are in wrong order all times. Carl Y. Wu Tony Flaherty <aef@mfs.misys.co.uk> wrote in message <8h2sh1$69q$1@hermes.mfs.misys.co.uk>... > My previous post was a little unclear, so here goes again. > > HPUX 10.20 > IDS 7.30.UC7 > > I have a strange occurrence on my instance, SELECT FIRST x .... > is giving incorrect results for values of x > approx. 560 > .....