summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/sysschema/r/optimizer_switch.result
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-07-01 18:15:00 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-07-01 18:15:00 +0000
commita2a2e32c02643a0cec111511220227703fda1cd5 (patch)
tree69cc2b631234c2a8e026b9cd4d72676c61c594df /mysql-test/suite/sysschema/r/optimizer_switch.result
parentReleasing progress-linux version 1:10.11.8-1~progress7.99u1. (diff)
downloadmariadb-a2a2e32c02643a0cec111511220227703fda1cd5.tar.xz
mariadb-a2a2e32c02643a0cec111511220227703fda1cd5.zip
Merging upstream version 1:11.4.2.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/suite/sysschema/r/optimizer_switch.result')
-rw-r--r--mysql-test/suite/sysschema/r/optimizer_switch.result42
1 files changed, 42 insertions, 0 deletions
diff --git a/mysql-test/suite/sysschema/r/optimizer_switch.result b/mysql-test/suite/sysschema/r/optimizer_switch.result
new file mode 100644
index 00000000..6336051d
--- /dev/null
+++ b/mysql-test/suite/sysschema/r/optimizer_switch.result
@@ -0,0 +1,42 @@
+call sys.optimizer_switch_on();
+option opt
+condition_pushdown_for_derived on
+condition_pushdown_for_subquery on
+condition_pushdown_from_having on
+derived_merge on
+derived_with_keys on
+exists_to_in on
+extended_keys on
+firstmatch on
+hash_join_cardinality on
+index_condition_pushdown on
+index_merge on
+index_merge_intersection on
+index_merge_sort_union on
+index_merge_union on
+in_to_exists on
+join_cache_bka on
+join_cache_hashed on
+join_cache_incremental on
+loosescan on
+materialization on
+optimize_join_buffer_size on
+orderby_uses_equalities on
+outer_join_with_cache on
+partial_match_rowid_merge on
+partial_match_table_scan on
+rowid_filter on
+sargable_casefold on
+semijoin on
+semijoin_with_cache on
+split_materialized on
+subquery_cache on
+table_elimination on
+call sys.optimizer_switch_off();
+option opt
+cset_narrowing off
+index_merge_sort_intersection off
+mrr off
+mrr_cost_based off
+mrr_sort_keys off
+not_null_range_scan off