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: Won't Fix
Priority: Major Major
Assignee: Unassigned
Reporter: Mac Yang
Votes: 0
Watchers: 1

If you were logged in you would be able to see more operations.
DataNucleus JDO Query Processor

Nested substring does not work with MySQL

Created: 12/Feb/11 12:08 AM   Updated: 29/Mar/11 05:23 PM   Resolved: 12/Feb/11 08:44 AM
Component/s: None
Affects Version/s: None
Fix Version/s: None

File Attachments: 1. Text File NUCJDOQUERY-4.1.patch.txt (1 kB)
2. Text File NUCJDOQUERY-4.test.patch.txt (3 kB)

Environment: Linux, JDK 1.6

Forum Thread URL:,6533
Datastore: MySQL

 Description  « Hide
Nested substring call fails when running against MySQL datastore.

Please refer to the forum thread for more details,

Mac Yang added a comment - 12/Feb/11 12:26 AM
Modify samples.jdo.tutorial to demonstrate the issue

Mac Yang made changes - 12/Feb/11 12:26 AM
Field Original Value New Value
Attachment NUCJDOQUERY-4.test.patch.txt [ 11353 ]
Mac Yang made changes - 12/Feb/11 12:27 AM
Attachment NUCJDOQUERY-4.1.patch.txt [ 11354 ]
Mac Yang added a comment - 12/Feb/11 12:30 AM
Attached two files. Both of them are for the 2.0 branch.

NUCJDOQUERY-4.test.patch.txt will modify samples.jdo.tutorial to demonstrate the issue.
NUCJDOQUERY-4.1.patch.txt contains the first draft of the fix.

Andy Jefferson added a comment - 12/Feb/11 08:44 AM
FYI1. Project "NUCJDOQUERY" is for JDO Typesafe queries; part of JDO3.1. This is nothing to do with it.

FYI2. A test is a self-contained zip with the source, not a patch to some arbitrary project.

You have some issue with a *legacy* JDOQL mechanism in RDBMS. That is no longer present in SVN (was removed totally in 2.2), why it was termed legacy even back in 2.0. Consequently there is no interest here in fixing something that isn't present. Anything prior to 2.2 are no longer supported and there will be no further releases hence no point in even thinking of applying the patch, thanks anyway.

I'll leave the issue in JIRA in case someone else who won't upgrade to a recent version wants to do apply it (rather than just use "JDOQL2" which is present in those releases).

Andy Jefferson made changes - 12/Feb/11 08:44 AM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Won't Fix [ 2 ]
devaraj das added a comment - 15/Feb/11 10:38 AM
Hey Andy, could you please have a look at the patch from the point of view of correctness. Since we are basing the release of a product on the 2.0 branch of JDO, hence the ask.

Andy Jefferson made changes - 29/Mar/11 05:23 PM
Status Resolved [ 5 ] Closed [ 6 ]