Sergey Nuyanzin created CALCITE-7565:
----------------------------------------
Summary: TRIM(BOTH ' ') stopped wroking since Calcite 1.39.0
Key: CALCITE-7565
URL: https://issues.apache.org/jira/browse/CALCITE-7565
Project: Calcite
Issue Type: Bug
Components: core
Reporter: Sergey Nuyanzin
Assignee: Sergey Nuyanzin
Before Calcite 1.39.0 the query
{code:sql}
SELECT TRIM(BOTH ' a ');
{code}
worked
after that it fails on parser and requires {{FROM}} like
{code:sql}
SELECT TRIM(BOTH FROM ' a ');
{code}
probably the regression after CALCITE-6709.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)