diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/concurrent_insert_basic.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/concurrent_insert_basic.result | 71 |
1 files changed, 38 insertions, 33 deletions
diff --git a/mysql-test/suite/sys_vars/r/concurrent_insert_basic.result b/mysql-test/suite/sys_vars/r/concurrent_insert_basic.result index 1ea9c37c2a1..996a5e93717 100644 --- a/mysql-test/suite/sys_vars/r/concurrent_insert_basic.result +++ b/mysql-test/suite/sys_vars/r/concurrent_insert_basic.result @@ -1,65 +1,70 @@ SET @start_value = @@global.concurrent_insert; SELECT @start_value; @start_value -1 +AUTO '#--------------------FN_DYNVARS_018_01------------------------#' SET @@global.concurrent_insert = 0; SET @@global.concurrent_insert = DEFAULT; SELECT @@global.concurrent_insert; @@global.concurrent_insert -1 +AUTO '#---------------------FN_DYNVARS_018_02-------------------------#' SET @@global.concurrent_insert = DEFAULT; SELECT @@global.concurrent_insert = 1; @@global.concurrent_insert = 1 -1 +0 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'AUTO' '#--------------------FN_DYNVARS_018_03------------------------#' SET @@global.concurrent_insert = 0; SELECT @@global.concurrent_insert; @@global.concurrent_insert -0 +NEVER SET @@global.concurrent_insert = 1; SELECT @@global.concurrent_insert; @@global.concurrent_insert -1 +AUTO SET @@global.concurrent_insert = 2; SELECT @@global.concurrent_insert; @@global.concurrent_insert -2 +ALWAYS +SET @@global.concurrent_insert = NEVER; +SELECT @@global.concurrent_insert; +@@global.concurrent_insert +NEVER +SET @@global.concurrent_insert = AUTO; +SELECT @@global.concurrent_insert; +@@global.concurrent_insert +AUTO +SET @@global.concurrent_insert = ALWAYS; +SELECT @@global.concurrent_insert; +@@global.concurrent_insert +ALWAYS '#--------------------FN_DYNVARS_018_04-------------------------#' SET @@global.concurrent_insert = -1; -Warnings: -Warning 1292 Truncated incorrect concurrent_insert value: '-1' -Select @@global.concurrent_insert; -@@global.concurrent_insert -0 +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of '-1' SET @@global.concurrent_insert = 100; -Warnings: -Warning 1292 Truncated incorrect concurrent_insert value: '100' -Select @@global.concurrent_insert; -@@global.concurrent_insert -2 -'Bug # 34837: Errors are not coming on assigning invalid values to variable' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of '100' SET @@global.concurrent_insert = TRUEF; -ERROR 42000: Incorrect argument type to variable 'concurrent_insert' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'TRUEF' SET @@global.concurrent_insert = TRUE_F; -ERROR 42000: Incorrect argument type to variable 'concurrent_insert' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'TRUE_F' SET @@global.concurrent_insert = FALSE0; -ERROR 42000: Incorrect argument type to variable 'concurrent_insert' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'FALSE0' SET @@global.concurrent_insert = OON; -ERROR 42000: Incorrect argument type to variable 'concurrent_insert' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'OON' SET @@global.concurrent_insert = ONN; -ERROR 42000: Incorrect argument type to variable 'concurrent_insert' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'ONN' SET @@global.concurrent_insert = OOFF; -ERROR 42000: Incorrect argument type to variable 'concurrent_insert' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'OOFF' SET @@global.concurrent_insert = 0FF; -ERROR 42000: Incorrect argument type to variable 'concurrent_insert' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of '0FF' SET @@global.concurrent_insert = ' '; -ERROR 42000: Incorrect argument type to variable 'concurrent_insert' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of ' ' SET @@global.concurrent_insert = " "; -ERROR 42000: Incorrect argument type to variable 'concurrent_insert' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of ' ' SET @@global.concurrent_insert = ''; -ERROR 42000: Incorrect argument type to variable 'concurrent_insert' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of '' '#-------------------FN_DYNVARS_018_05----------------------------#' SET @@session.concurrent_insert = 1; ERROR HY000: Variable 'concurrent_insert' is a GLOBAL variable and should be set with SET GLOBAL @@ -73,18 +78,18 @@ WHERE VARIABLE_NAME='concurrent_insert'; 1 '#---------------------FN_DYNVARS_018_07----------------------#' SET @@global.concurrent_insert = OFF; -ERROR 42000: Incorrect argument type to variable 'concurrent_insert' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'OFF' SET @@global.concurrent_insert = ON; -ERROR 42000: Incorrect argument type to variable 'concurrent_insert' +ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'ON' '#---------------------FN_DYNVARS_018_08----------------------#' SET @@global.concurrent_insert = TRUE; SELECT @@global.concurrent_insert; @@global.concurrent_insert -1 +AUTO SET @@global.concurrent_insert = FALSE; SELECT @@global.concurrent_insert; @@global.concurrent_insert -0 +NEVER '#---------------------FN_DYNVARS_018_09----------------------#' SET @@global.concurrent_insert = 1; SELECT @@concurrent_insert = @@global.concurrent_insert; @@ -95,7 +100,7 @@ SET concurrent_insert = 1; ERROR HY000: Variable 'concurrent_insert' is a GLOBAL variable and should be set with SET GLOBAL SELECT @@concurrent_insert; @@concurrent_insert -1 +AUTO SET global.concurrent_insert = 1; 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 'concurrent_insert = 1' at line 1 SELECT global.concurrent_insert; @@ -105,4 +110,4 @@ ERROR 42S22: Unknown column 'concurrent_insert' in 'field list' SET @@global.concurrent_insert = @start_value; SELECT @@global.concurrent_insert; @@global.concurrent_insert -1 +AUTO |