1 files changed, 44 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/deadlock_search_depth_long_basic.result b/mysql-test/suite/sys_vars/r/deadlock_search_depth_long_basic.result
new file mode 100644
index 00000000000..7b51fa3614a
--- /dev/null
+++ b/mysql-test/suite/sys_vars/r/deadlock_search_depth_long_basic.result
@@ -0,0 +1,44 @@
+SET @start_global_value = @@global.deadlock_search_depth_long;
+select @@global.deadlock_search_depth_long;
+@@global.deadlock_search_depth_long
+15
+select @@session.deadlock_search_depth_long;
+@@session.deadlock_search_depth_long
+15
+show global variables like 'deadlock_search_depth_long';
+Variable_name	Value
+deadlock_search_depth_long	15
+show session variables like 'deadlock_search_depth_long';
+Variable_name	Value
+deadlock_search_depth_long	15
+select * from information_schema.global_variables where variable_name='deadlock_search_depth_long';
+VARIABLE_NAME	VARIABLE_VALUE
+DEADLOCK_SEARCH_DEPTH_LONG	15
+select * from information_schema.session_variables where variable_name='deadlock_search_depth_long';
+VARIABLE_NAME	VARIABLE_VALUE
+DEADLOCK_SEARCH_DEPTH_LONG	15
+set global deadlock_search_depth_long=10;
+select @@global.deadlock_search_depth_long;
+@@global.deadlock_search_depth_long
+10
+set session deadlock_search_depth_long=10;
+select @@session.deadlock_search_depth_long;
+@@session.deadlock_search_depth_long
+10
+set global deadlock_search_depth_long=1.1;
+ERROR 42000: Incorrect argument type to variable 'deadlock_search_depth_long'
+set session deadlock_search_depth_long=1e1;
+ERROR 42000: Incorrect argument type to variable 'deadlock_search_depth_long'
+set global deadlock_search_depth_long="foo";
+ERROR 42000: Incorrect argument type to variable 'deadlock_search_depth_long'
+set global deadlock_search_depth_long=0;
+select @@global.deadlock_search_depth_long;
+@@global.deadlock_search_depth_long
+0
+set session deadlock_search_depth_long=cast(-1 as unsigned int);
+Warnings:
+Warning	1292	Truncated incorrect deadlock_search_depth_long value: '18446744073709551615'
+select @@session.deadlock_search_depth_long;
+@@session.deadlock_search_depth_long
+33
+SET @@global.deadlock_search_depth_long = @start_global_value;