Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3344

In JDBC adapter, generate "SELECT TOP(n)" for MSSQL 2008 and earlier, and for Sybase ASE

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.22.0
    • Component/s: jdbc-adapter
    • Labels:
      None

      Description

      In JDBC adapter, generate "SELECT TOP(n)" for Microsoft SQL Server (MSSQL) 2008 and earlier, because it doesn't support "FETCH".

      For MSSQL 2012 and higher, continue to generate "FETCH NEXT n ROWS".

      I have started work here: https://github.com/julianhyde/calcite/tree/3344-top-n

        Attachments

          Activity

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              julianhyde Julian Hyde
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: