spider/handler tests fail in different ways

spider/handler.spider_fixes              w2 [ fail ]

        Test ended at 2016-10-09 02:27:59

CURRENT_TEST: spider/handler.spider_fixes

mysqltest: At line 1254: query '$CHILD2_1_CREATE_TEXT_KEY_TABLES1' failed: 1071: Specified key was too long; max key length is 1000 bytes

The result from queries just before the failure was:

< snip >

PRIMARY KEY (id)

) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_ERROR_MODE1_1

SELECT id FROM t1 ORDER BY id;

id

Warnings:

Error   12702   Remote table 'auto_test_remote.ter1_1' is not found

Error   1146    Table 'auto_test_remote.ter1_1' doesn't exist

INSERT INTO t1 (id) VALUES (1);

Warnings:

Error   1146    Table 'auto_test_remote.ter1_1' doesn't exist

DELETE FROM t1;

Warnings:

Error   12702   Remote table 'auto_test_remote.ter1_1' is not found

Error   1146    Table 'auto_test_remote.ter1_1' doesn't exist

TRUNCATE t1;

Warnings:

Error   1146    Table 'auto_test_remote.ter1_1' doesn't exist

3.0

is null

spider/handler.spider3_fixes             [ fail ]

        Test ended at 2016-10-09 17:46:51

CURRENT_TEST: spider/handler.spider3_fixes

mysqltest: At line 82: query '$CHILD2_1_CREATE_INCREMENT_TABLES1' failed: 1286: Unknown storage engine 'InnoDB'

The result from queries just before the failure was:

< snip >

DROP DATABASE IF EXISTS auto_test_local;

CREATE DATABASE auto_test_local;

USE auto_test_local;

DROP DATABASE IF EXISTS auto_test_local;

CREATE DATABASE auto_test_local;

USE auto_test_local;

DROP DATABASE IF EXISTS auto_test_remote;

CREATE DATABASE auto_test_remote;

USE auto_test_remote;

DROP DATABASE IF EXISTS auto_test_remote2;

CREATE DATABASE auto_test_remote2;

USE auto_test_remote2;

test select 1

SELECT 1;

1

1

3.1

auto_increment