Informix SQL reports core dumping :-(
Posted in 1992
Gentle Netfolk, We've recently moved from Informix SQL 2.10.03 to a set of SE (4.00.UE4) and SQL (4.00.UE1). One ofthe big 'wins' of the new software is the implementation of the DATETIME type. However, using DATETIME variables or PARAMs in an ACE report when said variable or parameter is used within the SELECT statement, causes isql to core dump. Is this a known bug or feature? The following example report triggers the bug. Oh, hardware is 80386/80486 running SCO Xenix 2.3.2 or SCO Unix 3.2v2 respectively. Thanks phil -example follows---------------------------------------------------------- DATABASE boring END DEFINE VARIABLE ppp DATETIME YEAR TO SECOND END INPUT PROMPT FOR ppp USING "Enter DATETIME please (yyyy-mm-dd hh:mm:ss):" END SELECT callstart {callstart is DATETIME YEAR TO SECOND} FROM call_log WHERE callstart < $ppp END FORMAT EVERY ROW END -end of example---------------------------------------------------------- +--- phil sutherland ----------------------< philsuth@DIALix.oz.au >---+ | "It is an atrocity to teach Old Testament and European history to | | innocent children. Such knowledge can unhinge you if you're not old | | enough and tough enough to be reconciled to the fact that most men | | are criminal maniacs" -- Sigsimundo Celine | +----------------------------------------------------------------------+