summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/subselect_no_exists_to_in.test
blob: 4f39cfbdf6624aab061019a52111d8850015a95e (plain)
1
2
3
4
5
6
7
8
9
10
11
# 
# Run subselect.test with exists to in transformation
#
select @@optimizer_switch like '%exists_to_in=off%';
set optimizer_switch='exists_to_in=off';

--source subselect.test

set optimizer_switch=default;
select @@optimizer_switch like '%exists_to_in=off%';