Informix - Problem description
Problem IT12797 | Status: Closed |
ENGINE TO RETURN ERROR 201 AFTER JSON LISTENER HAS WRONGLY MODIFIED SELECT FIRST QUERY | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Engine expectedly returned error -201 when it received a modified and syntactically wrong query from the json listener compared to what user entered initially. This used to work prior to version 12.10.xC6. Run in browser: :/db/system.sql?query={"$sql":"select first 3 tabname from systables"} You will get returned with an output file containing: {"err":"internal error","errmsg":"A syntax error has occurred. (SQL Code: -201, SQL State: 42000)","ok":false} | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users using SQL passthrough functionality with a "SELECT * * FIRST n ..." query. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Fixed in IDS 12.10.xC6. Upgrade to 12.10.xC6 to resolve. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.12.2015 09.12.2016 09.12.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC6 | |
Problem solved according to the fixlist(s) of the following version(s) |