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

Left Outer Join creates Cartesian join

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.16
    • N/A
    • Parser
    • Linux Redhat 2.6.32-504.12.2.el6.x86_64 IBM Server 96GB RAM

    Description

      I created an SQL using a Left Join with resulted in a cartesian join as a result.
      The format is

      select 
      a.col1, a.col2, b.col1, b.col1, b.col3, b.col4 
      from tablea a 
      left outer join tableb b on b.col4 and b.col1 
      where b.col5 < current_date()

      The erroneously placed and (should be an = ) creates a cartesian join. Some other database technology calls a parser error on this.
      In the case of the system, it happened in on column in the join condition is a primary key and the other is the lead column of a multi-column index of a primary key

      Attachments

        Activity

          People

            serg Sergei Golubchik
            Meerkat63 Peter McLarty
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.