Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4654

MSSQL pagination with select distinct

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.2
    • 9.0
    • JDBC Connector
    • None

    Description

      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]

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            mtawk Mark Tawk (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: