|
1
by brian
clean slate |
1 |
#
|
2 |
# Run subselect.test without semi-join optimization (test materialize)
|
|
3 |
#
|
|
4 |
show variables like 'optimizer_switch'; |
|
5 |
set optimizer_switch='no_materialization'; |
|
6 |
||
7 |
--source t/subselect.test |
|
8 |
||
|
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
9 |
--error 1231 |
|
1
by brian
clean slate |
10 |
set optimizer_switch=''; |
|
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
11 |
set optimizer_switch=0; |
|
1
by brian
clean slate |
12 |
show variables like 'optimizer_switch'; |
13 |