Re: buggy ROWID

Posted in 1992

Kurt Andersen — 1 Sep 92 14:45:23 GMT — source: Informix-list mailing list archive (1991-1998)

On the other hand, using 4.1 ISQL and the 5.0 SE engine on HP 9000/series 300 I found the following behaviour: > select a.rowid arow, b.rowid brow, a.k ak, b.k bk from b, a where a.k = b.k > select a.rowid arow, b.rowid brow, a.k ak, b.k bk from a, b where a.k = b.k both generated: arow brow ak bk 3 3 1 1 3 3 3 3 The only way to get the expected result was to use "b, outer a" in the table specification. Cheers, Kurt -- kurt@hpsdid.sdd.hp.com 619/592-4373 (voice); 619/592-8191 (FAX) 16399 W. Bernardo Dr. MS 61U65/San Diego, CA 92127 -----Standard disclaimer stuff applies for all of the standard reasons-----