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

Left Outer Join creates Cartesian join

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.0.16
    • Fix Version/s: N/A
    • Component/s: Parser
    • Labels:
    • Environment:
      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

            Assignee:
            serg Sergei Golubchik
            Reporter:
            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.