[
https://issues.apache.org/jira/browse/DERBY-2500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
A B reassigned DERBY-2500:
--------------------------
Assignee: A B
> 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
>
> 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.
