You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andrus Adamchik (Updated) (JIRA)" <ji...@apache.org> on 2012/04/04 21:28:22 UTC
[jira] [Updated] (CAY-1693) Initial support for bitwise operators
in Expression and SelectQuery - MySQL
[ https://issues.apache.org/jira/browse/CAY-1693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrus Adamchik updated CAY-1693:
---------------------------------
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.
was:
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
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.
Summary: Initial support for bitwise operators in Expression and SelectQuery - MySQL (was: Initial support for bitwise operators in Expression and SelectQuery)
> Initial support for bitwise operators in Expression and SelectQuery - MySQL
> ---------------------------------------------------------------------------
>
> Key: CAY-1693
> URL: https://issues.apache.org/jira/browse/CAY-1693
> Project: Cayenne
> Issue Type: Task
> Components: Core Library
> Affects Versions: 3.1M3
> Reporter: Andrus Adamchik
> Assignee: Andrus Adamchik
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira