Issue Details (XML | Word | Printable)

Key: NUCRDBMS-530
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Andy Jefferson
Reporter: Guido Anzuoni
Votes: 0
Watchers: 0
Operations

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