blob: 062753f27eac1a5d499bd3ad2bec9551f508e9d8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
--source include/have_innodb.inc
SET @start_innodb_defragment_stats_accuracy = @@global.innodb_defragment_stats_accuracy;
SELECT @start_innodb_defragment_stats_accuracy;
SELECT COUNT(@@global.innodb_defragment_stats_accuracy);
SET @@global.innodb_defragment_stats_accuracy = 1;
SELECT @@global.innodb_defragment_stats_accuracy;
SET @@global.innodb_defragment_stats_accuracy = 1000;
SELECT @@global.innodb_defragment_stats_accuracy;
SET @@global.innodb_defragment_stats_accuracy = -1;
SELECT @@global.innodb_defragment_stats_accuracy;
SET @@global.innodb_defragment_stats_accuracy = 1000000000000;
SELECT @@global.innodb_defragment_stats_accuracy;
--Error ER_WRONG_TYPE_FOR_VAR
SET @@global.innodb_defragment_stats_accuracy = "abc";
SELECT @@global.innodb_defragment_stats_accuracy;
SET @@global.innodb_defragment_stats_accuracy = @start_innodb_defragment_stats_accuracy;
|