Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-4590

Incorrect query result with fixed-length string

    XMLWordPrintableJSON

Details

    Description

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

      @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");
  }

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4647 INTERSECT returns wrong results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4648 Except returns wrong results

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4903 Avatica pads values returned from values-clause to same length

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4667 INNER join returns empty set

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4710 In the special scenario of the case when statement, the constant RexNode fails to be parsed.

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-762 Trailing spaces on character literals

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-1199 Incorrect trimming of CHAR when performing cast to VARCHAR

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2311 case when returns redundant white space

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4888 The type of generated search argument literal is wrong if the literal types of RelBuilder.in are different and compatible

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. CALCITE-2321 The type of a union of CHAR columns of different lengths should be VARCHAR (based on a conformance setting)

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4493 Postgres/Mysql String Literal Equality Creates incorrect results.

          • Major - Major loss of function.
          • Open
          links to

          Web Link GitHub Pull Request #4028

          Activity

            People

              mbudiu Mihai Budiu
              rkondakov Roman Kondakov
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: