EJBQL resolution: OpenBase limitations
--------------------------------------
Key: CAY-820
URL: https://issues.apache.org/cayenne/browse/CAY-820
Project: Cayenne
Issue Type: Improvement
Components: Cayenne Core Library
Affects Versions: 3.0
Reporter: Andrus Adamchik
Assignee: Andrus Adamchik
Priority: Minor
Fix For: 3.0
Listing the limitations of the OpenBase DB that make EJBQL support incomplete. I am not sure if we need to fix them on our end (still I am trying to follow up on it with OpenBase, maybe they can fix it). Currently the tests for these conditions are suppressed via special AccessStackAdapter methods.
1. Having a value on the left-hand site of the comparison in the WHERE clause.
TestCase: DataContextEJBQLQueryTest.testSelectFromWhereEqualReverseOrder
select a from Artist a where 'AA2' = a.artistName
We can theoretically fix it on our end, b reversing the expressions... But we can't make it work all the way. E.g. 'AA2' = 'AA2' should work per EJBQL, but there's no valid OpenBase syntax to do the same as far as I know.
2. Returning no rows for MIN/MAX aggregate queries when WHERE clause matches no rows.
TestCase: DataContextEJBQLQueryTest.testSelectAggregateNull
"select max(p.estimatedPrice), sum(p.estimatedPrice) "
+ "from Painting p WHERE p.paintingTitle = 'NONEXISTENT'"
All DB's return a single row with NULL values in it. OpenBase returns no rows.
-- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
This archive was generated by hypermail 2.0.0 : Sun Jul 01 2007 - 09:35:52 EDT