DB2 FOR LUW / DB2FORLUW / A10 - DB2

"group by 1" syntax which MSSQL does not support is pushed down 
to MSSQL incorrectly: 
 
SELECT MIN(ID1) FROM (SELECT ID1 FROM NICK1 UNION ALL SELECT ID2 
FROM NICK2) 
 
1 
----------- 
SQL1822N  Unexpected error code "42000" received from data 
source "MSSQL2008". 
Associated text and tokens are "Each GROUP BY expression must 
contain at least 
one col".  SQLSTATE=560BD 
 
 
To recreate the issue: 
 
SET PASSTHRU MSSQL2008; 
DROP TABLE TABLE1; 
DROP TABLE TABLE2; 
CREATE TABLE [TABLE1]( [ID1] [int]); 
CREATE TABLE [TABLE2]( [ID2] [int]); 
SET PASSTHRU RESET; 
 
CREATE NICKNAME NICK1 FOR "MSSQL2008"."dbo"."TABLE1"; 
CREATE NICKNAME NICK2 FOR "MSSQL2008"."dbo"."TABLE2"; 
 
SELECT MIN(ID1) FROM (SELECT ID1 FROM NICK1 UNION ALL SELECT ID2 
FROM NICK2); 
 
 
From explain, we can see following query is pushed down to 
MSSQL: 
 
RMTQTXT : (Remote statement) 
 SELECT MIN( A0."ID1") FROM "dbo"."TABLE1" A0 GROUP BY 1

**************************************************************** 
* USERS AFFECTED:                                              * 
* The user is running MSSQL wrapper.                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Federation Server v10.1 fp3.                      * 
****************************************************************

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

The problem was firstly fixed on Federation Server v10.1 fp3.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

22.04.2013
03.10.2013
03.10.2013