Hibernate version:
1.2.0.3001

Name and version of the database you are using:
MySQL 5.0.15

I've made a custom Nhibernate Dialect which inherits the MySQLDialect, because I want support for bitwise operators (its similar to what the guy in this topic is doing: http://forum.hibernate.org/viewtopic.php?t=940978). I register the custom SQLFunction like this:



MySQLBitwiseAndSQLFunction is a class which implements ISQLFunction

When reading out the Functions (by using SessionFactory.Dialect.Functions.Values) I can see that my function is added. However, when I execute a query with my custom function in it, Nhibernate won't transform my function.

When executing the following (the BitWiseAnd doesn't do anything special at the moment, it only returns a fixed string in the Render method for testing):



No errors occur, but it seems that Nhibernate just trows the the BitWiseAnd(1) away.

In the following topic I've found that this isn't supported until CR1
http://forum.hibernate.org/viewtopic.php?t=970419, However I'm using the CR1 so this shouldn't be the problem.



Can somebody please point me in the right direction?

Thanks in advance!

No, you can't add new functions, the parser is not designed to handle that.

Hi Sergey, thanx for your reply. So do you mean that the current version isn't ready for it yet (even CR1) ?

Is there any other solution to make bitwise operators work in NHibernate, beside using plain SQL? I'm working on this all day and I'm very desperate that I even would be very happy with the dirtiest workaround. ;)

Any clues? What alternatives are there for avoiding bitmask values?