Skip to content

M
MariaDB
Switch branch/tag
Find file Normal viewHistoryPermalink
collation_server_basic.test 11.9 KB
Newer Older
unknown's avatar
System variable tests delivered by Folio3 (see WL4288).  
unknown committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 
############## mysql-test\t\collation_server_basic.test #######################
#                                                                             #
# Variable Name: collation_server                                             #
# Scope: GLOBAL | SESSION                                                     #
# Access Type: Dynamic                                                        #
# Data Type: string                                                           #
# Default Value:                                                              #
# Range: NA                                                                   #
#                                                                             #
#                                                                             #
# Creation Date: 2008-02-07                                                   #
# Author:  Rizwan                                                             # 
#                                                                             #
# Description: Test Cases of Dynamic System Variable collation_server         #
#              that checks the behavior of this variable in the following ways#
#              * Default Value                                                #
#              * Valid & Invalid values                                       #
#              * Scope & Access method                                        #
#              * Data Integrity                                               #
#                                                                             #
# Reference: http://dev.mysql.com/doc/refman/5.1/en/                          #
#  server-system-variables.html                                               #
#                                                                             #
###############################################################################
unknown's avatar
fourth set of fixes for bug#35988.  
unknown committed
25 26 27 28 
--source include/have_big5.inc
--source include/have_ujis.inc
--source include/have_sjis.inc
--source include/have_utf8.inc
unknown's avatar
fifth set of fixes to bug#35988.  
unknown committed
29 
--source include/have_ucs2.inc
unknown's avatar
System variable tests delivered by Folio3 (see WL4288).  
unknown committed
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 

--source include/load_sysvars.inc

###################################################
##       START OF collation_server TESTS         ##
###################################################

#############################################################
#                 Save initial value                        #
#############################################################
SET @global_start_value = @@global.collation_server;
SELECT @global_start_value;
# Save initial session value
SET @session_start_value = @@collation_server;
SELECT @session_start_value;
# now save using local access 
SET @session_start_value = @@local.collation_server;
SELECT @session_start_value;
# save using implicit session scope
SET @session_start_value = @@session.collation_server;
SELECT @session_start_value;

--echo '#--------------------FN_DYNVARS_014_01------------------#'
###############################################################################
#       Test Variable access and assignment with and without @@               #
###############################################################################
# select without @@
--error ER_BAD_FIELD_ERROR
SELECT collation_server;
# assign value without @@
SET collation_server=utf8_unicode_ci;
SELECT @@session.collation_server;
# assign global variable without @@
--Error ER_PARSE_ERROR
SET global.collation_server=utf8_unicode_ci;
# using another syntax for accessing session variable
SET session collation_server=utf8_unicode_ci;
# accessing variable with scope the wrong way
--Error ER_BAD_FIELD_ERROR
SELECT session collation_server;
# using another syntax for accessing dynamic variable
SET global collation_server=utf8_unicode_ci;
--Error ER_BAD_FIELD_ERROR
SELECT global collation_server;

--echo '#--------------------FN_DYNVARS_014_02-------------------------#'
###############################################################################
#     Check the DEFAULT value of collation_server for session and global      #
###############################################################################
SET @@collation_server = latin1_bin;
SET @@collation_server = DEFAULT;
SELECT @@collation_server AS DEFAULT_VALUE;

SET @@global.collation_server = latin1_bin;
SET @@global.collation_server = DEFAULT;
SELECT @@global.collation_server;

--echo '#--------------------FN_DYNVARS_014_03-------------------------#'
###########################################################################
#   Check if setting global value changes session value and vice versa    #
###########################################################################
SET @@session.collation_server = utf8_polish_ci;
SELECT @@session.collation_server;
SET @@global.collation_server = latin7_general_ci;
SELECT @@global.collation_server;
SELECT @@session.collation_server AS res_is_utf8_polish_ci;

SET @@session.collation_server = latin7_bin;
SELECT @@session.collation_server;
SELECT @@global.collation_server AS res_is_latin7_general_ci;
# composite check
SELECT @@global.collation_server=@@session.collation_server AS res_is_false;

--echo '#--------------------FN_DYNVARS_014_04-------------------------#'
#############################################################################
#    Check if accessing variable with and without session point to          #
#    session variable                                                       #
#############################################################################
SELECT @@collation_server = @@session.collation_server AS res;
SELECT @@collation_server = @@local.collation_server AS res;

--echo '#--------------------FN_DYNVARS_014_05-------------------------#'
###########################################################################
#     Check if combining character set works                              #
###########################################################################
--Error ER_BAD_FIELD_ERROR
SET @@collation_server = latin7_general_ci + latin7_general_cs;

--echo '#--------------------FN_DYNVARS_014_06-------------------------#'
##############################################################################
#     Change the value of collation_server to a valid value for session      #
##############################################################################

let collation_variable = @@session.collation_server;
Horst Hunger's avatar
WL#4681: Took the system variable tests out of the main test suite, put them...  
Horst Hunger committed
124 
--source suite/sys_vars/inc/collation_basic.inc
unknown's avatar
System variable tests delivered by Folio3 (see WL4288).  
unknown committed
125 126 127 128 129 130 131 132 


