diff options
Diffstat (limited to 'mysql-test/r/max_write_lock_count_basic_32.result')
| -rw-r--r-- | mysql-test/r/max_write_lock_count_basic_32.result | 108 |
1 files changed, 108 insertions, 0 deletions
diff --git a/mysql-test/r/max_write_lock_count_basic_32.result b/mysql-test/r/max_write_lock_count_basic_32.result new file mode 100644 index 00000000000..0c9c3c00c1f --- /dev/null +++ b/mysql-test/r/max_write_lock_count_basic_32.result @@ -0,0 +1,108 @@ +SET @start_global_value = @@global.max_write_lock_count; +SELECT @start_global_value; +@start_global_value +4294967295 +'#--------------------FN_DYNVARS_088_01-------------------------#' +SET @@global.max_write_lock_count = 1000; +SET @@global.max_write_lock_count = DEFAULT; +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +4294967295 +'#--------------------FN_DYNVARS_088_02-------------------------#' +SET @@global.max_write_lock_count = DEFAULT; +SELECT @@global.max_write_lock_count = 4294967295; +@@global.max_write_lock_count = 4294967295 +1 +'#--------------------FN_DYNVARS_088_03-------------------------#' +SET @@global.max_write_lock_count = 1; +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +1 +SET @@global.max_write_lock_count = 2; +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +2 +SET @@global.max_write_lock_count = 65536; +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +65536 +SET @@global.max_write_lock_count = 4294967295; +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +4294967295 +SET @@global.max_write_lock_count = 4294967294; +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +4294967294 +'#------------------FN_DYNVARS_088_04-----------------------#' +SET @@global.max_write_lock_count = -1024; +Warnings: +Warning 1292 Truncated incorrect max_write_lock_count value: '0' +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +1 +SET @@global.max_write_lock_count = 4294967296; +Warnings: +Warning 1292 Truncated incorrect max_write_lock_count value: '4294967296' +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +4294967295 +SET @@global.max_write_lock_count = -1; +Warnings: +Warning 1292 Truncated incorrect max_write_lock_count value: '0' +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +1 +SET @@global.max_write_lock_count = 429496729500; +Warnings: +Warning 1292 Truncated incorrect max_write_lock_count value: '429496729500' +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +4294967295 +SET @@global.max_write_lock_count = 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_write_lock_count; +@@global.max_write_lock_count +4294967295 +SET @@global.max_write_lock_count = test; +ERROR 42000: Incorrect argument type to variable 'max_write_lock_count' +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +4294967295 +'#------------------FN_DYNVARS_088_05-----------------------#' +SELECT @@global.max_write_lock_count = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='max_write_lock_count'; +@@global.max_write_lock_count = VARIABLE_VALUE +1 +'#------------------FN_DYNVARS_088_06-----------------------#' +SET @@global.max_write_lock_count = TRUE; +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +1 +SET @@global.max_write_lock_count = FALSE; +Warnings: +Warning 1292 Truncated incorrect max_write_lock_count value: '0' +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +1 +'#---------------------FN_DYNVARS_088_07----------------------#' +SET @@global.max_write_lock_count = 20; +SELECT @@max_write_lock_count = @@global.max_write_lock_count; +@@max_write_lock_count = @@global.max_write_lock_count +1 +'#---------------------FN_DYNVARS_088_08----------------------#' +SET @@global.max_write_lock_count = 102; +SELECT @@max_write_lock_count; +@@max_write_lock_count +102 +SELECT local.max_write_lock_count; +ERROR 42S02: Unknown table 'local' in field list +SELECT global.max_write_lock_count; +ERROR 42S02: Unknown table 'global' in field list +SELECT max_write_lock_count = @@global.max_write_lock_count; +ERROR 42S22: Unknown column 'max_write_lock_count' in 'field list' +SET @@global.max_write_lock_count = @start_global_value; +SELECT @@global.max_write_lock_count; +@@global.max_write_lock_count +4294967295 |