ER_QUERY_ON_FOREIGN_DATA_SOURCE on a query from a federated table with index on a bit column
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
New
|
Medium
|
Michael Widenius |
Bug Description
Also filed as http://
At line 9: query 'SELECT d+0 FROM t1 WHERE d < 10000' failed: 1030: Got error 1430 from storage engine
Reproducible with Federated and FederatedX.
Repeatable on maria-5.5 (revno 3418) and on MySQL 5.1-5.6, so it most likely exists in previous MariaDB versions too, but I couldn't reproduce it on maria/5.1-5.3 due to some other problem which made the test case fail with timeout on table creation.
In any case it is not serious enough to be necessarily fixed in previous versions.
# Test case:
CREATE DATABASE fed;
CREATE TABLE fed.t1 (d BIT(32), KEY(d)) ENGINE=MyISAM;
eval
CREATE TABLE t1 (d BIT(32), KEY(d))
ENGINE=FEDERATED
CONNECTION=
SELECT d+0 FROM t1 WHERE d < 10000;
# end of test case