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

TRANSLATE operator is incorrectly unparsed

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Resolved
    • 1.35.0
    • 1.36.0
    • core

    Description

      This query

      select translate(col using utf8)
      from (select 'a' as col
       from (values(true)))
      

      if converted to SqlNode and back produces:

      SELECT TRANSLATE("COL", "UTF8")
      FROM (SELECT 'a' AS "COL"
              FROM (VALUES ROW(TRUE)))
      

      which is no longer correct SQL.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mbudiu Mihai Budiu
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: