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

Table aliases not functioning correctly in OUTER JOIN ON condition

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.0.25, 10.0.29
    • N/A
    • OTHER
    • OpenSUSE 13.2, RH ES6

    Description

      Once an alias is created for a table, the table should only be referred to by its alias.

      in 10.0.14, the following statement works fine:

      SELECT [...]
      FROM Table1
      LEFT OUTER JOIN Table2 Alias2 ON Table1.ColumnN = Alias2.ColumnN

      However, on 10.0.25 and 10.0.29, the statement does not work and has to be changed to:

      SELECT [...]
      FROM Table1
      LEFT OUTER JOIN Table2 Alias2 ON Table1.ColumnN = Table2.ColumnN

      I can find nothing in the change log between 10.0.14 and 10.0.25 to indicate that this is intentional.

      The database on OpenSUSE is using InnoDB and I believe that the database on ES6 is MyISAM.

      Attachments

        Activity

          People

            Unassigned Unassigned
            jona2402 John Ellin
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.