Skip to content

M
MariaDB
Switch branch/tag
Find file Normal viewHistoryPermalink
character_set_database_basic.test 12.5 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\character_set_database_basic.test #################
#                                                                             #
# Variable Name: character_set_database                                       #
# Scope: GLOBAL | SESSION                                                     #
# Access Type: Dynamic                                                        #
# Data Type: string                                                           #
# Default Value: latin1 (session), latin1 (global)                            #
# Range: NA                                                                   #
#                                                                             #
#                                                                             #
# Creation Date: 2008-02-07                                                   #
# Author:  Rizwan                                                             #
#                                                                             #
# Description: Test Cases of Dynamic System Variable character_set_database   #
#              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
Alexander Barkov's avatar
Backporting WL#1213  
Alexander Barkov committed
30 31 32 
--source include/have_utf8mb4.inc
--source include/have_utf16.inc
--source include/have_utf32.inc
unknown's avatar
System variable tests delivered by Folio3 (see WL4288).  
unknown committed
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 124 

--source include/load_sysvars.inc
###################################################
##       START OF character_set_database TESTS   ##
###################################################

#############################################################
#                 Save initial value                        #
#############################################################
SET @global_start_value = @@global.character_set_database;
SELECT @global_start_value;
# Save initial session value
SET @session_start_value = @@character_set_database;
SELECT @session_start_value;
# now save using local access 
SET @session_start_value = @@local.character_set_database;
SELECT @session_start_value;
# save using default access (session)
SET @session_start_value = @@session.character_set_database;
SELECT @session_start_value;

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

--echo '#--------------------FN_DYNVARS_012_02-------------------------#'
###############################################################################
# Check the DEFAULT value of character_set_database for session and global    #
###############################################################################
SET @@character_set_database = latin5;
SET @@character_set_database = DEFAULT;
SELECT @@character_set_database AS DEFAULT_VALUE;

SET @@global.character_set_database = latin5;
SET @@global.character_set_database = DEFAULT;
SELECT @@global.character_set_database;

--echo '#--------------------FN_DYNVARS_012_03-------------------------#'
##############################################################################
#     see if setting global value changes session value and vice versa       #
##############################################################################
SET @@session.character_set_database = utf8;
SELECT @@session.character_set_database;
SET @@global.character_set_database = latin2;
SELECT @@global.character_set_database;
SELECT @@session.character_set_database AS res_is_utf8;

SET @@session.character_set_database = latin5;
SELECT @@session.character_set_database;
SELECT @@global.character_set_database AS res_is_latin2;
# composite check
SELECT @@global.character_set_database=@@session.character_set_database
AS res_is_false;

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

--echo '#--------------------FN_DYNVARS_012_05-------------------------#'
###########################################################################
#     Check if combining character set works                              #
###########################################################################
--Error ER_BAD_FIELD_ERROR
SET @@character_set_database = utf8 + latin2;

--echo '#--------------------FN_DYNVARS_012_06-------------------------#'
#############################################################################
# Change the value of character_set_database to a valid value for session   #
#############################################################################

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


--echo '#--------------------FN_DYNVARS_012_07-------------------------#'
##############################################################################
#     Change the value of character_set_database to a valid value for global #
##############################################################################

let charset_variable = @@global.character_set_database;
Horst Hunger's avatar
WL#4681: Took the system variable tests out of the main test suite, put them...  
Horst Hunger committed
134 
--source suite/sys_vars/inc/charset_basic.inc
unknown's avatar
System variable tests delivered by Folio3 (see WL4288).  
unknown committed
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 267 268 269 270 271 272 


--echo '#--------------------FN_DYNVARS_012_08-------------------------#'
##############################################################################
# Change the value of character_set_database to a valid value with uppercase,#
# lowercase and mixedcase                                                    #
##############################################################################
SET @@character_set_database = UTF8;
SELECT @@character_set_database;
SET @@character_set_database = utf8;
SELECT @@character_set_database;

SET @@global.character_set_database = uTf8;
SELECT @@global.character_set_database;

--echo '#--------------------FN_DYNVARS_012_09-------------------------#'
##############################################################
#     Check if 1,2,3, ... values can be used on variable     #
##############################################################
SET @@character_set_database = 1;
SELECT @@character_set_database;
SET @@character_set_database = 2;
SELECT @@character_set_database;
SET @@character_set_database = 3;
SELECT @@character_set_database;
SET @@character_set_database = 36;
SELECT @@character_set_database;
SET @@character_set_database = 99;
SELECT @@character_set_database;

--Error ER_UNKNOWN_CHARACTER_SET
SET @@character_set_database = 100;


SET @@global.character_set_database = 1;
SELECT @@global.character_set_database;
SET @@global.character_set_database = 2;
SELECT @@global.character_set_database;
SET @@global.character_set_database = 3;
SELECT @@global.character_set_database;
SET @@global.character_set_database = 36;
SELECT @@global.character_set_database;
SET @@global.character_set_database = 99;
SELECT @@global.character_set_database;

--Error ER_UNKNOWN_CHARACTER_SET
SET @@global.character_set_database = 100;


SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS);
SELECT @total_charset;

--echo '#--------------------FN_DYNVARS_012_10-------------------------#'
##############################################################################
# Change the value of character_set_database to an invalid value for session #
##############################################################################
--Error ER_UNKNOWN_CHARACTER_SET
SET @@character_set_database = "grek";
--Error ER_PARSE_ERROR
SET @@character_set_database = utf 8;
--Error ER_UNKNOWN_CHARACTER_SET
SET @@character_set_database = 0;
--Error ER_WRONG_TYPE_FOR_VAR
SET @@character_set_database = 1.1;
--Error ER_UNKNOWN_CHARACTER_SET
SET @@character_set_database = -1;
--Error ER_UNKNOWN_CHARACTER_SET
SET @@character_set_database = '';
--Error ER_UNKNOWN_CHARACTER_SET
SET @@character_set_database = 'latin 2';
SET @@character_set_database = true;
SELECT @@character_set_database AS res_with_true;

--Error ER_UNKNOWN_CHARACTER_SET
SET @@character_set_database = ON;

--echo '#--------------------FN_DYNVARS_012_11-------------------------#'
###############################################################################
#   Change the value of character_set_database to an invalid value for global #
###############################################################################
--Error ER_UNKNOWN_CHARACTER_SET
SET @@global.character_set_database = abc;
--Error ER_UNKNOWN_CHARACTER_SET
SET @@global.character_set_database = 1utf8;
--Error ER_UNKNOWN_CHARACTER_SET
SET @@global.character_set_database = 0;
--Error ER_WRONG_TYPE_FOR_VAR
SET @@global.character_set_database = 1.1;
--Error ER_UNKNOWN_CHARACTER_SET
SET @@global.character_set_database = -1;
--Error ER_UNKNOWN_CHARACTER_SET
SET @@global.character_set_database = '';
--Error ER_UNKNOWN_CHARACTER_SET
SET @@global.character_set_database = 'utf';

SET @@global.character_set_database = true;

--Error ER_UNKNOWN_CHARACTER_SET
SET @@global.character_set_database = ON;

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

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

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

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