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

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.36, 10.0.9
        • Fix Version/s: 10.0, 5.5
        • Component/s: 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;

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #65431 - Error 1430 while selecting from a federated table with index on a bit column

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  ratzpo Rasmus Johansson added a comment -

                  Launchpad bug id: 1005052

                  Show
                  ratzpo Rasmus Johansson added a comment - Launchpad bug id: 1005052
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  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.

                  Show
                  elenst Elena Stepanova added a comment - 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.

                    People

                    • Assignee:
                      monty Michael Widenius
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      1 Start watching this issue

                      Dates

                      • Created:
                        Updated: