Re: Informix 5.00/5.01 bugs?

In article cqe@bilbo.nask.org.pl, doctorq@sam (DoctorQ Komputery i Programy) writes: |Tang Chang Thai (scornd7@solomon.technet.sg) wrote: |: Does any body know whether there is any compelling reason to upgrade to |: 5.01 or 5.02 from 5.00? Alternatively, does anybody has any info of bug |: fixes that accompany 5.01/5.02? |: Would appreciate any feedback B^) [stuff deleted] |I know some big bugs, still not fixed: | - Errors when you table has more than 8 extents (try use WHERE FIELD > int !) | - Wrong entries in SYSTABLES, making dbexport unusable |and so on, and so on. I'm not sure if this one has been fixed yet... try 'tbunload'ing a database having synonyms, and then 'tbload'ing it to a different machine where the database pointed to by the synonyms has a different path, or is non-existent. selecting from the synonym fails, because it can't find the target database (fair enough I guess). running "select * from syssynonyms" shows no records "drop synonym" fails, because of above "create synonym" fails, because it thinks the table exists. It has a record in systables telling it there is a synonym by that name, but there isn't. You can patch it by deleting the table entry from systables, and re-creating the synonym. - Ben Kelley. -- Ben Kelley (Good Guy) - SBC Australia Ltd. Hey wow! If your hold the thinnet cable to your ear, ben@syd.au.swissbank.com (Preferred) you can hear the information kelley@il.us.swissbank.com (NeXT mail OK) 22 wheelers... (Children - don't Phone +61 2 258 2382 ("Hello, this is Ben.") try this at home.)