Informix - Problem description
Problem IT12438 | Status: Closed |
A PREPARE OF SQL USING LIMIT COMMAND WITH HOST VARIABLE FAILS WITH "PREPARE FAILED" | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The following SQL works as expected: select skip 3 first 5 tabid, tabname from informix.systables; select skip 3 limit 5 tabid, tabname from informix.systables; select tabid, tabname from informix.systables skip 3 first 5; select tabid, tabname from informix.systables skip 3 limit 5; select skip 3 first 5 tabid, tabname from informix.systables where tabname like "sys%"; select skip 3 limit 5 tabid, tabname from informix.systables where tabname like "sys%"; select tabid, tabname from informix.systables where tabname like "sys%" skip 3 first 5; select tabid, tabname from informix.systables where tabname like "sys%" skip 3 limit 5; But if you put this in an esql/c program or java, it will fail at execution with "Prepare Failed" TEST: select skip ? first ? tabid, tabname from informix.systables Prepare failed TEST: select skip ? limit ? tabid, tabname from informix.systables Prepare failed TEST: select tabid, tabname from informix.systables skip ? first ? Prepare failed TEST: select tabid, tabname from informix.systables skip ? limit ? Prepare failed TEST: select skip ? first ? tabid, tabname from informix.systables where tabname like ? Prepare failed TEST: select skip ? limit ? tabid, tabname from informix.systables where tabname like ? Prepare failed TEST: select tabid, tabname from informix.systables where tabname like ? skip ? first ? Prepare failed TEST: select tabid, tabname from informix.systables where tabname like ? skip ? limit ? Prepare failed | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC8 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.11.2015 09.12.2016 09.12.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC8 | |
Problem solved according to the fixlist(s) of the following version(s) |