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

True DECIMAL support for bitwise operators like &

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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

            Assignee:
            ralf.gebhardt@mariadb.com Ralf Gebhardt
            Reporter:
            hholzgra Hartmut Holzgraefe
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration