[ https://issues.apache.org/jira/browse/BEAM-9169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yueyang Qiu updated BEAM-9169: ------------------------------ Description: When I am testing query string {code:java} "SELECT STRING(TIMESTAMP \"2008-12-25 15:30:00\", \"America/Los_Angeles\")"{code} on BeamZetaSqlCalcRel I found that the second string parameter to the function is unparsed to {code:java} America\/Los_Angeles{code} (note an extra backslash character is added). This breaks the ZetaSQL evaluator with error {code:java} Syntax error: Illegal escape sequence: \\{code} was: When I am testing query string {code:java} "SELECT STRING(TIMESTAMP \"2008-12-25 15:30:00\", \"America/Los_Angeles\")"{code} on BeamZetaSqlCalcRel I found that the second string parameter to the function is unparsed to {code:java} America\/Los_Angeles{code} (note an extra backslash character is added). This breaks the ZetaSQL evaluator with error {code:java} Syntax error: Illegal escape sequence: \{code} > Extra character introduced during Calcite unparsing > --------------------------------------------------- > > Key: BEAM-9169 > URL: https://issues.apache.org/jira/browse/BEAM-9169 > Project: Beam > Issue Type: Improvement > Components: dsl-sql-zetasql > Reporter: Yueyang Qiu > Assignee: Yueyang Qiu > Priority: Minor > > When I am testing query string > {code:java} > "SELECT STRING(TIMESTAMP \"2008-12-25 15:30:00\", > \"America/Los_Angeles\")"{code} > on BeamZetaSqlCalcRel I found that the second string parameter to the > function is unparsed to > {code:java} > America\/Los_Angeles{code} > (note an extra backslash character is added). > This breaks the ZetaSQL evaluator with error > {code:java} > Syntax error: Illegal escape sequence: \\{code} -- This message was sent by Atlassian Jira (v8.3.4#803005)