Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24067

True DECIMAL support for bitwise operators like &

    XMLWordPrintable

Details

    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 )

      Attachments

        Activity

          People

            Unassigned Unassigned
            hholzgra Hartmut Holzgraefe
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.