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

GREATEST/LEAST mixed string+bigint loses precision

    XMLWordPrintable

Details

    Description

      SELECT GREATEST('0', 9223372036854775807);
      		 
      -- MariaDB: 9.223372036854776e18   <-- coerced to DOUBLE, precision lost
      		 
      -- MySQL:   9223372036854775807    <-- BIGINT precision preserved
      		 
      SELECT GREATEST('0', 12345678901234567890);
      		 
      -- MariaDB: 1.2345678901234567e19  vs MySQL: 12345678901234567890

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39133 Inconsistent Results Due to Engine Difference and BINARY/LEAST Handling

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40981 GREATEST return value truncated (data corruption)

          • Major - Major loss of function.
          • Confirmed

          Activity

            People

              psergei Sergei Petrunia
              chunlingqin chunlingqin
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.