diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/new_basic.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/new_basic.result | 163 |
1 files changed, 163 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/new_basic.result b/mysql-test/suite/sys_vars/r/new_basic.result new file mode 100644 index 00000000000..b36e540ddd9 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/new_basic.result @@ -0,0 +1,163 @@ +SET @start_global_value = @@global.new; +SELECT @start_global_value; +@start_global_value +0 +SET @start_session_value = @@session.new; +SELECT @start_session_value; +@start_session_value +0 +'#--------------------FN_DYNVARS_113_01-------------------------#' +SET @@global.new = ON; +SET @@global.new = DEFAULT; +SELECT @@global.new; +@@global.new +0 +SET @@session.new = ON; +SET @@session.new = DEFAULT; +SELECT @@session.new; +@@session.new +0 +'#--------------------FN_DYNVARS_113_02-------------------------#' +SET @@global.new = DEFAULT; +SELECT @@global.new = 'OFF'; +@@global.new = 'OFF' +1 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'OFF' +SET @@session.new = DEFAULT; +SELECT @@session.new = 'OFF'; +@@session.new = 'OFF' +1 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'OFF' +'#--------------------FN_DYNVARS_113_03-------------------------#' +SET @@global.new = ON; +SELECT @@global.new; +@@global.new +1 +SET @@global.new = OFF; +SELECT @@global.new; +@@global.new +0 +SET @@global.new = 0; +SELECT @@global.new; +@@global.new +0 +SET @@global.new = 1; +SELECT @@global.new; +@@global.new +1 +SET @@global.new = TRUE; +SELECT @@global.new; +@@global.new +1 +SET @@global.new = FALSE; +SELECT @@global.new; +@@global.new +0 +'#--------------------FN_DYNVARS_113_04-------------------------#' +SET @@session.new = ON; +SELECT @@session.new; +@@session.new +1 +SET @@session.new = OFF; +SELECT @@session.new; +@@session.new +0 +SET @@session.new = 0; +SELECT @@session.new; +@@session.new +0 +SET @@session.new = 1; +SELECT @@session.new; +@@session.new +1 +SET @@session.new = TRUE; +SELECT @@session.new; +@@session.new +1 +SET @@session.new = FALSE; +SELECT @@session.new; +@@session.new +0 +'#------------------FN_DYNVARS_113_05-----------------------#' +SET @@global.new = 'ONN'; +ERROR 42000: Variable 'new' can't be set to the value of 'ONN' +SET @@global.new = "OFFF"; +ERROR 42000: Variable 'new' can't be set to the value of 'OFFF' +SET @@global.new = TTRUE; +ERROR 42000: Variable 'new' can't be set to the value of 'TTRUE' +SET @@global.new = FELSE; +ERROR 42000: Variable 'new' can't be set to the value of 'FELSE' +SET @@global.new = -1024; +ERROR 42000: Variable 'new' can't be set to the value of '-1024' +SET @@global.new = 65536; +ERROR 42000: Variable 'new' can't be set to the value of '65536' +SET @@global.new = 65530.34; +ERROR 42000: Variable 'new' can't be set to the value of '65530' +SET @@global.new = test; +ERROR 42000: Variable 'new' can't be set to the value of 'test' +SET @@session.new = ONN; +ERROR 42000: Variable 'new' can't be set to the value of 'ONN' +SET @@session.new = ONF; +ERROR 42000: Variable 'new' can't be set to the value of 'ONF' +SET @@session.new = OF; +SELECT @@session.new; +@@session.new +0 +'Bug# 34828: FN_DYNVARS_113_05 - OF is also working as OFF and no error is coming'; +SET @@session.new = 'OFN'; +ERROR 42000: Variable 'new' can't be set to the value of 'OFN' +SET @@session.new = -2; +ERROR 42000: Variable 'new' can't be set to the value of '-2' +SET @@session.new = 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.new = 65550; +ERROR 42000: Variable 'new' can't be set to the value of '65550' +SET @@session.new = test; +ERROR 42000: Variable 'new' can't be set to the value of 'test' +'#------------------FN_DYNVARS_113_06-----------------------#' +SELECT @@global.new = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='new'; +@@global.new = VARIABLE_VALUE +1 +'#------------------FN_DYNVARS_113_07-----------------------#' +SELECT @@session.new = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.SESSION_VARIABLES +WHERE VARIABLE_NAME='new'; +@@session.new = VARIABLE_VALUE +1 +'#---------------------FN_DYNVARS_113_08----------------------#' +SET @@new = OFF; +SET @@global.new = ON; +SELECT @@new = @@global.new; +@@new = @@global.new +0 +'#---------------------FN_DYNVARS_113_09----------------------#' +SET @@new = ON; +SELECT @@new = @@local.new; +@@new = @@local.new +1 +SELECT @@local.new = @@session.new; +@@local.new = @@session.new +1 +'#---------------------FN_DYNVARS_113_10----------------------#' +SET new = 1; +SELECT @@new; +@@new +1 +SELECT local.new; +ERROR 42S02: Unknown table 'local' in field list +SELECT session.new; +ERROR 42S02: Unknown table 'session' in field list +SELECT new = @@session.new; +ERROR 42S22: Unknown column 'new' in 'field list' +SET @@global.new = @start_global_value; +SELECT @@global.new; +@@global.new +0 +SET @@session.new = @start_session_value; +SELECT @@session.new; +@@session.new +0 |