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

Substring operator broken for MSSQL

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.14.0
    • jdbc-adapter
    • None

    Description

      The format mssql uses looks like:
      SUBSTRING(input, start, length)

      but the default is currently to unparse to SUBSTRING(input FROM start FOR length)

      Attachments

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-1841 Create handlers for JDBC dialect-specific generated SQL

          • Major - Major loss of function.
          • Closed
          links to

          Web Link PR 504

          Activity

            People

              chris-baynes Chris Baynes
              chris-baynes Chris Baynes
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: