BIt operations are not standard SQL. Are there any databases that support them? (I’m guessing MySQL, which at one point seemed to have a mission to convert SQL into C, even down to using int instead of boolean.)
We could perhaps add support for bit operations, but I would not like to add an ‘&’ operator. It would be too disruptive to the parser. Maybe it could go into Babel. Julian > On Jun 9, 2018, at 5:38 PM, 18390992640 <m1839099264...@163.com> wrote: > > Hello EveryOne ! > I have seed calcite SqlKind.java source code, find that it hasn't bit > operation. so I want to ask why calcite don't support bit operation. for > example, follow Query statement, it not support. > select col_a, col_b from table_1 where (col_a & col_b) > 10. > if I want to extend calcite to supoort bit operation, how difficulty > may be? > who knwo this, please give me a help. thanks very mush!