crash ids 9.40uc2

hello, could someone test the following sql on his linux box? create table t1 (id integer); select id from t1 where id = 100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000 it assert failed for me. regards,

Jack wrote: > hello, > could someone test the following sql on his linux box? > > create table t1 (id integer); > select id > from t1 where id = 100000000000000000000000000000000000000000000000000> 000000000000000000000000000000000000000000000000 > 0000000000000000000000000000000000000000000000000 > 0000000000000000000000000000000000000000000000000 > 0000000000000000000000000000000000000000000000000 > 0000000000000000000000000000000000000000000000000 > 0000000000000000000000000000000000000000000000000 > 0000000000000000000000000000000000000000000000000 > 00000000000000000000000000000000000000000 > > it assert failed for me. > > regards, 16:22:23 Assert Failed: No Exception Handler 16:22:23 IBM Informix Dynamic Server Version 9.40.UC2E1 16:22:23 Who: Session(16, informix@message1, 15022, 0x10d88778) Thread(40, sqlexec, 10d58858, 1) File: mtex.c Line: 431 16:22:23 Results: Exception Caught. Type: MT_EX_OS, Context: mem SUSE 9.0 patched up to date -- Clive

I'm running IDS 9.40.UC1 on Solaris 8. The statement worked for me . . . "no rows found". Have you opened a case with tech support? Hope this helped. Brice Avila vomaringo@yahoo.com (Jack) wrote in message news:<682ae665.0403090729.38c99bcf@posting.google.com>... > hello, > could someone test the following sql on his linux box? > > create table t1 (id integer); > select id > from t1 where id = 100000000000000000000000000000000000000000000000000> 000000000000000000000000000000000000000000000000 > 0000000000000000000000000000000000000000000000000 > 0000000000000000000000000000000000000000000000000 > 0000000000000000000000000000000000000000000000000 > 0000000000000000000000000000000000000000000000000 > 0000000000000000000000000000000000000000000000000 > 0000000000000000000000000000000000000000000000000 > 00000000000000000000000000000000000000000 > > it assert failed for me. > > regards,

Hello, Jack! You wrote on 9 Mar 2004 07:29:07 -0800: J> create table t1 (id integer); J> select id J> from t1 where id = 1000000000000000000000000000000000000000000000000 J> 000000000000000000000000000000000000000000000000 J> 0000000000000000000000000000000000000000000000000 J> 0000000000000000000000000000000000000000000000000 J> 0000000000000000000000000000000000000000000000000 J> 0000000000000000000000000000000000000000000000000 J> 0000000000000000000000000000000000000000000000000 J> 0000000000000000000000000000000000000000000000000 J> 00000000000000000000000000000000000000000 J> it assert failed for me. My box too: RedHat Linux 8.0 Kernel 2.4.18.14 IDS 9.40.UC1 NETWORK PROTOCOL NOT SUPPORTED...& crashed.... Ciao. With best regards, Southerne. E-mail: nothing@to.do