Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-22295

Sql. Allow comparable types for common columns in NATURAL / USING join conditions

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • sql

    Description

      As type coercion for NATURAL/USING join conditions is not invoked, such queries produce incorrect results when column types of common columns do not match.

      Attachments

        Issue Links

          is caused by

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-6413 SqlValidator does not invoke TypeCoercionImpl::binaryComparisonCoercion for both NATURAL and USING join conditions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-23042 Sql. Forbid implicit casts between different type families

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              xtern Pavel Pereslegin
              mzhuravkov Maksim Zhuravkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: