summaryrefslogtreecommitdiff
path: root/mysql-test/main/subselect_extra.test
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2022-10-17 08:43:55 +0200
committerOleksandr Byelkin <sanja@mariadb.com>2022-10-17 08:43:55 +0200
commit851b31bcc47b742cd3b39ad06176b0e8be591c18 (patch)
tree93da42af4bd22fc448df71777bedb0a4690478ba /mysql-test/main/subselect_extra.test
parent618d82064618bda06bcd080af5b664b3d173dbe3 (diff)
parenta4234f0410008e14aa2ad7ad56973127f3046d5c (diff)
downloadmariadb-git-851b31bcc47b742cd3b39ad06176b0e8be591c18.tar.gz
Merge branch 'bb-10.8-vp-MDEV-27691' into 10.8
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