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

NVL2's return data type should be nullable if and only if at least one of the second and third parameters are nullable

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.39.0
    • None

    Description

      The Expression:

      nvl2(NULL, 'abc', NULL);

      should return null with a nullable type.

      Attachments

        Issue Links

          split from

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-6711 Functions whose output value can be null should return a nullable type

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

          Web Link GitHub Pull Request #4071

          Activity

            People

              Unassigned Unassigned
              nobigo xiong duan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: