[CAY-1105] Expressions in-memory automatic type convertion

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0
• Fix Version/s: Undefined future
• Component/s: Core Library
• Assignee: Andrus Adamchik
• Reporter: Andrey Razumovsky
• Created: 10/Sep/08 13:12
• Updated: 07/Feb/17 12:50

Description

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