diff options
Diffstat (limited to 'mysql-test/r/max_tmp_tables_basic_64.result')
| -rw-r--r-- | mysql-test/r/max_tmp_tables_basic_64.result | 187 |
1 files changed, 187 insertions, 0 deletions
diff --git a/mysql-test/r/max_tmp_tables_basic_64.result b/mysql-test/r/max_tmp_tables_basic_64.result new file mode 100644 index 00000000000..4b9f68c509e --- /dev/null +++ b/mysql-test/r/max_tmp_tables_basic_64.result @@ -0,0 +1,187 @@ +SET @start_global_value = @@global.max_tmp_tables; +SELECT @start_global_value; +@start_global_value +32 +SET @start_session_value = @@session.max_tmp_tables; +SELECT @start_session_value; +@start_session_value +32 +'#--------------------FN_DYNVARS_086_01-------------------------#' +SET @@global.max_tmp_tables = 1000; +SET @@global.max_tmp_tables = DEFAULT; +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +32 +SET @@session.max_tmp_tables = 1000; +SET @@session.max_tmp_tables = DEFAULT; +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +32 +'#--------------------FN_DYNVARS_086_02-------------------------#' +SET @@global.max_tmp_tables = DEFAULT; +SELECT @@global.max_tmp_tables = 32; +@@global.max_tmp_tables = 32 +1 +SET @@session.max_tmp_tables = DEFAULT; +SELECT @@session.max_tmp_tables = 32; +@@session.max_tmp_tables = 32 +1 +'#--------------------FN_DYNVARS_086_03-------------------------#' +SET @@global.max_tmp_tables = 1; +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +1 +SET @@global.max_tmp_tables = 2; +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +2 +SET @@global.max_tmp_tables = 65536; +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +65536 +SET @@global.max_tmp_tables = 4294967295; +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +4294967295 +SET @@global.max_tmp_tables = 4294967294; +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +4294967294 +'#--------------------FN_DYNVARS_086_04-------------------------#' +SET @@session.max_tmp_tables = 1; +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +1 +SET @@session.max_tmp_tables = 2; +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +2 +SET @@session.max_tmp_tables = 65536; +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +65536 +SET @@session.max_tmp_tables = 4294967295; +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +4294967295 +SET @@session.max_tmp_tables = 4294967294; +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +4294967294 +'#------------------FN_DYNVARS_086_05-----------------------#' +SET @@global.max_tmp_tables = -1024; +Warnings: +Warning 1292 Truncated incorrect max_tmp_tables value: '0' +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +1 +SET @@global.max_tmp_tables = 4294967296; +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +4294967296 +SET @@global.max_tmp_tables = -1; +Warnings: +Warning 1292 Truncated incorrect max_tmp_tables value: '0' +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +1 +SET @@global.max_tmp_tables = 429496729500; +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +429496729500 +SET @@global.max_tmp_tables = 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.max_tmp_tables; +@@global.max_tmp_tables +429496729500 +SET @@global.max_tmp_tables = test; +ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +429496729500 +SET @@session.max_tmp_tables = 4294967296; +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +4294967296 +SET @@session.max_tmp_tables = -1; +Warnings: +Warning 1292 Truncated incorrect max_tmp_tables value: '0' +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +1 +SET @@session.max_tmp_tables = 429496729500; +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +429496729500 +SET @@session.max_tmp_tables = -001; +Warnings: +Warning 1292 Truncated incorrect max_tmp_tables value: '0' +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +1 +SET @@session.max_tmp_tables = 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.max_tmp_tables = 10737418241; +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +10737418241 +SET @@session.max_tmp_tables = test; +ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +10737418241 +'#------------------FN_DYNVARS_086_06-----------------------#' +SELECT @@global.max_tmp_tables = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='max_tmp_tables'; +@@global.max_tmp_tables = VARIABLE_VALUE +1 +'#------------------FN_DYNVARS_086_07-----------------------#' +SELECT @@session.max_tmp_tables = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.SESSION_VARIABLES +WHERE VARIABLE_NAME='max_tmp_tables'; +@@session.max_tmp_tables = VARIABLE_VALUE +1 +'#------------------FN_DYNVARS_086_08-----------------------#' +SET @@global.max_tmp_tables = TRUE; +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +1 +SET @@global.max_tmp_tables = FALSE; +Warnings: +Warning 1292 Truncated incorrect max_tmp_tables value: '0' +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +1 +'#---------------------FN_DYNVARS_086_09----------------------#' +SET @@global.max_tmp_tables = 20; +SELECT @@max_tmp_tables = @@global.max_tmp_tables; +@@max_tmp_tables = @@global.max_tmp_tables +0 +'#---------------------FN_DYNVARS_086_10----------------------#' +SET @@max_tmp_tables = 255; +SELECT @@max_tmp_tables = @@local.max_tmp_tables; +@@max_tmp_tables = @@local.max_tmp_tables +1 +SELECT @@local.max_tmp_tables = @@session.max_tmp_tables; +@@local.max_tmp_tables = @@session.max_tmp_tables +1 +'#---------------------FN_DYNVARS_086_11----------------------#' +SET max_tmp_tables = 102; +SELECT @@max_tmp_tables; +@@max_tmp_tables +102 +SELECT local.max_tmp_tables; +ERROR 42S02: Unknown table 'local' in field list +SELECT session.max_tmp_tables; +ERROR 42S02: Unknown table 'session' in field list +SELECT max_tmp_tables = @@session.max_tmp_tables; +ERROR 42S22: Unknown column 'max_tmp_tables' in 'field list' +SET @@global.max_tmp_tables = @start_global_value; +SELECT @@global.max_tmp_tables; +@@global.max_tmp_tables +32 +SET @@session.max_tmp_tables = @start_session_value; +SELECT @@session.max_tmp_tables; +@@session.max_tmp_tables +32 |