Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-708

LP:1005052 - ER_QUERY_ON_FOREIGN_DATA_SOURCE on a query from a federated table with index on a bit column

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 5.1.67, 5.2.14, 5.3.12, 5.5.36, 10.0.9
    • 5.5(EOL)
    • None

    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;

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.