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

Incorrect results are returned with NULLIF()

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 5.5.35, 10.0.8
    • 5.5.38, 10.0.11
    • None
    • 10.0.8-MariaDB-1~precise mariadb.org binary distribution (64Bit Ubuntu 12.04)

      5.5.35-MariaDB-log MariaDB Server (64Bit Centos 6.5)


    Description

      Hi

      the attached SQL script shows the problem.

      Results in "bad" column, of the last SQL statement, differ from "good" column results, while "bad_len" and "good_len" are the same.

      Cast is used for "good" results. No cast for "bad".

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Alexander Barkov made transition -
          Open In Progress
          		68d 4h 31m 1
          Elena Stepanova made transition -
          In Progress Closed
          		109d 23h 42m 1

          People

            bar Alexander Barkov
            s4uliu5 Saulius Gurklys
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.