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

Syntax error when using FULL JOIN with table aliases

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.10
    • N/A
    • Parser
    • None
    • *nix

    Description

      A SELECT query that uses a FULL JOIN fails with a syntax error if you use table aliases in the query.

      Code to reproduce:

      create table a(aa int);
      create table b(bb int);
      insert into a values (12);
      insert into b values (12);

      /* Returns one row. */
      select * from a full join b on aa = bb;

      /* Fails with "check the manual that corresponds to your MariaDB server version for the right syntax to use near 'full join b b_alias on aa = bb' at line 1" */
      select * from a a_alias full join b b_alias on aa = bb;

      Attachments

        Activity

          People

            serg Sergei Golubchik
            pgacv2 Pedro G. Acevedo
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.