Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.3.12, 5.5.40, 10.0.12, 10.0.14
    • Fix Version/s: 5.5.43, 10.0.18
    • Component/s: Optimizer
    • Labels:
      None
    • Environment:
      Ubunut/LXC

      Description

      Thx to Andreas Kretschmer for pointing out.

      create table t1 (id int);
      create table t2 (id int);
      insert into t1 values(1),(2),(3);
      insert into t2 values(4),(5),(6)
      select x.id, message from (select id from t1) x left join
      (select id, 1 as message from t2) y on x.id=y.id
      where coalesce(message,0) <> 0;
      # 5.6.19-0ubuntu0.14.04.1
      Empty set (0,01 sec)
      # 10.0.12-MariaDB-1~trusty-wsrep-log
      +------+---------+
      | id   | message |
      +------+---------+
      |    1 |    NULL |
      |    2 |    NULL |
      |    3 |    NULL |
      +------+---------+

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sanja Oleksandr Byelkin
                Reporter:
                erkules erkan yanar
              • Votes:
                3 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: