spider/handler.spider3_fixes, spider/handler.basic_sql fail

spider/handler.spider3_fixes             w2 [ fail ]

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

CURRENT_TEST: spider/handler.spider3_fixes

--- /data/bld/10.2/mysql-test/plugin/spider/spider/handler/r/spider3_fixes.result       2016-09-05 15:59:33.000000000 +0300

+++ /data/bld/10.2/mysql-test/plugin/spider/spider/handler/r/spider3_fixes.reject       2016-10-09 02:27:56.844862909 +0300

@@ -10,26 +10,34 @@

 for slave1_1

 drop and create databases

+connection master_1;

 DROP DATABASE IF EXISTS auto_test_local;

 CREATE DATABASE auto_test_local;

 USE auto_test_local;

+connection slave1_1;

 DROP DATABASE IF EXISTS auto_test_local;

 CREATE DATABASE auto_test_local;

 USE auto_test_local;

+connection child2_1;

 DROP DATABASE IF EXISTS auto_test_remote;

 CREATE DATABASE auto_test_remote;

 USE auto_test_remote;

+connection child2_2;

 DROP DATABASE IF EXISTS auto_test_remote2;

 CREATE DATABASE auto_test_remote2;

 USE auto_test_remote2;

 test select 1

+connection master_1;

 SELECT 1;

 1

 1

 3.1

 auto_increment

+connection master_1;

+connection slave1_1;

