Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1030

In some situations a RETURNS NULL ON NULL function is called when one ot its parameters is NULL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.6.1.0
    • Fix Version/s: 10.6.1.0
    • Component/s: SQL
    • Labels:
      None
    • Urgency:
      Normal
    • Issue & fix info:
      Repro attached
    • Bug behavior facts:
      Wrong query result

      Description

      The NULL argument to the function has to come from another function and that function's Java method has to return a Java object type corresponding to a fixed length SQL type, such as DATE, TIME and TIMESTAMP.

      Will attach repro scripts.

        Attachments

        1. derby479.sql
          0.9 kB
          Daniel John Debrunner
        2. derby479.java
          0.8 kB
          Daniel John Debrunner
        3. derby-1030-01-aa-disableOptimization.diff
          2 kB
          Rick Hillegas

          Issue Links

            Activity

              People

              • Assignee:
                rhillegas Rick Hillegas
                Reporter:
                djd Daniel John Debrunner
              • Votes:
                1 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: