Expressions in-memory automatic type convertion
-----------------------------------------------
Key: CAY-1105
URL: https://issues.apache.org/cayenne/browse/CAY-1105
Project: Cayenne
Issue Type: Improvement
Components: Cayenne Core Library
Affects Versions: 3.0
Reporter: Andrey Razumovsky
Assignee: Andrus Adamchik
Attachments: patch-test-Expr.txt
The root of the problem is difference in behavior of expressions on server (using queries) and in-memory (using Expression.match(...). All DBMS I know support automatic type convertion, i.e. if I write
SELECT * FROM a WHERE intProperty='1'
everything will go OK.
So, if I write an expression like [note quotes at 1!]
ExpressionFactory.greaterExp("intProperty", "1")
it will go normally with a query, but will result in an exception if I try to invoke match(...).
I suggest to make the behavior similiar and therefore implement automatic type convertion on expressions. I've submitted a patch with a number of tests, which all fail. I think the must all succeed.
Comments and other expression improvement suggestions are welcomed
-- 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 : Wed Sep 10 2008 - 09:14:49 EDT