Derby
  1. Derby
  2. DERBY-5369

Restricted Table Function support should pass NOT EQUAL restrictions to initScan

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.3.0
    • Fix Version/s: 10.7.1.4, 10.8.3.0
    • Component/s: SQL
    • Labels:
    • Urgency:
      Urgent
    • Bug behavior facts:
      Performance

      Description

      Restricted Table Function support should pass NOT EQUAL restrictions to initScan. Currently any "!=" or "<>" constraints on the SQL used in the WHERE clause of a SELECT on a Restricted Table Funtion are not passed to the initScan method. These can be useful depending on how the Restricted Table Function is implemented.

      1. derby-5369.diff
        2 kB
        Brett Bergquist
      2. derby-5369-01-aa-inequalityOperator.diff
        7 kB
        Rick Hillegas

        Issue Links

          Activity

          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12625136 ] Default workflow, editable Closed status [ 12802133 ]
          Kathey Marsden made changes -
          Fix Version/s 10.8.3.0 [ 12323456 ]
          Fix Version/s 10.8.2.3 [ 12318540 ]
          Mamta A. Satoor made changes -
          Link This issue is required by DERBY-5654 [ DERBY-5654 ]
          Mamta A. Satoor made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Mamta A. Satoor made changes -
          Assignee Mamta A. Satoor [ mamtas ] Rick Hillegas [ rhillegas ]
          Mamta A. Satoor made changes -
          Issue Type Bug [ 1 ] Improvement [ 4 ]
          Mamta A. Satoor made changes -
          Fix Version/s 10.7.1.4 [ 12315902 ]
          Mamta A. Satoor made changes -
          Assignee Rick Hillegas [ rhillegas ] Mamta A. Satoor [ mamtas ]
          Kathey Marsden made changes -
          Resolution Fixed [ 1 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          Kathey Marsden made changes -
          Link This issue is required by DERBY-5654 [ DERBY-5654 ]
          Kathey Marsden made changes -
          Affects Version/s 10.5.3.0 [ 12314117 ]
          Affects Version/s 10.8.1.2 [ 12316362 ]
          Kathey Marsden made changes -
          Fix Version/s 10.8.2.3 [ 12318540 ]
          Kathey Marsden made changes -
          Assignee Rick Hillegas [ rhillegas ]
          Rick Hillegas made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-5372 [ DERBY-5372 ]
          Brett Bergquist made changes -
          Field Original Value New Value
          Attachment derby-5369.diff [ 12488902 ]
          Brett Bergquist created issue -

            People

            • Assignee:
              Rick Hillegas
              Reporter:
              Brett Bergquist
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development