[jira] [Created] (CALCITE-5996) TRANSLATE operator is incorrectly unparsed

[Mihai Budiu (Jira)]

Mihai Budiu created CALCITE-5996:
------------------------------------

             Summary: TRANSLATE operator is incorrectly unparsed
                 Key: CALCITE-5996
                 URL: https://issues.apache.org/jira/browse/CALCITE-5996
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.35.0
            Reporter: Mihai Budiu


This query

{code:sql}
select translate(col using utf8)
from (select 'a' as col
 from (values(true)))
{code}

if converted to SqlNode and back produces

{code;sql}
SELECT TRANSLATE("COL", "UTF8")
FROM (SELECT 'a' AS "COL"
        FROM (VALUES ROW(TRUE)))
{code}

which is no longer correct SQL.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)