forked from facebook/mysql-5.6
-
Notifications
You must be signed in to change notification settings - Fork 0
/
rpl_semi_sync_source_histogram_trx_wait_step_size_basic.result
75 lines (75 loc) · 3.98 KB
/
rpl_semi_sync_source_histogram_trx_wait_step_size_basic.result
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
SELECT COUNT(@@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size);
COUNT(@@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size)
1
1 Expected
SET @start_global_value = @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size;
SELECT @start_global_value;
@start_global_value
500us
16ms Expected
SET @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size='16us';
select @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size;
@@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size
16us
16us Expected
select * from performance_schema.global_variables where variable_name='rpl_semi_sync_master_histogram_trx_wait_step_size';
VARIABLE_NAME VARIABLE_VALUE
rpl_semi_sync_master_histogram_trx_wait_step_size 16us
SELECT @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size = VARIABLE_VALUE
FROM performance_schema.global_variables
WHERE VARIABLE_NAME='rpl_semi_sync_master_histogram_trx_wait_step_size';
@@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size = VARIABLE_VALUE
1
1 Expected
SELECT COUNT(@@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size);
COUNT(@@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size)
1
1 Expected
SELECT COUNT(VARIABLE_VALUE)
FROM performance_schema.global_variables
WHERE VARIABLE_NAME='rpl_semi_sync_master_histogram_trx_wait_step_size';
COUNT(VARIABLE_VALUE)
1
1 Expected
SELECT COUNT(@@local.rpl_semi_sync_master_histogram_trx_wait_step_size);
ERROR HY000: Variable 'rpl_semi_sync_master_histogram_trx_wait_step_size' is a GLOBAL variable
Expected error 'Variable is a GLOBAL variable'
SELECT COUNT(@@SESSION.rpl_semi_sync_master_histogram_trx_wait_step_size);
ERROR HY000: Variable 'rpl_semi_sync_master_histogram_trx_wait_step_size' is a GLOBAL variable
Expected error 'Variable is a GLOBAL variable'
SET @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size='32';
ERROR 42000: Variable 'rpl_semi_sync_master_histogram_trx_wait_step_size' can't be set to the value of '32'
Expected error 'Variable cannot be set to this value';
SET @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size='0';
select @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size;
@@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size
0
0 Expected
SET @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size='ms32';
ERROR 42000: Variable 'rpl_semi_sync_master_histogram_trx_wait_step_size' can't be set to the value of 'ms32'
Expected error 'Variable cannot be set to this value';
SET @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size='32ps';
ERROR 42000: Variable 'rpl_semi_sync_master_histogram_trx_wait_step_size' can't be set to the value of '32ps'
Expected error 'Variable cannot be set to this value';
SET @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size='3s2';
ERROR 42000: Variable 'rpl_semi_sync_master_histogram_trx_wait_step_size' can't be set to the value of '3s2'
Expected error 'Variable cannot be set to this value';
SET @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size='32@s';
ERROR 42000: Variable 'rpl_semi_sync_master_histogram_trx_wait_step_size' can't be set to the value of '32@s'
Expected error 'Variable cannot be set to this value';
SET @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size='32s.';
ERROR 42000: Variable 'rpl_semi_sync_master_histogram_trx_wait_step_size' can't be set to the value of '32s.'
Expected error 'Variable cannot be set to this value';
SET @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size='s';
ERROR 42000: Variable 'rpl_semi_sync_master_histogram_trx_wait_step_size' can't be set to the value of 's'
Expected error 'Variable cannot be set to this value'
SET @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size='16.5us';
select @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size;
@@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size
16.5us
16.5us Expected
SET @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size = @start_global_value;
SELECT @@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size;
@@GLOBAL.rpl_semi_sync_master_histogram_trx_wait_step_size
500us
16ms Expected