crash ids 9.40uc2

Posted in 2004

Summary

Jack reported that a SELECT comparing an integer column to a huge literal of about 400 digits caused an assert failure on IDS 9.40.UC2. Clive Eisen reproduced it on 9.40.UC2E1 (SUSE, mtex.c exception), and Southerne saw a crash on 9.40.UC1 (Red Hat). Brice Avila saw no rows found on UC1 (Solaris 8). No fix given.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Error Codes & Troubleshooting, Platform-Specific Issues, Versions, Editions & End-of-Life

Jack — 9 Mar 2004 07:29:07 -0800 — source: Usenet: comp.databases.informix

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,

↪ replying to Jack

Clive Eisen — Tue, 09 Mar 2004 16:24:56 +0000 — source: Usenet: comp.databases.informix

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

↪ replying to Jack

Brice Avila — 9 Mar 2004 14:29:49 -0800 — source: Usenet: comp.databases.informix

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,

↪ replying to Jack

Southerne — Wed, 10 Mar 2004 09:20:36 +0100 — source: Usenet: comp.databases.informix

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

Related threads

Glossary

IDS (Informix Dynamic Server)