Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.max_write_lock_count;
2 SELECT @start_global_value;
3 @start_global_value
4 4294967295
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 4294967295
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 1
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 '#------------------FN_DYNVARS_088_04-----------------------#'
38 SET @@global.max_write_lock_count = -1024;
39 Warnings:
40 Warning 1292 Truncated incorrect max_write_lock_count value: '-1024'
41 SELECT @@global.max_write_lock_count;
42 @@global.max_write_lock_count
43 1
44 SET @@global.max_write_lock_count = -1;
45 Warnings:
46 Warning 1292 Truncated incorrect max_write_lock_count value: '-1'
47 SELECT @@global.max_write_lock_count;
48 @@global.max_write_lock_count
49 1
50 SET @@global.max_write_lock_count = 65530.34;
51 ERROR 42000: Incorrect argument type to variable 'max_write_lock_count'
52 SELECT @@global.max_write_lock_count;
53 @@global.max_write_lock_count
54 1
55 SET @@global.max_write_lock_count = test;
56 ERROR 42000: Incorrect argument type to variable 'max_write_lock_count'
57 SELECT @@global.max_write_lock_count;
58 @@global.max_write_lock_count
59 1
60 SET @@global.max_write_lock_count = 4294967296;
61 Warnings:
62 Warning 1292 Truncated incorrect max_write_lock_count value: '4294967296'
63 SELECT @@global.max_write_lock_count;
64 @@global.max_write_lock_count
65 4294967295
66 SET @@global.max_write_lock_count = 42949672950;
67 Warnings:
68 Warning 1292 Truncated incorrect max_write_lock_count value: '42949672950'
69 SELECT @@global.max_write_lock_count;
70 @@global.max_write_lock_count
71 4294967295
72 '#------------------FN_DYNVARS_088_05-----------------------#'
73 SELECT @@global.max_write_lock_count = VARIABLE_VALUE
74 FROM performance_schema.global_variables
75 WHERE VARIABLE_NAME='max_write_lock_count';
76 @@global.max_write_lock_count = VARIABLE_VALUE
77 1
78 '#------------------FN_DYNVARS_088_06-----------------------#'
79 SET @@global.max_write_lock_count = TRUE;
80 SELECT @@global.max_write_lock_count;
81 @@global.max_write_lock_count
82 1
83 SET @@global.max_write_lock_count = FALSE;
84 Warnings:
85 Warning 1292 Truncated incorrect max_write_lock_count value: '0'
86 SELECT @@global.max_write_lock_count;
87 @@global.max_write_lock_count
88 1
89 '#---------------------FN_DYNVARS_088_07----------------------#'
90 SET @@global.max_write_lock_count = 20;
91 SELECT @@max_write_lock_count = @@global.max_write_lock_count;
92 @@max_write_lock_count = @@global.max_write_lock_count
93 1
94 '#---------------------FN_DYNVARS_088_08----------------------#'
95 SET @@global.max_write_lock_count = 102;
96 SELECT @@max_write_lock_count;
97 @@max_write_lock_count
98 102
99 SELECT local.max_write_lock_count;
100 ERROR 42S02: Unknown table 'local' in field list
101 SELECT global.max_write_lock_count;
102 ERROR 42S02: Unknown table 'global' in field list
103 SELECT max_write_lock_count = @@global.max_write_lock_count;
104 ERROR 42S22: Unknown column 'max_write_lock_count' in 'field list'
105 SET @@global.max_write_lock_count = @start_global_value;
106 SELECT @@global.max_write_lock_count;
107 @@global.max_write_lock_count
108 4294967295