DataNucleus JIRA is now in read-only mode. Raise any new issues in GitHub against the plugin that it applies to. DataNucleus JIRA will remain for the foreseeable future but will eventually be discontinued
Issue Details (XML | Word | Printable)

Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Andy Jefferson
Reporter: Guido Anzuoni
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

If subquery is not precompilable, need to mark outer query as not precompilable

Created: 26/Apr/11 04:35 PM   Updated: 17/Jun/11 05:09 PM   Resolved: 05/Jun/11 09:38 PM
Component/s: Queries
Affects Version/s: 3.0.0.m3
Fix Version/s: 3.0.0.m5

File Attachments: 1. Text File testsubq-like.patch (2 kB)

 Description  « Hide
A subquery containing a LIKE expression with a parameter is badly compiled into SQL if the corresponding parameter is not set first but after another param.

Sort Order: Ascending order - Click to sort in descending order
Guido Anzuoni added a comment - 26/Apr/11 04:36 PM
The attached patch adds a test case to test.jpa.general

Guido Anzuoni added a comment - 26/Apr/11 04:38 PM
It has nothing to do with caching as erroneously stated in NUCCORE-701

Andy Jefferson added a comment - 05/Jun/11 09:38 PM
SVN trunk works on this