Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_concurrency_tickets_basic.result

raw
1 SET @global_start_value = @@global.innodb_concurrency_tickets;
2 SELECT @global_start_value;
3 @global_start_value
4 5000
5 '#--------------------FN_DYNVARS_046_01------------------------#'
6 SET @@global.innodb_concurrency_tickets = 0;
7 Warnings:
8 Warning 1292 Truncated incorrect innodb_concurrency_tickets value: '0'
9 SET @@global.innodb_concurrency_tickets = DEFAULT;
10 SELECT @@global.innodb_concurrency_tickets;
11 @@global.innodb_concurrency_tickets
12 5000
13 '#---------------------FN_DYNVARS_046_02-------------------------#'
14 SET innodb_concurrency_tickets = 1;
15 ERROR HY000: Variable 'innodb_concurrency_tickets' is a GLOBAL variable and should be set with SET GLOBAL
16 SELECT @@innodb_concurrency_tickets;
17 @@innodb_concurrency_tickets
18 5000
19 SELECT local.innodb_concurrency_tickets;
20 ERROR 42S02: Unknown table 'local' in field list
21 SET global innodb_concurrency_tickets = 0;
22 Warnings:
23 Warning 1292 Truncated incorrect innodb_concurrency_tickets value: '0'
24 SELECT @@global.innodb_concurrency_tickets;
25 @@global.innodb_concurrency_tickets
26 1
27 '#--------------------FN_DYNVARS_046_03------------------------#'
28 SET @@global.innodb_concurrency_tickets = 1;
29 SELECT @@global.innodb_concurrency_tickets;
30 @@global.innodb_concurrency_tickets
31 1
32 SET @@global.innodb_concurrency_tickets = 1000;
33 SELECT @@global.innodb_concurrency_tickets;
34 @@global.innodb_concurrency_tickets
35 1000
36 SET @@global.innodb_concurrency_tickets = 4294967295;
37 SELECT @@global.innodb_concurrency_tickets;
38 @@global.innodb_concurrency_tickets
39 4294967295
40 '#--------------------FN_DYNVARS_046_04-------------------------#'
41 SET @@global.innodb_concurrency_tickets = 4294967296;
42 SELECT @@global.innodb_concurrency_tickets IN (4294967296,4294967295);
43 @@global.innodb_concurrency_tickets IN (4294967296,4294967295)
44 1
45 SET @@global.innodb_concurrency_tickets = 12345678901;
46 SELECT @@global.innodb_concurrency_tickets IN (12345678901,4294967295);
47 @@global.innodb_concurrency_tickets IN (12345678901,4294967295)
48 1
49 SET @@global.innodb_concurrency_tickets = 18446744073709551615;
50 SELECT @@global.innodb_concurrency_tickets IN (18446744073709551615,4294967295);
51 @@global.innodb_concurrency_tickets IN (18446744073709551615,4294967295)
52 1
53 '#--------------------FN_DYNVARS_046_05-------------------------#'
54 SET @@global.innodb_concurrency_tickets = -1;
55 Warnings:
56 Warning 1292 Truncated incorrect innodb_concurrency_tickets value: '-1'
57 SELECT @@global.innodb_concurrency_tickets;
58 @@global.innodb_concurrency_tickets
59 1
60 SET @@global.innodb_concurrency_tickets = -1024;
61 Warnings:
62 Warning 1292 Truncated incorrect innodb_concurrency_tickets value: '-1024'
63 SELECT @@global.innodb_concurrency_tickets;
64 @@global.innodb_concurrency_tickets
65 1
66 SET @@global.innodb_concurrency_tickets = "T";
67 ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets'
68 SELECT @@global.innodb_concurrency_tickets;
69 @@global.innodb_concurrency_tickets
70 1
71 SET @@global.innodb_concurrency_tickets = "Y";
72 ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets'
73 SELECT @@global.innodb_concurrency_tickets;
74 @@global.innodb_concurrency_tickets
75 1
76 SET @@global.innodb_concurrency_tickets = 1.1;
77 ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets'
78 SELECT @@global.innodb_concurrency_tickets;
79 @@global.innodb_concurrency_tickets
80 1
81 SET @@global.innodb_concurrency_tickets = " ";
82 ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets'
83 SELECT @@global.innodb_concurrency_tickets;
84 @@global.innodb_concurrency_tickets
85 1
86 SET @@global.innodb_concurrency_tickets = ' ';
87 ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets'
88 SELECT @@global.innodb_concurrency_tickets;
89 @@global.innodb_concurrency_tickets
90 1
91 '#----------------------FN_DYNVARS_046_06------------------------#'
92 SELECT @@global.innodb_concurrency_tickets =
93 VARIABLE_VALUE FROM performance_schema.global_variables
94 WHERE VARIABLE_NAME='innodb_concurrency_tickets';
95 @@global.innodb_concurrency_tickets =
96 VARIABLE_VALUE
97 1
98 SELECT @@global.innodb_concurrency_tickets;
99 @@global.innodb_concurrency_tickets
100 1
101 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
102 WHERE VARIABLE_NAME='innodb_concurrency_tickets';
103 VARIABLE_VALUE
104 1
105 '#---------------------FN_DYNVARS_046_07-------------------------#'
106 SET @@global.innodb_concurrency_tickets = OFF;
107 ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets'
108 SELECT @@global.innodb_concurrency_tickets;
109 @@global.innodb_concurrency_tickets
110 1
111 SET @@global.innodb_concurrency_tickets = ON;
112 ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets'
113 SELECT @@global.innodb_concurrency_tickets;
114 @@global.innodb_concurrency_tickets
115 1
116 '#---------------------FN_DYNVARS_046_08----------------------#'
117 SET @@global.innodb_concurrency_tickets = TRUE;
118 SELECT @@global.innodb_concurrency_tickets;
119 @@global.innodb_concurrency_tickets
120 1
121 SET @@global.innodb_concurrency_tickets = FALSE;
122 Warnings:
123 Warning 1292 Truncated incorrect innodb_concurrency_tickets value: '0'
124 SELECT @@global.innodb_concurrency_tickets;
125 @@global.innodb_concurrency_tickets
126 1
127 SET @@global.innodb_concurrency_tickets = @global_start_value;
128 SELECT @@global.innodb_concurrency_tickets;
129 @@global.innodb_concurrency_tickets
130 5000