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.

Guido Anzuoni added a comment - 26/Apr/11 04:36 PM
The attached patch adds a test case to test.jpa.general

Guido Anzuoni made changes - 26/Apr/11 04:36 PM
Field Original Value New Value
Attachment testsubq-like.patch [ 11438 ]
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 made changes - 05/Jun/11 09:35 PM
Project DataNucleus API JPA [ 10171 ] DataNucleus Store RDBMS [ 10144 ]
Key NUCJPA-129 NUCRDBMS-530
Affects Version/s 3.0.0.m3 [ 11191 ]
Affects Version/s 3.0.0.m3 [ 11193 ]
Andy Jefferson made changes - 05/Jun/11 09:36 PM
Summary Bad SQL generation if subquery contains LIKE with parameter and it is not set first If subquery is not precompilable, need to mark outer query as not precompilable
Component/s Queries [ 10142 ]
Andy Jefferson added a comment - 05/Jun/11 09:38 PM
SVN trunk works on this

Andy Jefferson made changes - 05/Jun/11 09:38 PM
Status Open [ 1 ] Resolved [ 5 ]
Assignee Andy Jefferson [ andy ]
Fix Version/s 3.0.0.m5 [ 11243 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 17/Jun/11 05:09 PM
Status Resolved [ 5 ] Closed [ 6 ]