diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/innodb_commit_concurrency_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_commit_concurrency_basic.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_commit_concurrency_basic.result b/mysql-test/suite/sys_vars/r/innodb_commit_concurrency_basic.result index 85a4b008ff0..474818829c5 100644 --- a/mysql-test/suite/sys_vars/r/innodb_commit_concurrency_basic.result +++ b/mysql-test/suite/sys_vars/r/innodb_commit_concurrency_basic.result @@ -28,14 +28,34 @@ SELECT @@global.innodb_commit_concurrency; '#--------------------FN_DYNVARS_046_04-------------------------#' SET @@global.innodb_commit_concurrency = 1; ERROR 42000: Variable 'innodb_commit_concurrency' can't be set to the value of '1' +SELECT @@global.innodb_commit_concurrency; +@@global.innodb_commit_concurrency +0 SET @@global.innodb_commit_concurrency = -1; ERROR 42000: Variable 'innodb_commit_concurrency' can't be set to the value of '-1' +SELECT @@global.innodb_commit_concurrency; +@@global.innodb_commit_concurrency +0 SET @@global.innodb_commit_concurrency = "T"; ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency' +SELECT @@global.innodb_commit_concurrency; +@@global.innodb_commit_concurrency +0 SET @@global.innodb_commit_concurrency = "Y"; ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency' +SELECT @@global.innodb_commit_concurrency; +@@global.innodb_commit_concurrency +0 +SET @@global.innodb_commit_concurrency = 1.1; +ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency' +SELECT @@global.innodb_commit_concurrency; +@@global.innodb_commit_concurrency +0 SET @@global.innodb_commit_concurrency = 1001; ERROR 42000: Variable 'innodb_commit_concurrency' can't be set to the value of '1001' +SELECT @@global.innodb_commit_concurrency; +@@global.innodb_commit_concurrency +0 '#----------------------FN_DYNVARS_046_05------------------------#' SELECT @@global.innodb_commit_concurrency = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES |