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

GREATEST should return NULL but returns date.

    XMLWordPrintable

Details

    • Unexpected results

    Description

      Documentation says GREATEST() returns NULL if any argument is NULL.

      Test Query: 

      SELECT 
       DATE(''),
      		 
       
      		 
       GREATEST(DATE(''), CURDATE()),
      		 
       GREATEST(NULL, CURDATE()),
      		 
       
      		 
       LEAST(DATE(''), CURDATE()),
      		 
       LEAST(NULL, CURDATE())

      All selects in this query should return NULL, as DATE('') returns NULL. But the query GREATEST(DATE(''), CURDATE()) returns the current date.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17329 Inconsistency of NULL date value conversion to zero date in comparison context

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21034 GREATEST() and LEAST() malfunction for NULL

          • Major - Major loss of function.
          • Closed

          Activity

            People

              bar Alexander Barkov
              lbuchs Lukas Buchs
              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.