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

LP:737474 - Wrong result with DAY(COALESCE(NULL)) in 5.1-micro

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      Not repeatable in mysql-5.1

      DAY(NULL) is NULL and COALESCE(NULL) is NULL, so DAY(COALESCE(NULL)) should also be NULL. However, 5.1-micro returns 0 instead.

      MySQL [test]> select DAY(COALESCE(NULL));
      ---------------------

      DAY(COALESCE(NULL))

      ---------------------

      0

      ---------------------
      1 row in set (0.00 sec)

      Attachments

        Activity

          People

            serg Sergei Golubchik
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.