How to use bitwise operators in HQL?

Question

In HQL, how can I use bitwise operators? I want the resulting SQL query to look something like

SELECT RoleId, RoleName, RolePerms WHERE (RolePerms & @Parameter) = @Parameter

However, writing this HQL

select from Role where (RolePerms & :param) = :param

gives me this error: NHibernate.Hql.Ast.ANTLR.QuerySyntaxException: Exception of type 'Antlr.Runtime.NoViableAltException' was thrown.

Answer 1

From section 13.8 of the NHibernate documentation, HQL does not support these bitwise operators. You'd have to revert to native SQL (see section 15).

Answer 2

According to the NHibernate Jira it looks like this should be working as of 2.1.0Beta2, http://nhjira.koah.net/browse/NH-1192.

Answer 3

I found a solution to this. Writing the HQL this way works:

select r from Role r where (r.Permissions & :param) > 0