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

Incorrect results are returned with NULLIF()

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.5.35, 10.0.8
    • Fix Version/s: 5.5.38, 10.0.11
    • Component/s: None
    • Labels:
    • Environment:
      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

            People

            • Assignee:
              bar Alexander Barkov
              Reporter:
              s4uliu5 Saulius Gurklys
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: