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

Assertion failure preparing query with AND and OR in where clause

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.3.1.4
    • 10.3.1.4
    • SQL
    • None

    Description

      See commented out test in DistinctTest, DistinctTest.testResultSetInOrderWhenUsingIndex.

      The actual assert is:

      ASSERT FAILED Found IN-list probing (NLR.LUSERNAME = <expr>) while generating HASH join, which should not happen.

      I was able to simplify the query a little:

      SELECT DISTINCT nb.name AS name, nb.summary AS summary FROM netbutton1 nb, netbuttonlibraryrole1 nlr, library_netbutton ln WHERE nlr.netbuttonlibrary_id = ln.netbuttonlibrary_id AND (nlr.lusername = ? OR nlr.lusername =?)

      Removing nlr.netbuttonlibrary_id = ln.netbuttonlibrary_id clause but leaving the 'nb.lname = ln.lname' in front of the AND did not reproduce the problem.

      Attachments

        1. d2500_v1.patch
          7 kB
          A B
        2. d2500_v1.stat
          0.3 kB
          A B
        3. d2500_v2.patch
          8 kB
          A B
        4. d2500_v3.patch
          8 kB
          A B

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-47 Some possible improvements to IN optimization

          • Major - Major loss of function.
          • Closed

          Activity

            People

              army A B
              fuzzylogic Samuel Andrew McIntyre
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: