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