main.delete_use_source 'innodb'          w1 [ fail ]

        Test ended at 2017-07-08 01:42:52

CURRENT_TEST: main.delete_use_source

--- /usr/local/mariadb-10.2.7-linux-x86_64/mysql-test/r/delete_use_source.result	2017-07-07 23:42:11.000000000 +0300

+++ /usr/local/mariadb-10.2.7-linux-x86_64/mysql-test/r/delete_use_source.reject	2017-07-08 01:42:52.427051960 +0300

@@ -44,8 +44,8 @@

 start transaction;

 explain delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 limit 1;

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

-1	PRIMARY	t1	range	c1	c1	4	NULL	550	Using where

-2	DEPENDENT SUBQUERY	b	ref	c1	c1	4	test.t1.c1	82	Using index

+1	PRIMARY	t1	ALL	c1	NULL	NULL	NULL	472	Using where

+2	DEPENDENT SUBQUERY	b	ref	c1	c1	4	test.t1.c1	113	Using index

 delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 limit 1;

 affected rows: 1

 delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 limit 1;

@@ -60,8 +60,8 @@

 start transaction;

 explain delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500;

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

-1	PRIMARY	t1	ALL	c1	NULL	NULL	NULL	717	Using where

-2	DEPENDENT SUBQUERY	b	ref	c1	c1	4	test.t1.c1	82	Using index

+1	PRIMARY	t1	ALL	c1	NULL	NULL	NULL	472	Using where

+2	DEPENDENT SUBQUERY	b	ref	c1	c1	4	test.t1.c1	113	Using index

 delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 ;

 affected rows: 500

 select count(*) from v1 where c1=0;

mysqltest: Result length mismatch