Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.0.15
-
Linux x86_64
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)