Informix - Problem description
Problem IT35847 | Status: Closed |
AGGREGATE EXPRESSIONS INCONSISTENCY I.E. MIN(), MAX() WITH UNION | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
You'll get -308 error (incompatible type) with following: --Create Test table create temp table tab1(col1 char(8)) with no log; insert into tab1 values ('ZZZ'); -- Test1 - Fails with SQL 308 error select col1, 0, '0' from tab1 UNION select col1, MIN(1), MIN('1') from tab1 group by 1 -- Test2 - works select col1, 0 from tab1 UNION select col1, MIN(1) from tab1 group by 1 -- Test3 - works select col1, '0' from tab1 UNION select col1, MIN('1') from tab1 group by 1 -- Test4 - works select col1, 0, '0' from tab1 UNION select col1, MIN(1), MIN('1')::char from tab1 group by 1 --Test5 - works select col1, 0, '0' from tab1 UNION select col1, MIN(1), MIN('2') from tab1 group by 1 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC7. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC7. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC16 and 14.10.xC7. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.02.2021 01.05.2023 01.05.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |