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

Bad result for NOT NOT STRCMP('a','b') and NOT NOT NULLIF(2,3)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5.40, 10.0.14, 5.3.13
    • Fix Version/s: 10.0.15
    • Component/s: Character Sets
    • Labels:
      None

      Description

      SELECT NOT NOT STRCMP('a','b');

      returns

      +-------------------------+
      | NOT NOT STRCMP('a','b') |
      +-------------------------+
      |                      -1 |
      +-------------------------+
      1 row in set (0.00 sec)

      The expected result is 1.

      The same problem is observed with NOT NOT NULLIF(2,3).

      mysql> SELECT NOT NOT NULLIF(2,3);
      +---------------------+
      | NOT NOT NULLIF(2,3) |
      +---------------------+
      |                   2 |
      +---------------------+
      1 row in set (0.00 sec)

      The expected result is 1.

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: