Online 5.0
Posted in 1992
Bob Baskett — — source: Informix-list mailing list archive (1991-1998)
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. 2. tbcheck -pe appears to be limited to 14 chunks. we currently have 21 chunks. There are more. Let me know if you come across any. -- Bob Baskett Motorola, Inc. baskett@hermes1.sps.mot.com