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

JOIN clause push-down for CONNECT JDBC

    XMLWordPrintable

Details

    Description

      I noticed that in 10.3.x series there is apparently new JOIN push-down for engines to use.
      See MDEV-7698. Hopefully his can be used for CONNECT JDBC.

      It would be massively helpful if I had 3 CONNECT JDBC tables and I issued a SELECT joining those three tables with a WHERE clause on only one of the tables (a very common use case for us) if it could push down the JOIN in addition to the WHERE clause... at least in special cases where all the tables are CONNECT.

      Right now, if each table has 500,000 rows and the select only returns 2,000 rows, it must pull back 3 x 500,000 rows to do the work... JOIN clause push down would offload this work to the remote server and only return the 2,000 row result.

      Attachments

        Activity

          People

            Unassigned Unassigned
            rdyas Robert Dyas
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.