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

Decimal multiplication loses precision for no good reason

    XMLWordPrintable

Details

    Description

      MariaDB [test]> select 0.00000000000000000000000001035 * 100000000000000000000000000000000000000000000;
      		 
      +---------------------------------------------------------------------------------+
      		 
      | 0.00000000000000000000000001035 * 100000000000000000000000000000000000000000000 |
      		 
      +---------------------------------------------------------------------------------+
      		 
      |                               1000000000000000000.00000000000000000000000000000 |
      		 
      +---------------------------------------------------------------------------------+

      Same result on MySQL.
      Both values are within DECIMAL range, so there should be no loss.

      PostgeSQL returns the precise result:

      postgres=# select 0.000000000000000000000000001035 * 100000000000000000000000000000000000000000000000000;
      		 
                              ?column?                         
      ---------------------------------------------------------
      		 
       103500000000000000000000.000000000000000000000000000000
      		 
      (1 row)

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-6841 test decimal math

          • Major - Major loss of function.
          • Open
          links to

          Web Link Bug #76580 - Decimal multiplication loses precision for no good reason

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.