summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/r/join_buffer_space_limit_basic.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/sys_vars/r/join_buffer_space_limit_basic.result')
-rw-r--r--mysql-test/suite/sys_vars/r/join_buffer_space_limit_basic.result14
1 files changed, 4 insertions, 10 deletions
diff --git a/mysql-test/suite/sys_vars/r/join_buffer_space_limit_basic.result b/mysql-test/suite/sys_vars/r/join_buffer_space_limit_basic.result
index 9a65367a56f..fdc843fc3f4 100644
--- a/mysql-test/suite/sys_vars/r/join_buffer_space_limit_basic.result
+++ b/mysql-test/suite/sys_vars/r/join_buffer_space_limit_basic.result
@@ -1,22 +1,16 @@
SET @start_global_value = @@global.join_buffer_space_limit;
-select @@global.join_buffer_space_limit;
-@@global.join_buffer_space_limit
-2097152
-select @@session.join_buffer_space_limit;
-@@session.join_buffer_space_limit
-2097152
show global variables like 'join_buffer_space_limit';
Variable_name Value
-join_buffer_space_limit 2097152
+join_buffer_space_limit #
show session variables like 'join_buffer_space_limit';
Variable_name Value
-join_buffer_space_limit 2097152
+join_buffer_space_limit #
select * from information_schema.global_variables where variable_name='join_buffer_space_limit';
VARIABLE_NAME VARIABLE_VALUE
-JOIN_BUFFER_SPACE_LIMIT 2097152
+JOIN_BUFFER_SPACE_LIMIT #
select * from information_schema.session_variables where variable_name='join_buffer_space_limit';
VARIABLE_NAME VARIABLE_VALUE
-JOIN_BUFFER_SPACE_LIMIT 2097152
+JOIN_BUFFER_SPACE_LIMIT #
set global join_buffer_space_limit=10;
Warnings:
Warning 1292 Truncated incorrect join_buffer_space_limit value: '10'