Informix - Problem description
Problem IT14464 | Status: Closed |
ERROR 201 RETURNED WHEN EXECUTING A QUERY WITH SYNTACTICALLY CORRECT GROUP BY CLAUSE BUT CONTAINING TERM REPETITION | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Group by clause in following query is syntactically correct even though it does not make any sense because of term repetition. An error describing why there should be no redundancy in the group by clause is expected instead of having error 201 returned by such a query. select col1 , col2 from test group by 1, 1, 2; | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * production environment * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.03.2016 28.06.2016 28.06.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC7 | |
Problem solved according to the fixlist(s) of the following version(s) |