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

Type inference when converting IN clause to semijoin

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.0-incubating, 1.3.0-incubating, 1.2.0-incubating, 1.1.0-incubating
    • Fix Version/s: 1.5.0
    • Component/s: core
    • Labels:
      None

      Description

      I hit an issue where using an IN clause of int literals would work properly when compared against a BIGINT column when the IN clause had less than 20 values, but would fail when processing more than 20 values. I traced the issue to the way target row types are handled inside of the code that converts the IN clause into a semijoin.

        Attachments

          Activity

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              jwills Josh Wills
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: