[CAY-1693] Initial support for bitwise operators in Expression and SelectQuery - MySQL

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1M3
• Fix Version/s: 3.1B1
• Component/s: Core Library
• Assignee: Andrus Adamchik
• Reporter: Andrus Adamchik
• Created: 04/Apr/12 17:55
• Updated: 04/Apr/12 19:40
• Resolved: 04/Apr/12 19:40

Description

I need to use some bitmasks as query criteria. It appears that most DBs support bitwise operations:

http://en.wikipedia.org/wiki/Bitwise_operation
http://dev.mysql.com/doc/refman/5.1/en/bit-functions.html
http://www.postgresql.org/docs/8.4/static/functions-math.html
http://hsqldb.org/doc/guide/builtinfunctions-chapt.html#builtin_functions_numeric_sect

I am going to add support in Expressions, SelectQueries and the underlying stack for &, ~, |, ^... For now a very basic implementation with no parser support, no ExpressionFactory support, and probably just MySQL adapter support. It will stay under the radar, hopefully useful to people who need them until we have the time to expand it to cover all DBs and all use cases.