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

connect.pivot failed in buildbot with "failed to discover table"

    XMLWordPrintable

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/bld-starfs-debug/builds/609/steps/test_1/logs/stdio
      (with ps protocol)

      connect.pivot                            w2 [ fail ]
              Test ended at 2017-12-14 16:24:07
       
      CURRENT_TEST: connect.pivot
      mysqltest: At line 158: query 'CREATE TABLE fruit_pivot ENGINE=CONNECT TABLE_TYPE=pivot TABNAME=fruit' failed: 1939: Engine CONNECT failed to discover table `test`.`fruit_pivot` with 'CREATE TABLE whatever (`id` INT(10) UNSIGNED NOT NULL,`                        7bfff520` INT(11) FLAG=1,`                        7bfff520` INT(11) FLAG=1,`                        7bfff520` INT(11) FLAG=1,`                        7bfff520` INT(11) FLAG=1) TABLE_TYPE='pivot' TABNAME='fruit''
       
      The result from queries just before the failure was:
      < snip >
       
      DROP TABLE pivet;
      DROP TABLE pets;
      #
      # MDEV-5734
      #
      CREATE TABLE fruit (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `name` varchar(32) NOT NULL,
      `cnt` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`)
      ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
      INSERT INTO fruit VALUES (1,'apple',1),(2,'banana',1),(3,'apple',2),(4,'cherry',4),(5,'durazno',2);
      SELECT * FROM fruit;
      id	name	cnt
      1	apple	1
      2	banana	1
      3	apple	2
      4	cherry	4
      5	durazno	2
      CREATE TABLE fruit_pivot ENGINE=CONNECT TABLE_TYPE=pivot TABNAME=fruit;
      

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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