diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/innodb_replication_delay_basic.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_replication_delay_basic.result | 34 |
1 files changed, 24 insertions, 10 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_replication_delay_basic.result b/mysql-test/suite/sys_vars/r/innodb_replication_delay_basic.result index 5e0fb425f6b..53a499ff34b 100644 --- a/mysql-test/suite/sys_vars/r/innodb_replication_delay_basic.result +++ b/mysql-test/suite/sys_vars/r/innodb_replication_delay_basic.result @@ -24,33 +24,43 @@ select * from information_schema.session_variables where variable_name='innodb_r VARIABLE_NAME VARIABLE_VALUE INNODB_REPLICATION_DELAY 0 set global innodb_replication_delay=10; +Warnings: +Warning 138 The parameter innodb_replication_delay is deprecated and has no effect. select @@global.innodb_replication_delay; @@global.innodb_replication_delay -10 +0 select * from information_schema.global_variables where variable_name='innodb_replication_delay'; VARIABLE_NAME VARIABLE_VALUE -INNODB_REPLICATION_DELAY 10 +INNODB_REPLICATION_DELAY 0 select * from information_schema.session_variables where variable_name='innodb_replication_delay'; VARIABLE_NAME VARIABLE_VALUE -INNODB_REPLICATION_DELAY 10 +INNODB_REPLICATION_DELAY 0 set session innodb_replication_delay=1; ERROR HY000: Variable 'innodb_replication_delay' is a GLOBAL variable and should be set with SET GLOBAL set global innodb_replication_delay=DEFAULT; +Warnings: +Warning 138 The parameter innodb_replication_delay is deprecated and has no effect. select @@global.innodb_replication_delay; @@global.innodb_replication_delay 0 set global innodb_replication_delay=0; +Warnings: +Warning 138 The parameter innodb_replication_delay is deprecated and has no effect. select @@global.innodb_replication_delay; @@global.innodb_replication_delay 0 set global innodb_replication_delay=65535; +Warnings: +Warning 138 The parameter innodb_replication_delay is deprecated and has no effect. select @@global.innodb_replication_delay; @@global.innodb_replication_delay -65535 +0 set global innodb_replication_delay=4294967295; +Warnings: +Warning 138 The parameter innodb_replication_delay is deprecated and has no effect. select @@global.innodb_replication_delay; @@global.innodb_replication_delay -4294967295 +0 set global innodb_replication_delay=1.1; ERROR 42000: Incorrect argument type to variable 'innodb_replication_delay' set global innodb_replication_delay=1e1; @@ -61,21 +71,23 @@ set global innodb_replication_delay=' '; ERROR 42000: Incorrect argument type to variable 'innodb_replication_delay' select @@global.innodb_replication_delay; @@global.innodb_replication_delay -4294967295 +0 set global innodb_replication_delay=" "; ERROR 42000: Incorrect argument type to variable 'innodb_replication_delay' select @@global.innodb_replication_delay; @@global.innodb_replication_delay -4294967295 +0 set global innodb_replication_delay=-7; Warnings: Warning 1292 Truncated incorrect innodb_replication_delay value: '-7' +Warning 138 The parameter innodb_replication_delay is deprecated and has no effect. select @@global.innodb_replication_delay; @@global.innodb_replication_delay 0 set global innodb_replication_delay=-1024; Warnings: Warning 1292 Truncated incorrect innodb_replication_delay value: '-1024' +Warning 138 The parameter innodb_replication_delay is deprecated and has no effect. select @@global.innodb_replication_delay; @@global.innodb_replication_delay 0 @@ -85,16 +97,18 @@ INNODB_REPLICATION_DELAY 0 SET @@global.innodb_replication_delay = 4294967296; SELECT @@global.innodb_replication_delay IN (4294967296,4294967295); @@global.innodb_replication_delay IN (4294967296,4294967295) -1 +0 SET @@global.innodb_replication_delay = 12345678901; SELECT @@global.innodb_replication_delay IN (12345678901,4294967295); @@global.innodb_replication_delay IN (12345678901,4294967295) -1 +0 SET @@global.innodb_replication_delay = 18446744073709551615; SELECT @@global.innodb_replication_delay IN (18446744073709551615,4294967295); @@global.innodb_replication_delay IN (18446744073709551615,4294967295) -1 +0 SET @@global.innodb_replication_delay = @start_global_value; +Warnings: +Warning 138 The parameter innodb_replication_delay is deprecated and has no effect. SELECT @@global.innodb_replication_delay; @@global.innodb_replication_delay 0 |