Informix - Problem description
Problem IT30685 | Status: Closed |
QUERY AGAINST VTI TABLE USING TODAY KEYWORD WITH PLUS OR MINUS CAUSES ASSERT FAILURE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
A simple query against TS using TODAY and adding or subtracting creates an AF and errors: Create dbaccessdemo7 select * from ts_data_v where tstamp = (TODAY-1); 244: Could not do a physical-order read to fetch next row. 12803: Error in executing an access_method routine execution sequence. or just crashes engine. 10:41:12 The C Language Module loaded 10:41:12 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem 10:41:12 IBM Informix Dynamic Server Version 14.10.FC2DE 10:41:12 Who: Session(59, informix@host,31432, 0x4577be28) Thread(69, sqlexec, 45732008, 10) File: mtex.c Line: 420 10:41:12 Action: Please notify IBM Informix Technical Support. 10:41:12 stack trace for pid 31868 written to $INFORMIXDIR/tmp/af.42dc388 10:41:12 See Also: $INFORMIXDIR/tmp/af.42dc388, shmem.42dc388.0 10:41:22 Exception Caught. Type: MT_EX_OS, Context: mem 10:41:22 (-9791): ERROR: Routine execution trap -- procname= procid=609 reason: mem afstack afhandler affail_interface mt_ex_throw_sig afsig_handler ts_vtam_beginscan ... Note that just using TODAY (no + or -) works fine. A literal date cast to a DATE type also works. Also casting (TODAY-n) to a datetime is also successful, e.g. the following works okay: select * from ts_data_v where tstamp = (TODAY-1)::datetime year to second; | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC3. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC3. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC14 and 14.10.xC3. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.10.2019 26.02.2020 26.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14, 14.10.xC3 | |
Problem solved according to the fixlist(s) of the following version(s) |