revision-id: cf0be6420cfe107230aaf6025818638c969960cc (mariadb-10.4.3-37-gcf0be6420cf) parent(s): 3897734cb0b080585798dfbab031f8ef1eaa6ce9 author: Oleksandr Byelkin committer: Oleksandr Byelkin timestamp: 2019-03-06 17:49:57 +0100 message: there are such tests --- mysql-test/main/subselect_innodb.result | 35 ------------------------------ mysql-test/main/subselect_innodb.test | 38 --------------------------------- 2 files changed, 73 deletions(-) diff --git a/mysql-test/main/subselect_innodb.result b/mysql-test/main/subselect_innodb.result index 64e67c1dfc1..0eb40c9be00 100644 --- a/mysql-test/main/subselect_innodb.result +++ b/mysql-test/main/subselect_innodb.result @@ -616,38 +616,3 @@ id select_type table type possible_keys key key_len ref rows filtered Extra Warnings: Note 1003 select `test`.`t1`.`f1` AS `f1`,`test`.`t2`.`f2` AS `f2`,`test`.`t3`.`f3` AS `f3` from `test`.`t1` join `test`.`t2` semi join (`test`.`t4`) join `test`.`t3` where `test`.`t4`.`f4` = 1 and `test`.`t1`.`f1` >= `test`.`t2`.`f2` DROP TABLE t1,t2,t3,t4; -# -# MDEV-18339: ASAN heap-buffer-overflow in -# Item_exists_subselect::is_top_level_item -# -CREATE TABLE t1 ( pk int PRIMARY KEY , iiiiiiiiiiiii int , col_int1111 int, col_date_nokey date , col_time_key time, col_time_nokey time , col_datetime_key time, col_datetime_nokey time , ccccccccccccccc varchar(1), vvvvvvvvvvvvvvvvv varchar(1)) engine=innodb; -CREATE TABLE t2 ( iiiiiiiiiiiii int , vvvvvvvvvvvvvvvvv varchar(1)) engine=innodb; -CREATE TABLE t3 ( pk int PRIMARY KEY) engine=innodb; -CREATE TABLE t4 ( iiiiiiiiiiiii int , vvvvvvvvvvvvvvvvv varchar(1)) engine=innodb; -select * from -(select distinct -(select count(t111111111.`ccccccccccccccc`) from t1 as t111111111 -where (exists(select distinct t22222222222.`iiiiiiiiiiiii` from t2 as t22222222222 where t22222222222.`vvvvvvvvvvvvvvvvv` < t111111111.`vvvvvvvvvvvvvvvvv`) -or t111111111.`ccccccccccccccc` != t111111111.`vvvvvvvvvvvvvvvvv`) -) as field1 -from -(select t1_______2.* -from (t1 as t1_______1 join t1 as t1_______2 -on (t1_______2.`vvvvvvvvvvvvvvvvv` = t1_______1.`ccccccccccccccc` - and t1_______1.`iiiiiiiiiiiii` != -(select sum(t44444444444.`iiiiiiiiiiiii`) -from (t4 as t44444444444 join t3 as t33333333333 -on (t33333333333.`pk` = t44444444444.`iiiiiiiiiiiii`)) -where t44444444444.`vvvvvvvvvvvvvvvvv` > 'x') -) -) -) as alias1 -straight_join -t2 as alias2 -on (alias2.`iiiiiiiiiiiii` = alias1.`iiiiiiiiiiiii`) -where ((select 9 from dual) is null) -and alias1.`pk` in (32, 129, 87, 51, 58, 152, 241, 37, 55, 237, 166) -group by field1 /* 111 -111111111 */ ) as derived_aaaaa /* comment11111111111111111111111111 */; -field1 -# End of 10.4 tests diff --git a/mysql-test/main/subselect_innodb.test b/mysql-test/main/subselect_innodb.test index 90d3b07c1ad..544bcd994ed 100644 --- a/mysql-test/main/subselect_innodb.test +++ b/mysql-test/main/subselect_innodb.test @@ -611,41 +611,3 @@ FROM t1 DROP TABLE t1,t2,t3,t4; ---echo # ---echo # MDEV-18339: ASAN heap-buffer-overflow in ---echo # Item_exists_subselect::is_top_level_item ---echo # - -CREATE TABLE t1 ( pk int PRIMARY KEY , iiiiiiiiiiiii int , col_int1111 int, col_date_nokey date , col_time_key time, col_time_nokey time , col_datetime_key time, col_datetime_nokey time , ccccccccccccccc varchar(1), vvvvvvvvvvvvvvvvv varchar(1)) engine=innodb; - -CREATE TABLE t2 ( iiiiiiiiiiiii int , vvvvvvvvvvvvvvvvv varchar(1)) engine=innodb; -CREATE TABLE t3 ( pk int PRIMARY KEY) engine=innodb; -CREATE TABLE t4 ( iiiiiiiiiiiii int , vvvvvvvvvvvvvvvvv varchar(1)) engine=innodb; - -select * from -(select distinct - (select count(t111111111.`ccccccccccccccc`) from t1 as t111111111 - where (exists(select distinct t22222222222.`iiiiiiiiiiiii` from t2 as t22222222222 where t22222222222.`vvvvvvvvvvvvvvvvv` < t111111111.`vvvvvvvvvvvvvvvvv`) - or t111111111.`ccccccccccccccc` != t111111111.`vvvvvvvvvvvvvvvvv`) - ) as field1 -from - (select t1_______2.* - from (t1 as t1_______1 join t1 as t1_______2 - on (t1_______2.`vvvvvvvvvvvvvvvvv` = t1_______1.`ccccccccccccccc` - and t1_______1.`iiiiiiiiiiiii` != - (select sum(t44444444444.`iiiiiiiiiiiii`) - from (t4 as t44444444444 join t3 as t33333333333 - on (t33333333333.`pk` = t44444444444.`iiiiiiiiiiiii`)) - where t44444444444.`vvvvvvvvvvvvvvvvv` > 'x') - ) - ) - ) as alias1 -straight_join - t2 as alias2 -on (alias2.`iiiiiiiiiiiii` = alias1.`iiiiiiiiiiiii`) -where ((select 9 from dual) is null) -and alias1.`pk` in (32, 129, 87, 51, 58, 152, 241, 37, 55, 237, 166) -group by field1 /* 111 -111111111 */ ) as derived_aaaaa /* comment11111111111111111111111111 */; - ---echo # End of 10.4 tests