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 /sql | |
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 'sql')
-rw-r--r-- | sql/sys_vars.cc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/sys_vars.cc b/sql/sys_vars.cc index 8b73484cb8a..b72d4a3c358 100644 --- a/sql/sys_vars.cc +++ b/sql/sys_vars.cc @@ -2457,7 +2457,7 @@ static Sys_var_ulong Sys_max_recursive_iterations( "max_recursive_iterations", "Maximum number of iterations when executing recursive queries", SESSION_VAR(max_recursive_iterations), CMD_LINE(OPT_ARG), - VALID_RANGE(0, UINT_MAX), DEFAULT(UINT_MAX), BLOCK_SIZE(1)); + VALID_RANGE(0, UINT_MAX), DEFAULT(1000), BLOCK_SIZE(1)); static Sys_var_ulong Sys_max_sort_length( "max_sort_length", |