Re: buggy ROWID

In article <17vvm3INNc31@hpsdde.sdd.hp.com> kurt@sdd.hp.com (Kurt Andersen) writes: >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. If a and b are not indexed on k, and the problem goes away if a and b *are* indexed on k, then this is probably bug 13029, specific to rowids in 5.00.U[CD]*. It's fixed in 5.00.UE1 and beyond. -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland "I must have gone through 20 Porsches in the last 15 years. Now I own a Ferrari Testarossa. My body would reject a Plymouth." -- Willie Brown, speaker of the California State Assembly