diff options
| author | Daniel Black <daniel@mariadb.org> | 2021-03-30 09:38:34 +1100 |
|---|---|---|
| committer | Daniel Black <daniel@mariadb.org> | 2021-03-30 10:07:08 +1100 |
| commit | 831adb1e5cf5d283a5a727b396ecf75a5b207699 (patch) | |
| tree | 1a7654f3695830459a877c67b25740ad43287eda /mysql-test/main/win_big-mdev-11697.result | |
| parent | 2ad61c678243dec2a808b1f67b5760a725163052 (diff) | |
| download | mariadb-git-831adb1e5cf5d283a5a727b396ecf75a5b207699.tar.gz | |
MDEV-17239 default max_recursive_iterations 4G -> 1000bb-10.6-danielblack-MDEV-17239-default-max_recursive_iterations-1k
A default 4G max_recursive_iterations allows users to far
to easily exhaust CPU, memory and time for a incorrect query.
Reduce this value down to 1000 consistent with Oracle MySQL's
cte_max_recursion_depth.
Diffstat (limited to 'mysql-test/main/win_big-mdev-11697.result')
| -rw-r--r-- | mysql-test/main/win_big-mdev-11697.result | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/win_big-mdev-11697.result b/mysql-test/main/win_big-mdev-11697.result index ec9d2243c88..e8034e67aaf 100644 --- a/mysql-test/main/win_big-mdev-11697.result +++ b/mysql-test/main/win_big-mdev-11697.result @@ -1,3 +1,4 @@ +set max_recursive_iterations=200000; create table test_table (id int, random_data varchar(36), static_int int, static_varchar varchar(10)); insert into test_table(id, random_data, static_int, static_varchar) select id, random_data, 42, 'Hello' @@ -71,3 +72,4 @@ where variable_name like 'Sort_merge_passes'; variable_name case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end SORT_MERGE_PASSES WITH PASSES drop table test_table; +set max_recursive_iterations=default; |