diff options
Diffstat (limited to 'mysql-test/r/net_buffer_length_basic.result')
| -rw-r--r-- | mysql-test/r/net_buffer_length_basic.result | 194 |
1 files changed, 194 insertions, 0 deletions
diff --git a/mysql-test/r/net_buffer_length_basic.result b/mysql-test/r/net_buffer_length_basic.result new file mode 100644 index 00000000000..ddaad3dfa91 --- /dev/null +++ b/mysql-test/r/net_buffer_length_basic.result @@ -0,0 +1,194 @@ +SET @start_global_value = @@global.net_buffer_length; +SET @start_session_value = @@session.net_buffer_length; +'#--------------------FN_DYNVARS_109_01-------------------------#' +SET @@global.net_buffer_length = 10000; +SET @@global.net_buffer_length = DEFAULT; +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +16384 +SET @@session.net_buffer_length = 20000; +SET @@session.net_buffer_length = DEFAULT; +SELECT @@session.net_buffer_length; +@@session.net_buffer_length +16384 +'#--------------------FN_DYNVARS_109_02-------------------------#' +SET @@global.net_buffer_length = DEFAULT; +SELECT @@global.net_buffer_length = 16384; +@@global.net_buffer_length = 16384 +1 +SET @@session.net_buffer_length = DEFAULT; +SELECT @@session.net_buffer_length = 16384; +@@session.net_buffer_length = 16384 +1 +'#--------------------FN_DYNVARS_109_03-------------------------#' +SET @@global.net_buffer_length = 1024; +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1024 +SET @@global.net_buffer_length = 1025; +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1024 +SET @@global.net_buffer_length = 1048576; +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1048576 +SET @@global.net_buffer_length = 1048575; +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1047552 +SET @@global.net_buffer_length = 65535; +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +64512 +'Bug# 34877: Invalid Values are coming in variable on assigning valid values'; +'#--------------------FN_DYNVARS_109_04-------------------------#' +SET @@session.net_buffer_length = 1024; +SELECT @@session.net_buffer_length; +@@session.net_buffer_length +1024 +SET @@session.net_buffer_length = 1025; +SELECT @@session.net_buffer_length; +@@session.net_buffer_length +1024 +SET @@session.net_buffer_length = 1048576; +SELECT @@session.net_buffer_length; +@@session.net_buffer_length +1048576 +SET @@session.net_buffer_length = 1048575; +SELECT @@session.net_buffer_length; +@@session.net_buffer_length +1047552 +SET @@session.net_buffer_length = 65535; +SELECT @@session.net_buffer_length; +@@session.net_buffer_length +64512 +'Bug# 34877: Invalid Values are coming in variable on assigning valid values'; +'#------------------FN_DYNVARS_109_05-----------------------#' +SET @@global.net_buffer_length = 0; +Warnings: +Warning 1292 Truncated incorrect net_buffer_length value: '0' +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1024 +SET @@global.net_buffer_length = -1024; +Warnings: +Warning 1292 Truncated incorrect net_buffer_length value: '0' +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1024 +SET @@global.net_buffer_length = 1023; +Warnings: +Warning 1292 Truncated incorrect net_buffer_length value: '1023' +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1024 +SET @@global.net_buffer_length = 1048577; +Warnings: +Warning 1292 Truncated incorrect net_buffer_length value: '1048577' +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1048576 +SET @@global.net_buffer_length = 104857633; +Warnings: +Warning 1292 Truncated incorrect net_buffer_length value: '104857633' +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1048576 +SET @@global.net_buffer_length = 65530.34.; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1 +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1048576 +SET @@global.net_buffer_length = test; +ERROR 42000: Incorrect argument type to variable 'net_buffer_length' +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1048576 +SET @@session.net_buffer_length = 0; +Warnings: +Warning 1292 Truncated incorrect net_buffer_length value: '0' +SELECT @@session.net_buffer_length; +@@session.net_buffer_length +1024 +SET @@session.net_buffer_length = -2; +Warnings: +Warning 1292 Truncated incorrect net_buffer_length value: '0' +SELECT @@session.net_buffer_length; +@@session.net_buffer_length +1024 +SET @@session.net_buffer_length = 1048577; +Warnings: +Warning 1292 Truncated incorrect net_buffer_length value: '1048577' +SELECT @@session.net_buffer_length; +@@session.net_buffer_length +1048576 +SET @@session.net_buffer_length = 1048576002; +Warnings: +Warning 1292 Truncated incorrect net_buffer_length value: '1048576002' +SELECT @@session.net_buffer_length; +@@session.net_buffer_length +1048576 +SET @@session.net_buffer_length = 65530.34.; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1 +SET @@session.net_buffer_length = 65550; +SELECT @@session.net_buffer_length; +@@session.net_buffer_length +65536 +'Bug # 34837: Errors are not coming on assigning invalid values to variable'; +SET @@session.net_buffer_length = test; +ERROR 42000: Incorrect argument type to variable 'net_buffer_length' +SELECT @@session.net_buffer_length; +@@session.net_buffer_length +65536 +'#------------------FN_DYNVARS_109_06-----------------------#' +SELECT @@global.net_buffer_length = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='net_buffer_length'; +@@global.net_buffer_length = VARIABLE_VALUE +1 +'#------------------FN_DYNVARS_109_07-----------------------#' +SELECT @@session.net_buffer_length = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.SESSION_VARIABLES +WHERE VARIABLE_NAME='net_buffer_length'; +@@session.net_buffer_length = VARIABLE_VALUE +1 +'#------------------FN_DYNVARS_109_08-----------------------#' +SET @@global.net_buffer_length = TRUE; +Warnings: +Warning 1292 Truncated incorrect net_buffer_length value: '1' +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1024 +SET @@global.net_buffer_length = FALSE; +Warnings: +Warning 1292 Truncated incorrect net_buffer_length value: '0' +SELECT @@global.net_buffer_length; +@@global.net_buffer_length +1024 +'#---------------------FN_DYNVARS_109_09----------------------#' +SET @@global.net_buffer_length = 2048; +SELECT @@net_buffer_length = @@global.net_buffer_length; +@@net_buffer_length = @@global.net_buffer_length +0 +'#---------------------FN_DYNVARS_109_10----------------------#' +SET @@net_buffer_length = 100000; +SELECT @@net_buffer_length = @@local.net_buffer_length; +@@net_buffer_length = @@local.net_buffer_length +1 +SELECT @@local.net_buffer_length = @@session.net_buffer_length; +@@local.net_buffer_length = @@session.net_buffer_length +1 +'#---------------------FN_DYNVARS_109_11----------------------#' +SET net_buffer_length = 1024; +SELECT @@net_buffer_length; +@@net_buffer_length +1024 +SELECT local.net_buffer_length; +ERROR 42S02: Unknown table 'local' in field list +SELECT session.net_buffer_length; +ERROR 42S02: Unknown table 'session' in field list +SELECT net_buffer_length = @@session.net_buffer_length; +ERROR 42S22: Unknown column 'net_buffer_length' in 'field list' +SET @@global.net_buffer_length = @start_global_value; +SET @@session.net_buffer_length = @start_session_value; |