ER_QUERY_ON_FOREIGN_DATA_SOURCE on a query from a federated table with index on a bit column

Bug #1005052 reported by Elena Stepanova on 2012-05-27
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
New
Medium
Michael Widenius

Bug Description

Also filed as http://bugs.mysql.com/bug.php?id=65431

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='mysql://root@127.0.0.1:$MASTER_MYPORT/fed/t1';

SELECT d+0 FROM t1 WHERE d < 10000;

# end of test case

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers