ejb sql [select * from where A & 1]

Question

Hello,

i will use a query like this in ejb ql:

Select * from whe A&1;

But i have the following error:

line 1, column 171: unexpected char [&].

How can i use this operator to check the bits in a row?

Answer 1

use BIT_AND function

Answer 2

You need to add a sql function to the dialect, see https://forum.hibernate.org/viewtopic.php?t=940978&highlight=bitwise .