Details
-
New Feature
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
Right now only the most basic math operators directly support DECIMAL parameters without prior conversion to BIGINT or DOUBLE.
The bitwise operators like &, | and ^ are among those that first convert DECIMAL parameters to BIGINT, so they do not really work for DECIMAL input with more than 19 decimal digits.
Oracle "bitand" function for example works in a range of 128 bits, or about 38 decimal digits ( https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions014.htm#SQLRF00612 )