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

LP:965950 - left join lead to crash (in case of converting it to inner join)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • None
    • None
    • None

    Description

      This test suite crashes:

      create table t1 (a int, b int);
      insert into t1 values (1,1),(2,2);
      create table t2 (a int, b int);
      insert into t2 values (1,1),(2,2);

      select t1.b, t2.b from t1 left join t2 on (t2.a=t1.a) where t2.a > 5;

      drop table t1, t2;

      Attachments

        Activity

          People

            igor Igor Babaev (Inactive)
            sanja Oleksandr Byelkin
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.