[jira] [Commented] (CALCITE-6780) Trim function failed in SqlOperatorTest when the expression is TRIM(string)

[ZheHu (Jira)]

    [ 
https://issues.apache.org/jira/browse/CALCITE-6780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17912313#comment-17912313
 ] 

ZheHu commented on CALCITE-6780:
--------------------------------

I test trim in QuidemTest
{code:java}
select trim('  ciao ');
+--------+
| EXPR$0 |
+--------+
| ciao   |
+--------+
(1 row)

!ok
{code}

and in JdbcTest.
{code:java}
@Test void testTrim() {
    CalciteAssert.hr()
        .query("select trim(' aAa ') as A\n"
            + "from \"hr\".\"emps\" limit 1\n")
        .returnsUnordered("A=aAa");
  }
{code}

They are both OK. So I think this case just occurs in SqlOperatorTest.

> Trim function failed in SqlOperatorTest when the expression is TRIM(string)
> ---------------------------------------------------------------------------
>
>                 Key: CALCITE-6780
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6780
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.38.0
>            Reporter: ZheHu
>            Assignee: ZheHu
>            Priority: Minor
>
> When running the following test in SqlOperatorTest,
> {code:java}
> f.checkString("trim(' aAa ')", "aAa", "VARCHAR(5) NOT NULL");
> {code}
> it throws "java.lang.StringIndexOutOfBoundsException: begin 8, end 21, length 
> 17", which comes from buildQuery2() in AbstractSqlTester.



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