|
Problem IT31594
|
Status: Closed |
SELECT WITH GROUP BY AND AGGREGATE CONTAINING DECODE() FUNCTION FAILS WITH -294
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
With the fix for IT21230, a query with a group by on all columns
except an aggregate containing DECODE() will return the
following error on the aggregate column name:
-294 The column column-name must be in the GROUP BY list.
In a grouping SELECT, you must list every nonaggregate column in
the
GROUP BY clause to ensure that a well-defined value exists for
each
selected column in each grouped row. A column contains either a
single
aggregate value or a value unique to that group. If a selected
column
were neither an aggregate nor in the list, two or more values
for that
column might possibly exist in some group, and the database
server
could not choose which value to display. Revise the query to
include
either the column name or its positional number in the clause.
... which is clearly not correct. Removing DECODE() from the
aggregate calculation will prevent the error. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to Informix Server 12.10.xC14 or 14.10.xC4 (when *
* available). *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to Informix Server 12.10.xC14 or 14.10.xC4 (when *
* available). *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC14 and 14.10.xC4. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.01.2020
03.03.2020
03.03.2020 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC14,
14.10.xC4
|
| Problem solved according to the fixlist(s) of the following version(s) |
