[teiid-issues] [JBoss JIRA] (TEIID-4654) MSSQL pagination with select distinct

[Mark Tawk (JIRA)]

Mark Tawk created TEIID-4654:
--------------------------------

             Summary: MSSQL pagination with select distinct
                 Key: TEIID-4654
                 URL: https://issues.jboss.org/browse/TEIID-4654
             Project: Teiid
          Issue Type: Bug
            Reporter: Mark Tawk
            Assignee: Steven Hawkins


I'm using Teiid 9.0.0 with mssql translator on a sql server 2012 database

It seems sql server 2012 does not allow pagination with row fetch when used in select distinct query; i'm getting the following exception:

TEIID30504 dataModel_ptVDB: 145 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT g_0."Customer_ID" AS c_0, g_0."CalculatedField" AS c_1 FROM "data"."red4"."Customerview" g_0 ORDER BY @@version OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY]



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)