Informix logs read-only queries? can't handle 'not-exists'?

i'm running Online 5.0 and seemed to have discovered a bug (or bugs). i ran the following query overnight: select count(*) from relA where (relA.x10A = 0 or relA.x10A = 5) and not exists ( select relB.evenAcct from relB where (relB.x100B = 0 or relB.x100B = 49) and relB.evenAcct = relA.acct ); and got hundreds of "Logical Log Files are Full -- Backup is Needed". the worst thing is that this corrupted the database. first of all, the above query is read-only, so it should not create log records (unless informix is doing something weird and supporting cascade aborts). secondly, the database had logging turned off (with 'tbtape -N databasename'), but it still logs anyway! and a query sure shoudn't corrupt the database. has anyone seen this before? i can reproduce it; i ran this twice already with the same result. and yes, i was the only person accessing the database that night. -- --------------------------------------------------------------------------- ron choi \\\\ #include <disclaimer.h> university of wisconsin, madison \\\\ "when i was your age, i walked ten miles to school, unarmed."