--echo '#--------------------FN_DYNVARS_014_07-------------------------#'
#############################################################################
#     Change the value of collation_server to a valid value for global      #
#############################################################################

let collation_variable = @@global.collation_server;
Horst Hunger's avatar
WL#4681: Took the system variable tests out of the main test suite, put them...  
Horst Hunger committed
133 
--source suite/sys_vars/inc/collation_basic.inc
unknown's avatar
System variable tests delivered by Folio3 (see WL4288).  
unknown committed
134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 


--echo '#--------------------FN_DYNVARS_014_08-------------------------#'
#############################################################################
#     Change the value of collation_server to a valid value with uppercase, #
#     lowercase and mixedcase                                               #
#############################################################################

SET @@collation_server = LATIN7_GENERAL_CS;
SELECT @@collation_server;
SET @@collation_server = latin7_general_cs;
SELECT @@collation_server;

SET @@global.collation_server = Latin7_GeneRal_cS;
SELECT @@global.collation_server;


--echo '#--------------------FN_DYNVARS_014_09-------------------------#'
##############################################################
#     Check if 1,2,3, ... values can be used on variable     #
##############################################################
SET @@collation_server = 1;
SELECT @@collation_server;
SET @@collation_server = 2;
SELECT @@collation_server;
SET @@collation_server = 3;
SELECT @@collation_server;
SET @@collation_server = 99;
SELECT @@collation_server;
--Error ER_UNKNOWN_COLLATION
SET @@collation_server = 100;


SET @@global.collation_server = 1;
SELECT @@global.collation_server;
SET @@global.collation_server = 2;
SELECT @@global.collation_server;
SET @@global.collation_server = 3;
SELECT @@global.collation_server;
SET @@global.collation_server = 99;
SELECT @@global.collation_server;
--Error ER_UNKNOWN_COLLATION
SET @@global.collation_server = 100;


SET @total_collations = (SELECT count(*) FROM INFORMATION_SCHEMA.COLLATIONS);
SELECT @total_collations > 120;

--echo '#--------------------FN_DYNVARS_014_10-------------------------#'
###############################################################################
#     Change the value of collation_server to an invalid value for session    #
###############################################################################
--Error ER_UNKNOWN_COLLATION
SET @@collation_server = latin7_binary;
--Error ER_UNKNOWN_COLLATION
SET @@collation_server = 'eucjpms_japanese_cs';
--Error ER_UNKNOWN_COLLATION
SET @@collation_server = 0;
--Error ER_WRONG_TYPE_FOR_VAR
SET @@collation_server = 1.01;
--Error ER_UNKNOWN_COLLATION
SET @@collation_server = -1;
--Error ER_UNKNOWN_COLLATION
SET @@collation_server = '';
--Error ER_UNKNOWN_COLLATION
SET @@collation_server = ' eucjpms_bin';
SET @@collation_server = true;
SELECT @@collation_server AS res_with_true;
--Error ER_UNKNOWN_COLLATION
SET @@collation_server = ON;

--echo '#--------------------FN_DYNVARS_014_11-------------------------#'
###############################################################################
#     Change the value of collation_server to an invalid value for global     #
###############################################################################
--Error ER_UNKNOWN_COLLATION
SET @@global.collation_server = latin7_binary;
--Error ER_UNKNOWN_COLLATION
SET @@global.collation_server = 'eucjpms_japanese_cs';
--Error ER_UNKNOWN_COLLATION
SET @@global.collation_server = 0;
--Error ER_WRONG_TYPE_FOR_VAR
SET @@global.collation_server = 1.1;
--Error ER_UNKNOWN_COLLATION
SET @@global.collation_server = -1;
--Error ER_UNKNOWN_COLLATION
SET @@global.collation_server = "";
--Error ER_UNKNOWN_COLLATION
SET @@global.collation_server = ' eucjpms_bin';

SET @@global.collation_server = true;

--Error ER_UNKNOWN_COLLATION
SET @@global.collation_server = ON;

--echo '#--------------------FN_DYNVARS_014_12-------------------------#'
###############################################################################
#     Check if the value in GLOBAL Table matches value in variable            #
###############################################################################
SELECT @@global.collation_server =
 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
  WHERE VARIABLE_NAME='collation_server') AS res;
SET @@global.collation_server = 1;
SELECT @@global.collation_server;
SELECT @@global.collation_server =
 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
  WHERE VARIABLE_NAME='collation_server') AS res;

--echo '#--------------------FN_DYNVARS_014_13-------------------------#'
###############################################################################
#     Check if the value in SESSION Table matches value in variable           #
###############################################################################
SELECT @@collation_server =
 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
  WHERE VARIABLE_NAME='collation_server') AS res;
SELECT @@local.collation_server =
 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
  WHERE VARIABLE_NAME='collation_server') AS res;
SELECT @@session.collation_server =
 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
  WHERE VARIABLE_NAME='collation_server') AS res;

####################################
#     Restore initial value        #
####################################
SET @@global.collation_server = @global_start_value;
SELECT @@global.collation_server;
SET @@session.collation_server = @session_start_value;
SELECT @@session.collation_server;

#####################################################
#                 END OF collation_server TESTS     #
#####################################################
GitLab Nexedi Edition | About GitLab | About Nexedi | 沪ICP备2021021310号-2 | 沪ICP备2021021310号-7