Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.max_write_lock_count;
2 SELECT @start_global_value;
3 @start_global_value
4 18446744073709551615
5 '#--------------------FN_DYNVARS_088_01-------------------------#'
6 SET @@global.max_write_lock_count = 1000;
7 SET @@global.max_write_lock_count = DEFAULT;
8 SELECT @@global.max_write_lock_count;
9 @@global.max_write_lock_count
10 18446744073709551615
11 '#--------------------FN_DYNVARS_088_02-------------------------#'
12 SET @@global.max_write_lock_count = DEFAULT;
13 SELECT @@global.max_write_lock_count = 4294967295;
14 @@global.max_write_lock_count = 4294967295
15 0
16 '#--------------------FN_DYNVARS_088_03-------------------------#'
17 SET @@global.max_write_lock_count = 1;
18 SELECT @@global.max_write_lock_count;
19 @@global.max_write_lock_count
20 1
21 SET @@global.max_write_lock_count = 2;
22 SELECT @@global.max_write_lock_count;
23 @@global.max_write_lock_count
24 2
25 SET @@global.max_write_lock_count = 65536;
26 SELECT @@global.max_write_lock_count;
27 @@global.max_write_lock_count
28 65536
29 SET @@global.max_write_lock_count = 4294967295;
30 SELECT @@global.max_write_lock_count;
31 @@global.max_write_lock_count
32 4294967295
33 SET @@global.max_write_lock_count = 4294967294;
34 SELECT @@global.max_write_lock_count;
35 @@global.max_write_lock_count
36 4294967294
37 SET @@global.max_write_lock_count = 18446744073709551615;
38 SELECT @@global.max_write_lock_count;
39 @@global.max_write_lock_count
40 18446744073709551615
41 '#------------------FN_DYNVARS_088_04-----------------------#'
42 SET @@global.max_write_lock_count = -1024;
43 Warnings:
44 Warning 1292 Truncated incorrect max_write_lock_count value: '-1024'
45 SELECT @@global.max_write_lock_count;
46 @@global.max_write_lock_count
47 1
48 SET @@global.max_write_lock_count = -1;
49 Warnings:
50 Warning 1292 Truncated incorrect max_write_lock_count value: '-1'
51 SELECT @@global.max_write_lock_count;
52 @@global.max_write_lock_count
53 1
54 SET @@global.max_write_lock_count = 65530.34;
55 ERROR 42000: Incorrect argument type to variable 'max_write_lock_count'
56 SELECT @@global.max_write_lock_count;
57 @@global.max_write_lock_count
58 1
59 SET @@global.max_write_lock_count = test;
60 ERROR 42000: Incorrect argument type to variable 'max_write_lock_count'
61 SELECT @@global.max_write_lock_count;
62 @@global.max_write_lock_count
63 1
64 SET @@global.max_write_lock_count = 18446744073709551616;
65 ERROR 42000: Incorrect argument type to variable 'max_write_lock_count'
66 SELECT @@global.max_write_lock_count;
67 @@global.max_write_lock_count
68 1
69 '#------------------FN_DYNVARS_088_05-----------------------#'
70 SELECT @@global.max_write_lock_count = VARIABLE_VALUE
71 FROM performance_schema.global_variables
72 WHERE VARIABLE_NAME='max_write_lock_count';
73 @@global.max_write_lock_count = VARIABLE_VALUE
74 1
75 '#------------------FN_DYNVARS_088_06-----------------------#'
76 SET @@global.max_write_lock_count = TRUE;
77 SELECT @@global.max_write_lock_count;
78 @@global.max_write_lock_count
79 1
80 SET @@global.max_write_lock_count = FALSE;
81 Warnings:
82 Warning 1292 Truncated incorrect max_write_lock_count value: '0'
83 SELECT @@global.max_write_lock_count;
84 @@global.max_write_lock_count
85 1
86 '#---------------------FN_DYNVARS_088_07----------------------#'
87 SET @@global.max_write_lock_count = 20;
88 SELECT @@max_write_lock_count = @@global.max_write_lock_count;
89 @@max_write_lock_count = @@global.max_write_lock_count
90 1
91 '#---------------------FN_DYNVARS_088_08----------------------#'
92 SET @@global.max_write_lock_count = 102;
93 SELECT @@max_write_lock_count;
94 @@max_write_lock_count
95 102
96 SELECT local.max_write_lock_count;
97 ERROR 42S02: Unknown table 'local' in field list
98 SELECT global.max_write_lock_count;
99 ERROR 42S02: Unknown table 'global' in field list
100 SELECT max_write_lock_count = @@global.max_write_lock_count;
101 ERROR 42S22: Unknown column 'max_write_lock_count' in 'field list'
102 SET @@global.max_write_lock_count = @start_global_value;
103 SELECT @@global.max_write_lock_count;
104 @@global.max_write_lock_count
105 18446744073709551615