[jira] Updated: (DERBY-2500) Assertion failure preparing query with AND and OR in where clause

["A B (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-2500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

A B updated DERBY-2500:
-----------------------

    Attachment: d2500_v3.patch

Committed d2500_v3.patch, which is the same as the _v2 patch except that the second new test case was corrected so that, in the absence of the fix for this issue, the query would actually return incorrect results.

Committed with svn # 525925:

  URL: http://svn.apache.org/viewvc?view=rev&rev=525925

> Assertion failure preparing query with AND and OR in where clause
> -----------------------------------------------------------------
>
>                 Key: DERBY-2500
>                 URL: https://issues.apache.org/jira/browse/DERBY-2500
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.3.0.0
>            Reporter: Andrew McIntyre
>         Assigned To: A B
>         Attachments: d2500_v1.patch, d2500_v1.stat, d2500_v2.patch, d2500_v3.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.