PS Can you see what support for bit operations is in other databases? It would be quite straightforward to add new functions, less easy to add “&” or “|” or “~”.
> On Jun 9, 2018, at 6:47 PM, Julian Hyde <[email protected]> wrote: > > 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 <[email protected]> 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! >
