[MDEV-10990] spider/handler tests fail in different ways Created: 2016-10-09  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider, Tests
Affects Version/s: 10.1, 10.2
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

10.2 debug

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

10.1.17 release

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


Generated at Thu Feb 08 07:46:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.