summaryrefslogtreecommitdiff
path: root/mysql-test/main/subselect_extra.test
diff options
context:
space:
mode:
authorLena Startseva <lena.startseva@mariadb.com>2022-06-09 10:32:51 +0700
committerLena Startseva <lena.startseva@mariadb.com>2022-09-23 17:36:20 +0700
commit72ba96a48eb3e99a967e0489cc79f378e865e3fd (patch)
treed68b640bd3b6f71c4c7e13967776a13aa29965a2 /mysql-test/main/subselect_extra.test
parent1dd6255ffef901dddcff2191ddf975a2019799d9 (diff)
downloadmariadb-git-72ba96a48eb3e99a967e0489cc79f378e865e3fd.tar.gz
MDEV-27691: make working view-protocol
Tests with checking metadata or that cannot be run with the view-protocol are excluded from --view-protocol. For tests that do not allow the use of an additional connection, the util connection is disabled with "--disable_service_connection". Also cases with bugs for --view-protocol are disabled.
Diffstat (limited to 'mysql-test/main/subselect_extra.test')
-rw-r--r--mysql-test/main/subselect_extra.test4
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/main/subselect_extra.test b/mysql-test/main/subselect_extra.test
index 3651aed9aab..3f2f7b611ff 100644
--- a/mysql-test/main/subselect_extra.test
+++ b/mysql-test/main/subselect_extra.test
@@ -40,6 +40,9 @@ drop tables t1, t2;
--echo #
--echo # Bug #32694: NOT NULL table field in a subquery produces invalid results
--echo #
+#--view-protocol is disabled because view gives another query plan
+--disable_view_protocol
+
create table t1 (id int(10) not null, cur_date datetime not null);
create table t2 (id int(10) not null, cur_date date not null);
insert into t1 (id, cur_date) values (1, '2007-04-25 18:30:22');
@@ -73,6 +76,7 @@ select * from t2
where id in (select id from t2 as x1 where (t2.cur_date is null));
drop table t1,t2;
+--enable_view_protocol
--echo #
--echo # From group_min_max.test