[ https://issues.apache.org/jira/browse/CALCITE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-5996: ------------------------------------ Labels: pull-request-available (was: ) > 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 > Priority: Minor > Labels: pull-request-available > > This query > {code} > select translate(col using utf8) > from (select 'a' as col > from (values(true))) > {code} > if converted to SqlNode and back produces: > {code} > 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)