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

GREATEST return value truncated (data corruption)

    XMLWordPrintable

Details

    Description

      SELECT GREATEST(1=1, CAST('2026-02-29' AS BINARY));
      		 
      -- MariaDB: '2026'          <-- value truncated to 4 bytes
      		 
      -- MySQL:   '2026-02-29'    <-- complete

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4655 Difference in how GREATEST and COALESCE process arguments

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          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-40982 GREATEST/LEAST mixed string+bigint loses precision

          • 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.