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

            Assignee:
            Unassigned
            Reporter:
            kusutaku Takuya Kusumoto
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: