diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/innodb_defragment_basic.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_defragment_basic.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_defragment_basic.result b/mysql-test/suite/sys_vars/r/innodb_defragment_basic.result new file mode 100644 index 00000000000..916bb5ca1a9 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/innodb_defragment_basic.result @@ -0,0 +1,18 @@ +SET @orig = @@global.innodb_defragment; +SELECT @orig; +@orig +0 +SET GLOBAL innodb_defragment = OFF; +SELECT @@global.innodb_defragment; +@@global.innodb_defragment +0 +SET GLOBAL innodb_defragment = ON; +SELECT @@global.innodb_defragment; +@@global.innodb_defragment +1 +SET GLOBAL innodb_defragment = 100; +ERROR 42000: Variable 'innodb_defragment' can't be set to the value of '100' +SELECT @@global.innodb_defragment; +@@global.innodb_defragment +1 +SET GLOBAL innodb_defragment = @orig; |