+connection master_1;

 DROP TABLE IF EXISTS t1, t2;

 CREATE TABLE t1 (

 id int(11) NOT NULL AUTO_INCREMENT,

@@ -198,6 +206,7 @@

 SELECT MAX(id) FROM t2;

 MAX(id)

 46

...

@@ -206,188 +215,16 @@

 1554

 2331

 10000

-auto_increment with partition

-DROP TABLE IF EXISTS t1, t2;

-CREATE TABLE t1 (

-id int(11) NOT NULL AUTO_INCREMENT,

-PRIMARY KEY (id)

-) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_INCREMENT1_P_1

-CREATE TABLE t2 (

-id int(11) NOT NULL AUTO_INCREMENT,

-PRIMARY KEY (id)

-) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_INCREMENT1_P_1

-MASTER_1_AUTO_INCREMENT_INCREMENT2

-MASTER_1_AUTO_INCREMENT_OFFSET2

-spider_direct_sql('SET SESSION AUTO_INCREMENT_INCREMENT = 4', '',

-'srv "s_2_1"')

-1

-spider_direct_sql('SET SESSION AUTO_INCREMENT_INCREMENT = 4', '',

-'srv "s_2_2"')

-1

-spider_bg_direct_sql('SET SESSION AUTO_INCREMENT_OFFSET = 2', '',

-'srv "s_2_1"')

-1

-spider_bg_direct_sql('SET SESSION AUTO_INCREMENT_OFFSET = 3', '',

-'srv "s_2_2"')

-1

-CREATE TABLE t1 (

-id int(11) NOT NULL AUTO_INCREMENT,

-PRIMARY KEY (id)

-) SLAVE1_1_ENGINE SLAVE1_1_CHARSET SLAVE1_1_COMMENT_INCREMENT1_P_1

-CREATE TABLE t2 (

-id int(11) NOT NULL AUTO_INCREMENT,

-PRIMARY KEY (id)

-) SLAVE1_1_ENGINE SLAVE1_1_CHARSET SLAVE1_1_COMMENT_INCREMENT1_P_1

-INSERT INTO t1 () VALUES ();

-SELECT LAST_INSERT_ID();

-LAST_INSERT_ID()

-2

-SELECT MAX(id) FROM t1;

-MAX(id)

-2

-INSERT INTO t2 () VALUES ();

-SELECT LAST_INSERT_ID();

-LAST_INSERT_ID()

-3

-SELECT MAX(id) FROM t2;

-MAX(id)

-3

-MASTER_1_AUTO_INCREMENT_OFFSET3

-INSERT INTO t1 (id) VALUES (null);

-SELECT LAST_INSERT_ID();

-LAST_INSERT_ID()

-7

-SELECT MAX(id) FROM t1;

-MAX(id)

-7

-MASTER_1_AUTO_INCREMENT_OFFSET4

-INSERT INTO t2 (id) VALUES (null);

-SELECT LAST_INSERT_ID();

-LAST_INSERT_ID()

-6

-SELECT MAX(id) FROM t2;

-MAX(id)

-7

-MASTER_1_AUTO_INCREMENT_OFFSET3

-INSERT INTO t1 () VALUES (),(),(),();

-Warnings:

-Note   12520   Binlog's auto-inc value is probably different from linked table's auto-inc value

-Note   12520   Binlog's auto-inc value is probably different from linked table's auto-inc value

-Note   12520   Binlog's auto-inc value is probably different from linked table's auto-inc value

-SELECT LAST_INSERT_ID();

-LAST_INSERT_ID()

-10

-SELECT id FROM t1 ORDER BY id;

-id

-2

-3

-6

-7

-10

-11

-14

-15

-MASTER_1_AUTO_INCREMENT_OFFSET4

-INSERT INTO t2 () VALUES (),(),(),();

-Warnings:

-Note   12520   Binlog's auto-inc value is probably different from linked table's auto-inc value

-Note   12520   Binlog's auto-inc value is probably different from linked table's auto-inc value

-Note   12520   Binlog's auto-inc value is probably different from linked table's auto-inc value

-SELECT LAST_INSERT_ID();

-LAST_INSERT_ID()

-18

-SELECT id FROM t2 ORDER BY id;

-id

-2

-3

-6

-7

-10

-11

-14

-15

-18

-19

-22

-23

-TRUNCATE TABLE t1;

-TRUNCATE TABLE t2;

-INSERT INTO t1 () VALUES (),(),(),();

-Warnings:

-Note   12520   Binlog's auto-inc value is probably different from linked table's auto-inc value

-Note   12520   Binlog's auto-inc value is probably different from linked table's auto-inc value

-Note   12520   Binlog's auto-inc value is probably different from linked table's auto-inc value

-SELECT LAST_INSERT_ID();

-LAST_INSERT_ID()

-2

-SELECT id FROM t1 ORDER BY id;

-id

-2

-3

-6

-7

-INSERT INTO t2 () VALUES (),(),(),();

-Warnings:

-Note   12520   Binlog's auto-inc value is probably different from linked table's auto-inc value

-Note   12520   Binlog's auto-inc value is probably different from linked table's auto-inc value

-Note   12520   Binlog's auto-inc value is probably different from linked table's auto-inc value

-SELECT LAST_INSERT_ID();

-LAST_INSERT_ID()

-10

-SELECT id FROM t2 ORDER BY id;

-id

-2

-3

-6

-7

-10

-11

-14

-15

-SET INSERT_ID=5000;

-MASTER_1_AUTO_INCREMENT_OFFSET3

-INSERT INTO t1 () VALUES ();

-SELECT LAST_INSERT_ID();

-LAST_INSERT_ID()

-18

-SELECT MAX(id) FROM t1;

-MAX(id)

-18

-MASTER_1_AUTO_INCREMENT_OFFSET4

-INSERT INTO t2 () VALUES ();

-SELECT LAST_INSERT_ID();

-LAST_INSERT_ID()

-19

-SELECT MAX(id) FROM t2;

-MAX(id)

-19

-INSERT INTO t1 (id) VALUES (10000);

-SELECT LAST_INSERT_ID();

-LAST_INSERT_ID()

-22

-SELECT MAX(id) FROM t1;

-MAX(id)

-22

-INSERT INTO t2 (id) VALUES (1000);

-SELECT LAST_INSERT_ID();

-LAST_INSERT_ID()

-26

-SELECT MAX(id) FROM t2;

-MAX(id)

-26

-SELECT id FROM t1 ORDER BY id;

-id

-2

-18

-777

-1554

-2331

-10000

+connection master_1;

 deinit

+connection master_1;

 DROP DATABASE IF EXISTS auto_test_local;

+connection slave1_1;

 DROP DATABASE IF EXISTS auto_test_local;

+connection child2_1;

 DROP DATABASE IF EXISTS auto_test_remote;

+connection child2_2;

 DROP DATABASE IF EXISTS auto_test_remote2;

 for slave1_1

 for master_1