diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/maria_group_commit_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/maria_group_commit_basic.result | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/maria_group_commit_basic.result b/mysql-test/suite/sys_vars/r/maria_group_commit_basic.result new file mode 100644 index 00000000000..7e97d379403 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/maria_group_commit_basic.result @@ -0,0 +1,47 @@ +SET @start_global_value = @@global.maria_group_commit; +select @@global.maria_group_commit, @@global.aria_group_commit; +@@global.maria_group_commit @@global.aria_group_commit +none none +select @@session.maria_group_commit, @@session.aria_group_commit; +ERROR HY000: Variable 'maria_group_commit' is a GLOBAL variable +show global variables like '%aria_group_commit'; +Variable_name Value +aria_group_commit none +maria_group_commit none +show session variables like '%aria_group_commit'; +Variable_name Value +aria_group_commit none +maria_group_commit none +select * from information_schema.global_variables where variable_name='maria_group_commit'; +VARIABLE_NAME VARIABLE_VALUE +MARIA_GROUP_COMMIT none +select * from information_schema.session_variables where variable_name='maria_group_commit'; +VARIABLE_NAME VARIABLE_VALUE +MARIA_GROUP_COMMIT none +set global maria_group_commit=1; +select @@global.maria_group_commit, @@global.aria_group_commit; +@@global.maria_group_commit @@global.aria_group_commit +hard hard +set session maria_group_commit=1; +ERROR HY000: Variable 'maria_group_commit' is a GLOBAL variable and should be set with SET GLOBAL +set global maria_group_commit=none; +select @@global.maria_group_commit, @@global.aria_group_commit; +@@global.maria_group_commit @@global.aria_group_commit +none none +set global maria_group_commit=hard; +select @@global.maria_group_commit, @@global.aria_group_commit; +@@global.maria_group_commit @@global.aria_group_commit +hard hard +set global maria_group_commit=soft; +select @@global.maria_group_commit, @@global.aria_group_commit; +@@global.maria_group_commit @@global.aria_group_commit +soft soft +set global maria_group_commit=1.1; +ERROR 42000: Incorrect argument type to variable 'maria_group_commit' +set global maria_group_commit=1e1; +ERROR 42000: Incorrect argument type to variable 'maria_group_commit' +set global maria_group_commit="foo"; +ERROR 42000: Variable 'maria_group_commit' can't be set to the value of 'foo' +set global maria_group_commit=3; +ERROR 42000: Variable 'maria_group_commit' can't be set to the value of '3' +SET @@global.maria_group_commit = @start_global_value; |