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

WHERE does not apply

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 5.3.12, 5.5.40, 10.0.12, 10.0.14
    • 5.5.43, 10.0.18
    • Optimizer
    • None
    • 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

              sanja Oleksandr Byelkin
              erkules erkan yanar
              Votes:
              3 Vote for this issue
              Watchers:
              10 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.