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

LIMIT clause is not passed to federated/connect table query

    XMLWordPrintable

Details

    Description

      [Remote]
      Version: MariaDB 10.0.15
      The num of records: approximately 1bn

      [Local]
      Version: MariaDB 10.0.15
      Engine: FEDERATED

      I found that LIMIT clause is not passed to federated/connect table query and full table select is done in remove server.

      When simple select with LIMIT clause, lets say, "SELECT * FROM XXX LIMIT 100" out of 1bn records, simple full table select query is executed in remote server. (never finishes!)
      Moreover, simple "select count" also results in full table select.
      This behaviour is the same with CONNECT engine.
      But it's NOT seen in MySQL 5.6. (should be MariaDB specific bug)

      Attachments

        Activity

          People

            Unassigned Unassigned
            kusutaku Takuya Kusumoto
            Votes:
            1 Vote for this issue
            Watchers:
            4 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.