Debian Codegraph @

mysql-test/suite/sys_vars/r/max_write_lock_count_basic.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 = 4294967296;
45 Warnings:
46 Warning 1292 Truncated incorrect max_write_lock_count value: '4294967296'
47 SELECT @@global.max_write_lock_count;
48 @@global.max_write_lock_count
49 4294967295
50 SET @@global.max_write_lock_count = -1;
51 Warnings:
52 Warning 1292 Truncated incorrect max_write_lock_count value: '-1'
53 SELECT @@global.max_write_lock_count;
54 @@global.max_write_lock_count
55 1
56 SET @@global.max_write_lock_count = 429496729500;
57 Warnings:
58 Warning 1292 Truncated incorrect max_write_lock_count value: '429496729500'
59 SELECT @@global.max_write_lock_count;
60 @@global.max_write_lock_count
61 4294967295
62 SET @@global.max_write_lock_count = 65530.34;
63 ERROR 42000: Incorrect argument type to variable 'max_write_lock_count'
64 SELECT @@global.max_write_lock_count;
65 @@global.max_write_lock_count
66 4294967295
67 SET @@global.max_write_lock_count = test;
68 ERROR 42000: Incorrect argument type to variable 'max_write_lock_count'
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 INFORMATION_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 SELECT
101 SELECT global.max_write_lock_count;
102 ERROR 42S02: Unknown table 'global' in SELECT
103 SELECT max_write_lock_count = @@global.max_write_lock_count;
104 ERROR 42S22: Unknown column 'max_write_lock_count' in 'SELECT'
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