1
############## mysql-test\t\max_write_lock_count_basic.test ###############
3
# Variable Name: max_write_lock_count #
5
# Access Type: Dynamic #
7
# Default Value: 4294967295 #
11
# Creation Date: 2008-02-07 #
14
# Description: Test Cases of Dynamic System Variable max_write_lock_count #
15
# that checks the behavior of this variable in the following ways#
17
# * Valid & Invalid values #
18
# * Scope & Access method #
21
# Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
22
# server-system-variables.html #
24
###############################################################################
26
--source include/load_sysvars.inc
28
##########################################
29
# START OF max_write_lock_count TESTS #
30
##########################################
33
#############################################################
34
# Save initial value #
35
#############################################################
37
SET @start_global_value = @@global.max_write_lock_count;
38
SELECT @start_global_value;
41
--echo '#--------------------FN_DYNVARS_088_01-------------------------#'
42
############################################################
43
# Display the DEFAULT value of max_write_lock_count #
44
############################################################
46
SET @@global.max_write_lock_count = 1000;
47
SET @@global.max_write_lock_count = DEFAULT;
48
SELECT @@global.max_write_lock_count;
51
--echo '#--------------------FN_DYNVARS_088_02-------------------------#'
52
############################################################
53
# Check the DEFAULT value of max_write_lock_count #
54
############################################################
56
SET @@global.max_write_lock_count = DEFAULT;
57
SELECT @@global.max_write_lock_count = 4294967295;
60
--echo '#--------------------FN_DYNVARS_088_03-------------------------#'
61
##############################################################################
62
# Change the value of max_write_lock_count to a valid value for GLOBAL Scope #
63
##############################################################################
65
SET @@global.max_write_lock_count = 1;
66
SELECT @@global.max_write_lock_count;
67
SET @@global.max_write_lock_count = 2;
68
SELECT @@global.max_write_lock_count;
69
SET @@global.max_write_lock_count = 65536;
70
SELECT @@global.max_write_lock_count;
71
SET @@global.max_write_lock_count = 4294967295;
72
SELECT @@global.max_write_lock_count;
73
SET @@global.max_write_lock_count = 4294967294;
74
SELECT @@global.max_write_lock_count;
78
--echo '#------------------FN_DYNVARS_088_04-----------------------#'
79
################################################################
80
# Change the value of max_write_lock_count to an invalid value #
81
################################################################
83
SET @@global.max_write_lock_count = -1024;
84
SELECT @@global.max_write_lock_count;
85
SET @@global.max_write_lock_count = 4294967296;
86
SELECT @@global.max_write_lock_count;
87
SET @@global.max_write_lock_count = -1;
88
SELECT @@global.max_write_lock_count;
89
SET @@global.max_write_lock_count = 429496729500;
90
SELECT @@global.max_write_lock_count;
91
--Error ER_PARSE_ERROR
92
SET @@global.max_write_lock_count = 65530.34.;
93
SELECT @@global.max_write_lock_count;
94
--Error ER_WRONG_TYPE_FOR_VAR
95
SET @@global.max_write_lock_count = test;
96
SELECT @@global.max_write_lock_count;
100
--echo '#------------------FN_DYNVARS_088_05-----------------------#'
101
####################################################################
102
# Check if the value in GLOBAL Table matches value in variable #
103
####################################################################
106
SELECT @@global.max_write_lock_count = VARIABLE_VALUE
107
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
108
WHERE VARIABLE_NAME='max_write_lock_count';
111
--echo '#------------------FN_DYNVARS_088_06-----------------------#'
112
####################################################################
113
# Check if TRUE and FALSE values can be used on variable #
114
####################################################################
116
SET @@global.max_write_lock_count = TRUE;
117
SELECT @@global.max_write_lock_count;
118
SET @@global.max_write_lock_count = FALSE;
119
SELECT @@global.max_write_lock_count;
122
--echo '#---------------------FN_DYNVARS_088_07----------------------#'
123
#################################################################################
124
# Check if accessing variable with and without GLOBAL point to same variable #
125
#################################################################################
127
SET @@global.max_write_lock_count = 20;
128
SELECT @@max_write_lock_count = @@global.max_write_lock_count;
131
--echo '#---------------------FN_DYNVARS_088_08----------------------#'
132
###############################################################################
133
# Check if max_write_lock_count can be accessed with and without @@ sign #
134
###############################################################################
137
SET @@global.max_write_lock_count = 102;
138
SELECT @@max_write_lock_count;
139
--Error ER_UNKNOWN_TABLE
140
SELECT local.max_write_lock_count;
141
--Error ER_UNKNOWN_TABLE
142
SELECT global.max_write_lock_count;
143
--Error ER_BAD_FIELD_ERROR
144
SELECT max_write_lock_count = @@global.max_write_lock_count;
147
####################################
148
# Restore initial value #
149
####################################
151
SET @@global.max_write_lock_count = @start_global_value;
152
SELECT @@global.max_write_lock_count;
155
###################################################
156
# END OF max_write_lock_count TESTS #
157
###################################################