Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_stats_transient_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_transient_sample_pages;
9 SELECT @start_global_value;
10
11 #
12 # exists as global only
13 #
14 --echo Valid values are one or above
15 SELECT @@global.innodb_stats_transient_sample_pages >=1;
16 SELECT @@global.innodb_stats_transient_sample_pages;
17 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
18 SELECT @@session.innodb_stats_transient_sample_pages;
19 SHOW global variables LIKE 'innodb_stats_transient_sample_pages';
20 SHOW session variables LIKE 'innodb_stats_transient_sample_pages';
21 --disable_warnings
22 SELECT * FROM information_schema.global_variables
23 WHERE variable_name='innodb_stats_transient_sample_pages';
24 SELECT * FROM information_schema.session_variables
25 WHERE variable_name='innodb_stats_transient_sample_pages';
26 --enable_warnings
27
28 #
29 # show the default value
30 #
31 set global innodb_stats_transient_sample_pages=DEFAULT;
32 select @@global.innodb_stats_transient_sample_pages;
33
34 #
35 # SHOW that it's writable
36 #
37 SET global innodb_stats_transient_sample_pages=10;
38 SELECT @@global.innodb_stats_transient_sample_pages;
39 --disable_warnings
40 SELECT * FROM information_schema.global_variables
41 WHERE variable_name='innodb_stats_transient_sample_pages';
42 SELECT * FROM information_schema.session_variables
43 WHERE variable_name='innodb_stats_transient_sample_pages';
44 --enable_warnings
45 --error ER_GLOBAL_VARIABLE
46 SET session innodb_stats_transient_sample_pages=1;
47
48 #
49 # incorrect types
50 #
51 --error ER_WRONG_TYPE_FOR_VAR
52 SET global innodb_stats_transient_sample_pages=1.1;
53 --error ER_WRONG_TYPE_FOR_VAR
54 SET global innodb_stats_transient_sample_pages=1e1;
55 --error ER_WRONG_TYPE_FOR_VAR
56 SET global innodb_stats_transient_sample_pages="foo";
57 --error ER_WRONG_TYPE_FOR_VAR
58 SET global innodb_stats_transient_sample_pages=' ';
59
60 SET global innodb_stats_transient_sample_pages=-7;
61 SELECT @@global.innodb_stats_transient_sample_pages;
62 --disable_warnings
63 SELECT * FROM information_schema.global_variables
64 WHERE variable_name='innodb_stats_transient_sample_pages';
65 --enable_warnings
66
67 #
68 # cleanup
69 #
70 SET @@global.innodb_stats_transient_sample_pages = @start_global_value;
71 SELECT @@global.innodb_stats_transient_sample_pages;