rpl.rpl_insert_id 'innodb_plugin,stmt' w3 [ fail ]
|
Test ended at 2018-01-23 17:38:24
|
|
CURRENT_TEST: rpl.rpl_insert_id
|
--- /usr/share/mysql/mysql-test/suite/rpl/r/rpl_insert_id.result 2018-01-23 08:58:08.000000000 -0500
|
+++ /dev/shm/var/3/log/rpl_insert_id.reject 2018-01-23 17:38:24.766359198 -0500
|
@@ -71,11 +71,6 @@
|
13
|
select * from t2 ORDER BY b;
|
b c
|
-5 0
|
-6 10
|
-7 11
|
-8 12
|
-9 13
|
drop table t1;
|
drop table t2;
|
#
|
@@ -102,7 +97,6 @@
|
1
|
select * from t2;
|
a
|
-1
|
drop table t1;
|
drop table t2;
|
#
|
@@ -180,17 +174,8 @@
|
3 5
|
select * from t1;
|
id last_id
|
-1 0
|
-2 1
|
-3 2
|
-4 1
|
-5 4
|
-6 3
|
select * from t2;
|
id last_id
|
-1 3
|
-2 4
|
-3 5
|
drop function bug15728;
|
drop function bug15728_insert;
|
drop table t1,t2;
|
@@ -215,7 +200,6 @@
|
delete from t1 where b <> 100;
|
select * from t1 order by n;
|
n b
|
-1 100
|
replace into t1 values(null,100),(null,350);
|
select * from t1 order by n;
|
n b
|
@@ -223,8 +207,6 @@
|
3 350
|
select * from t1 order by n;
|
n b
|
-2 100
|
-3 350
|
insert into t1 values (NULL,400),(3,500),(NULL,600) on duplicate key UPDATE n=1000;
|
select * from t1 order by n;
|
n b
|
@@ -234,10 +216,6 @@
|
1001 600
|
select * from t1 order by n;
|
n b
|
-2 100
|
-4 400
|
-1000 350
|
-1001 600
|
drop table t1;
|
create table t1 (n int primary key auto_increment not null,
|
b int, unique(b)) engine=myisam;
|
@@ -249,7 +227,6 @@
|
delete from t1 where b <> 100;
|
select * from t1 order by n;
|
n b
|
-1 100
|
insert into t1 values(null,100),(null,350) on duplicate key update n=2;
|
select * from t1 order by n;
|
n b
|
@@ -257,8 +234,6 @@
|
3 350
|
select * from t1 order by n;
|
n b
|
-2 100
|
-3 350
|
drop table t1;
|
CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b INT,
|
UNIQUE(b)) ENGINE=myisam;
|
@@ -269,8 +244,6 @@
|
2 2
|
SELECT * FROM t1 ORDER BY a;
|
a b
|
-1 10
|
-2 2
|
drop table t1;
|
CREATE TABLE t1 (
|
id bigint(20) unsigned NOT NULL auto_increment,
|
@@ -311,12 +284,6 @@
|
6 6 f 6f
|
SELECT * FROM t1 ORDER BY id;
|
id field_1 field_2 field_3
|
-1 1 a 1a
|
-2 2 b 2b
|
-3 3 c 3c
|
-4 4 d 4d
|
-5 5 e 5e
|
-6 6 f 6f
|
drop table t1, t2;
|
DROP PROCEDURE IF EXISTS p1;
|
DROP TABLE IF EXISTS t1, t2;
|
@@ -347,10 +314,8 @@
|
1 0
|
SELECT * FROM t1 ORDER BY id;
|
id last_id
|
-0 1
|
SELECT * FROM t2 ORDER BY id;
|
id last_id
|
-1 0
|
DROP PROCEDURE p1;
|
DROP TABLE t1, t2;
|
DROP PROCEDURE IF EXISTS p1;
|
@@ -428,30 +393,9 @@
|
16
|
SELECT * FROM t1;
|
i j
|
-1 -1
|
-2 0
|
-3 0
|
-4 0
|
-5 0
|
-6 0
|
-7 0
|
-8 3
|
-9 3
|
-10 3
|
-11 3
|
-12 3
|
-13 8
|
-14 -1
|
-15 13
|
-16 0
|
17 0
|
SELECT * FROM t2;
|
i
|
-2
|
-3
|
-5
|
-6
|
-16
|
DROP PROCEDURE p1;
|
DROP FUNCTION f1;
|
DROP FUNCTION f2;
|
@@ -493,11 +437,8 @@
|
8 0
|
select * from t1 order by id;
|
id
|
-0
|
select * from t2 order by id;
|
id last_id
|
-4 0
|
-8 0
|
drop table t1;
|
drop function insid;
|
truncate table t2;
|
@@ -519,10 +460,8 @@
|
1 3
|
select * from t1 order by n;
|
n b
|
-1 10
|
select * from t2 order by id;
|
id last_id
|
-1 3
|
drop table t1, t2;
|
drop procedure foo;
|
SET @@global.concurrent_insert= @old_concurrent_insert;
|
|
mysqltest: Result length mismatch
|