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)

Key: NUCRDBMS-352
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

JDOQL2 : Result clause with parameter which is null results in invalid query

Created: 31/Mar/10 08:15 AM   Updated: 03/Apr/10 10:44 AM   Resolved: 31/Mar/10 08:25 AM
Component/s: Queries
Affects Version/s: None
Fix Version/s: 2.1.0.m1


 Description  « Hide
SELECT p FROM MyClass

and execute with null value of "p" gives

SELECT <null> FROM MYTABLE

without the value of the parameter being set!

Should generate
SELECT NULL FROM MYTABLE

PS. JDOQL legacy fails completely on this

Andy Jefferson added a comment - 31/Mar/10 08:25 AM
SVN trunk now generates this correctly.

Andy Jefferson made changes - 31/Mar/10 08:25 AM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 03/Apr/10 10:44 AM
Status Resolved [ 5 ] Closed [ 6 ]