Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5167

JOIN: support on clause filter for table which is not involved in a join

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 22.08.1
    • None
    • None
    • 2021-17

    Attachments

      Issue Links

        Activity

          Build verified: 22.08-1 (#5290)

          Reproduced the issue in 6.4.2-1
          Verified the fix in 22.08-1

          MariaDB [mytest]> select * from t1 left join t2 on (t1.a = t2.a) left join t3 on (t1.b = t3.b and t2.a > 1);
          +------+------+------+------+------+------+
          | a    | b    | a    | b    | a    | b    |
          +------+------+------+------+------+------+
          |    1 |    3 |    1 |    2 | NULL | NULL |
          |    2 |    3 |    2 |    4 |    2 |    3 |
          |    3 |    4 | NULL | NULL | NULL | NULL |
          +------+------+------+------+------+------+
          3 rows in set (0.086 sec)
          

          Also executed MTR test suites and verified results against MariaDB server

          dleeyh Daniel Lee (Inactive) added a comment - Build verified: 22.08-1 (#5290) Reproduced the issue in 6.4.2-1 Verified the fix in 22.08-1 MariaDB [mytest]> select * from t1 left join t2 on (t1.a = t2.a) left join t3 on (t1.b = t3.b and t2.a > 1); +------+------+------+------+------+------+ | a | b | a | b | a | b | +------+------+------+------+------+------+ | 1 | 3 | 1 | 2 | NULL | NULL | | 2 | 3 | 2 | 4 | 2 | 3 | | 3 | 4 | NULL | NULL | NULL | NULL | +------+------+------+------+------+------+ 3 rows in set (0.086 sec) Also executed MTR test suites and verified results against MariaDB server

          People

            denis0x0D Denis Khalikov (Inactive)
            alexey.vorovich alexey vorovich (Inactive)
            Roman Roman
            Daniel Lee Daniel Lee (Inactive)
            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.