Re: Informix crashes with wrong datatype in stored procedure
What is schema of sometable ? I guess its
create table sometable(fld1 int);
if i go with this assumption and run the repro given
on 9.40.UC2 , I get error ,
1214 : Value exceeds limit of SMALLINT precision
Regards
Samar
--- rkusenet <rkusenet@sympatico.ca> wrote:
> IDS 9.21.UC4XE
> Solaris 2.6.
>
> We experiences an annoying informix crash today,
> which was
> eventually traced to a bug in informix regarding
> mismatched
> data type.
>
>
> Here is a simple test case to crash informix. I am
> taking
> care to reproduce the logic of our stored procedure
> as much
> as possible, specially in parameters and return
> datatype.
>
> create function call_1(p_in integer) returning
> decimal(8,4)
> define w_ret decimal(8,4);> foreach execute function call_2(p_in) into w_ret
> return w_ret with resume ;
> end foreach ;
> end function ;
>
> create function call_2(p_in smallint) returning
> decimal(8,4)
> define w_ret decimal(8,4);> foreach select fld1 into w_ret
> from sometable
> return w_ret with resume ;
> end foreach ;
> end function ;
>
> Note that there is a coding bug in function call_2.
> It declares
> the input parameter as smallint instead of integer.
>
> You may have to create a table sometable with a
> single column
> fld1 of decimal(8,4). Put some values there.
>
> Now to test the bug:-
>
> from dbaccess:-
>
> execute function call_1(3600); -- works fine.>
> execute function call_1(63600); -- crashes the> server
>
> if the signature of the function call_2 is changes
> to p_in integer,
> it runs fine.
>
> head of the af file:-
>
> 21:43:20 Informix Dynamic Server 2000 Version
> 9.21.UC4XE
> 21:43:21 Assert Failed: No Exception Handler
> 21:43:21 Who: Session(20, dba@matrix, 3570,
> 170117356)
> Thread(44, sqlexec, a20ddc8, 1)
> File: mtex.c Line: 405
> 21:43:21 Results: Exception Caught. Type:
> MT_EX_OS, Context: mem
> 21:43:21 Action: Please notify Informix Technical
> Support.
> 21:43:21 Stack for thread: 44 sqlexec>
> base: 0x0a9de000
> len: 36864
> pc: 0x006b43d0
> tos: 0x0a9e5ca0
> state: running
> vp: 1
>
> 0x006b3794 (oninit)afhandler(0x414e838, 0x1, 0x0,
> 0xa23c8ec, 0x3, 0xa20ddc8)
> 0x006b3200 (oninit)afcrash_interface(0x9a7794,
> 0xa9e63f8, 0xa3fefc0, 0x9a77ac, 0x195, 0x0)
> 0x006b76e4 (oninit)mt_ex_throw_sig(0x1, 0x9a4ae0,
> 0x4, 0xffffffff, 0x1, 0xff)
> 0x006876b0 (oninit)afsig_handler(0xa438c80,
> 0xa436020, 0x9a627c, 0xa23dc0, 0xa443114, 0x12d2)
> 0x0016940c (oninit)altcontext(0xffffffff, 0xa0f164,
> 0xa443108, 0xa465030, 0x0, 0xa43a2b0)
> 0x0016c16c (oninit)ip_clscur(0xffffffff, 0xa0f000,
> 0x0, 0x0, 0xa465030, 0x20000)
> 0x0016bffc (oninit)ip_close(0xa45d488, 0xa0f400,
> 0xa036800, 0x8f8000, 0xa3f1ed4, 0xa3f1f68)
> 0x003e0e34 (oninit)closecb (0xa45d488, 0x20,
> 0xa0f164, 0x38, 0x0, 0x0)
> 0x003e07e0 (oninit)close_cb_subtree_r(0xa443018,
> 0x20, 0xa45d488, 0xa45d488, 0x20, 0xa443018)
> 0x003e0714 (oninit)close_cb_subtree(0xa443018, 0x20,
> 0xa45d488, 0xa401170, 0xa4010d8, 0xa23c00)
> 0x003e0398 (oninit)closesdb(0x8c9748, 0x0, 0x0, 0x1,
> 0xa45d810, 0x0)
> 0x00344b10 (oninit)close_cursor(0xffffffff,
> 0xa23dc0, 0x12ca, 0x1000, 0x12d2, 0xa45d488)
> 0x00344850 (oninit)sq_close(0x28, 0x134e, 0x1, 0x0,
> 0xa443018, 0x10)
> 0x003bc0a4 (oninit)sqmain (0xa18568, 0x8c9400,
> 0xa23c00, 0x8ee078, 0xfffdffff, 0x20000)
> 0x00694698 (oninit)startup (0xa1e400, 0xa0f400,
> 0xa107270, 0x0, 0x0, 0xa107270)
> 0x006886ac (oninit)idle_processor(0x0, 0x0, 0x0,
> 0x0, 0x0, 0x0)
> 0x00000000 (*nosymtab*)0x0
>
>
>
>
>
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
sending to informix-list