[MDEV-708] LP:1005052 - ER_QUERY_ON_FOREIGN_DATA_SOURCE on a query from a federated table with index on a bit column Created: 2012-05-27  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.36, 10.0.9
Fix Version/s: 5.5

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: Launchpad, upstream

Attachments: XML File LPexportBug1005052.xml    

 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.

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;



 Comments   
Comment by Rasmus Johansson (Inactive) [ 2012-05-27 ]

Launchpad bug id: 1005052

Comment by Elena Stepanova [ 2014-03-26 ]

Also reproducible on 5.1-5.3, only the test case needs to be amended to use a different remote server – attempt to use the same server as local and remote causes a connect timeout.

Generated at Thu Feb 08 06:30:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.