Re: Online 5.0

In article <9221@emory.mathcs.emory.edu> baskett@hermes1.sps.mot.com (Bob Baskett) writes: > >I am interested in any bugs/problems anyone is having with OnLine version >5.0. We are running 5.00.UC2 on a sun 690MP and have come across a few >quirks; > >1. select a.rowid, b.rowid > from table1 a, table2 b > where a.col1 = b.col1 > > this returns some interesting values - namely, if you dont have an > index on the join columns for both tables it returns the max rowids > from both tables for each line. add an index to table1, you will > get the correct rowids for table1 and the max rowid from table2. Sounds like known bug 13029, 5.0 regression, fixed in 5.00.UE1 / 5.01. >2. tbcheck -pe appears to be limited to 14 chunks. we currently have > 21 chunks. No record of this ever being reported. >There are more. Let me know if you come across any. >Bob Baskett >Motorola, Inc. >baskett@hermes1.sps.mot.com -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland "They've taken Bill Clinton back into the 'smoke-filled room', and this time they're making him inhale!" -- LNWDL 1992 Democratic Convention correspondent Larry 'Bud' Melman