← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/r/innodb_thread_sleep_delay_basic.result

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/innodb_thread_sleep_delay_basic.result
 
1
SET @global_start_value = @@global.innodb_thread_sleep_delay;
 
2
SELECT @global_start_value;
 
3
@global_start_value
 
4
10000
 
5
'#--------------------FN_DYNVARS_046_01------------------------#'
 
6
SET @@global.innodb_thread_sleep_delay = 0;
 
7
SET @@global.innodb_thread_sleep_delay = DEFAULT;
 
8
SELECT @@global.innodb_thread_sleep_delay;
 
9
@@global.innodb_thread_sleep_delay
 
10
10000
 
11
'#---------------------FN_DYNVARS_046_02-------------------------#'
 
12
SET innodb_thread_sleep_delay = 1;
 
13
ERROR HY000: Variable 'innodb_thread_sleep_delay' is a GLOBAL variable and should be set with SET GLOBAL
 
14
SELECT @@innodb_thread_sleep_delay;
 
15
@@innodb_thread_sleep_delay
 
16
10000
 
17
SELECT local.innodb_thread_sleep_delay;
 
18
ERROR 42S02: Unknown table 'local' in field list
 
19
SET global innodb_thread_sleep_delay = 0;
 
20
SELECT @@global.innodb_thread_sleep_delay;
 
21
@@global.innodb_thread_sleep_delay
 
22
0
 
23
'#--------------------FN_DYNVARS_046_03------------------------#'
 
24
SET @@global.innodb_thread_sleep_delay = 0;
 
25
SELECT @@global.innodb_thread_sleep_delay;
 
26
@@global.innodb_thread_sleep_delay
 
27
0
 
28
SET @@global.innodb_thread_sleep_delay = 1;
 
29
SELECT @@global.innodb_thread_sleep_delay;
 
30
@@global.innodb_thread_sleep_delay
 
31
1
 
32
SET @@global.innodb_thread_sleep_delay = 4294967295;
 
33
SELECT @@global.innodb_thread_sleep_delay;
 
34
@@global.innodb_thread_sleep_delay
 
35
4294967295
 
36
'#--------------------FN_DYNVARS_046_04-------------------------#'
 
37
SET @@global.innodb_thread_sleep_delay = -1;
 
38
SELECT @@global.innodb_autoextend_increment;
 
39
@@global.innodb_autoextend_increment
 
40
8
 
41
SET @@global.innodb_thread_sleep_delay = "T";
 
42
ERROR 42000: Incorrect argument type to variable 'innodb_thread_sleep_delay'
 
43
SELECT @@global.innodb_autoextend_increment;
 
44
@@global.innodb_autoextend_increment
 
45
8
 
46
SET @@global.innodb_thread_sleep_delay = "Y";
 
47
ERROR 42000: Incorrect argument type to variable 'innodb_thread_sleep_delay'
 
48
SELECT @@global.innodb_autoextend_increment;
 
49
@@global.innodb_autoextend_increment
 
50
8
 
51
SET @@global.innodb_thread_sleep_delay = 1001;
 
52
SELECT @@global.innodb_autoextend_increment;
 
53
@@global.innodb_autoextend_increment
 
54
8
 
55
'#----------------------FN_DYNVARS_046_05------------------------#'
 
56
SELECT @@global.innodb_thread_sleep_delay = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_thread_sleep_delay';
 
57
@@global.innodb_thread_sleep_delay = VARIABLE_VALUE
 
58
1
 
59
SELECT @@global.innodb_thread_sleep_delay;
 
60
@@global.innodb_thread_sleep_delay
 
61
1001
 
62
SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_thread_sleep_delay';
 
63
VARIABLE_VALUE
 
64
1001
 
65
'#---------------------FN_DYNVARS_046_06-------------------------#'
 
66
SET @@global.innodb_thread_sleep_delay = OFF;
 
67
ERROR 42000: Incorrect argument type to variable 'innodb_thread_sleep_delay'
 
68
SELECT @@global.innodb_thread_sleep_delay;
 
69
@@global.innodb_thread_sleep_delay
 
70
1001
 
71
SET @@global.innodb_thread_sleep_delay = ON;
 
72
ERROR 42000: Incorrect argument type to variable 'innodb_thread_sleep_delay'
 
73
SELECT @@global.innodb_thread_sleep_delay;
 
74
@@global.innodb_thread_sleep_delay
 
75
1001
 
76
'#---------------------FN_DYNVARS_046_07----------------------#'
 
77
SET @@global.innodb_thread_sleep_delay = TRUE;
 
78
SELECT @@global.innodb_thread_sleep_delay;
 
79
@@global.innodb_thread_sleep_delay
 
80
1
 
81
SET @@global.innodb_thread_sleep_delay = FALSE;
 
82
SELECT @@global.innodb_thread_sleep_delay;
 
83
@@global.innodb_thread_sleep_delay
 
84
0