Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_stats_persistent_sample_pages_basic.test

raw
1
2 #
3 # 2010-01-25 - Added
4 #
5
6 --source include/have_innodb.inc
7
8 SET @start_global_value = @@global.innodb_stats_persistent_sample_pages;
9 SELECT @start_global_value;
10
11 #
12 # exists as global only
13 #
14 --echo Valid values are zero or above
15 SELECT @@global.innodb_stats_persistent_sample_pages >=0;
16 SELECT @@global.innodb_stats_persistent_sample_pages;
17 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
18 SELECT @@session.innodb_stats_persistent_sample_pages;
19 SHOW global variables LIKE 'innodb_stats_persistent_sample_pages';
20 SHOW session variables LIKE 'innodb_stats_persistent_sample_pages';
21 --disable_warnings
22 SELECT * FROM information_schema.global_variables
23 WHERE variable_name='innodb_stats_persistent_sample_pages';
24 SELECT * FROM information_schema.session_variables
25 WHERE variable_name='innodb_stats_persistent_sample_pages';
26 --enable_warnings
27
28 #
29 # SHOW that it's writable
30 #
31 SET global innodb_stats_persistent_sample_pages=10;
32 SELECT @@global.innodb_stats_persistent_sample_pages;
33 --disable_warnings
34 SELECT * FROM information_schema.global_variables
35 WHERE variable_name='innodb_stats_persistent_sample_pages';
36 SELECT * FROM information_schema.session_variables
37 WHERE variable_name='innodb_stats_persistent_sample_pages';
38 --enable_warnings
39 --error ER_GLOBAL_VARIABLE
40 SET session innodb_stats_persistent_sample_pages=1;
41
42 #
43 # show the default value
44 #
45 set global innodb_stats_persistent_sample_pages=DEFAULT;
46 select @@global.innodb_stats_persistent_sample_pages;
47
48 #
49 # valid values
50 #
51 SET global innodb_stats_persistent_sample_pages=0;
52 SELECT @@global.innodb_stats_persistent_sample_pages;
53
54 SET global innodb_stats_persistent_sample_pages=10;
55 SELECT @@global.innodb_stats_persistent_sample_pages;
56
57
58
59
60 #
61 # incorrect types
62 #
63 --error ER_WRONG_TYPE_FOR_VAR
64 SET global innodb_stats_persistent_sample_pages=1.1;
65 --error ER_WRONG_TYPE_FOR_VAR
66 SET global innodb_stats_persistent_sample_pages=1e1;
67 --error ER_WRONG_TYPE_FOR_VAR
68 SET global innodb_stats_persistent_sample_pages="foo";
69 --error ER_WRONG_TYPE_FOR_VAR
70 SET global innodb_stats_persistent_sample_pages=' ';
71 SELECT @@global.innodb_stats_persistent_sample_pages;
72 --error ER_WRONG_TYPE_FOR_VAR
73 SET global innodb_stats_persistent_sample_pages=" ";
74 SELECT @@global.innodb_stats_persistent_sample_pages;
75 SET global innodb_stats_persistent_sample_pages=-7;
76 SELECT @@global.innodb_stats_persistent_sample_pages;
77 --disable_warnings
78 SELECT * FROM information_schema.global_variables
79 WHERE variable_name='innodb_stats_persistent_sample_pages';
80 --enable_warnings
81
82
83 #
84 # cleanup
85 #
86 SET @@global.innodb_stats_persistent_sample_pages = @start_global_value;
87 SELECT @@global.innodb_stats_persistent_sample_pages;