Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1663

Implicit cast to variable width type does not work in join conditions

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.7.0
    • Component/s: None
    • Labels:
      None

      Description

      Currently if the two sides of a join condition are of different types then we implicitly add a cast on one side so that the join condition works as expected. However when we apply a cast to variable width type (varchar or varbinary) we don't include the length parameter as part of the arguments. This causes the function resolver to not match against any function implementation and return a NULL expression.

        Attachments

        1. DRILL-1663.patch
          14 kB
          Mehant Baid

          Activity

            People

            • Assignee:
              mehant Mehant Baid
              Reporter:
              mehant Mehant Baid
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: