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)