Issue Details (XML | Word | Printable)

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

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

Derby < 10.6 has to use CROSS JOIN as "INNER JOIN ... ON 1=1" or is totally buggy

Created: 29/Apr/10 09:41 AM   Updated: 24/May/10 03:43 PM   Resolved: 29/Apr/10 09:43 AM
Component/s: Queries
Affects Version/s: 2.0.0.release, 2.0.1, 2.0.2, 2.0.3, 2.0.4, 2.1.0.m1, 2.1.0.m2
Fix Version/s: 2.1.0.m3


 Description  « Hide
Need to change CROSS JOIN syntax used for Derby in versions prior to 10.6 to be
INNER JOIN tbl ON 1=1
otherwise it falls apart

Andy Jefferson added a comment - 29/Apr/10 09:43 AM
SVN trunk handles this now

Andy Jefferson made changes - 29/Apr/10 09:43 AM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 24/May/10 03:43 PM
Status Resolved [ 5 ] Closed [ 6 ]