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

[PATCH] STRAIGHT_JOIN does not support USING(), NATURAL

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.1, 5.5.30
    • 10.0.4
    • None

    Description

      STRAIGHT_JOIN should be usable in every context where a regular JOIN can be used, but does not support:

      SELECT ... FROM t1 STRAIGHT_JOIN t2 USING(id);

      or

      SELECT ... FROM t1 NATURAL STRAIGHT_JOIN t2;

      yet.

      See also http://bugs.mysql.com/35268

      Attachments

        Activity

          People

            monty Michael Widenius
            hholzgra Hartmut Holzgraefe
            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.