[jira] [Created] (CALCITE-4590) Incorrect query result with fixed-length string

["Roman Kondakov (Jira)" <ji...@apache.org>]

Roman Kondakov created CALCITE-4590:
---------------------------------------

             Summary: Incorrect query result with fixed-length string
                 Key: CALCITE-4590
                 URL: https://issues.apache.org/jira/browse/CALCITE-4590
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.26.0
            Reporter: Roman Kondakov


Query may return wrong result when fixed-length strings (CHAR(N)) are used in OR/IN clause


{code:java}
@Test void test() {
    // Passed.
    CalciteAssert.that()
        .query("select * from (values (1, 'a'), (2, 'abc')) where EXPR$1 = 'a'")
        .returns("EXPR$0=1; EXPR$1=a  \n");

    // Failed. Only "EXPR$0=2; EXPR$1=abc\n" is returned
    CalciteAssert.that()
        .query("select * from (values (1, 'a'), (2, 'abc')) where EXPR$1 = 'a' or EXPR$1 = 'abc'")
        .returns("EXPR$0=1; EXPR$1=a  \n"
            + "EXPR$0=2; EXPR$1=abc\n");
  }
{code}




--
This message was sent by Atlassian Jira
(v8.3.4#803005)