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;