[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-160) New query parser does not allow bitwise operations

[Daniele G. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-160?page=comments#action_23162 ] 

Daniele Gariboldi commented on HHH-160:
---------------------------------------

I need this function too (masking permission and quering for permitted objects in one shot).
Why it can't be standardize through all the dialect ? It's just a scalar function, could be andbit(a,b) and so on (orbit , xorbit).
bit_or is another function in postgresql, of type aggregate, thus my covention.

> New query parser does not allow bitwise operations
> --------------------------------------------------
>
>          Key: HHH-160
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-160
>      Project: Hibernate3
>         Type: Improvement

>   Components: core
>     Versions: 3.0 rc 1
>  Environment: Hibernate 3.0 rc1, MySQL
>     Reporter: Markus Jessenitschnig
>     Priority: Minor

>
>
> The new query parser does not allow bitwise operations like bitwise-and and bitwise-or. 
> Example:
> SELECT FIRSTNAME, SURNAME FROM EMPLOYEE WHERE (STATUS & 1) > 0
> The Exception is:
> org.hibernate.QueryException: unexpected char: '&'

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira