← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/t/character_set_system_basic.test

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/character_set_system_basic.test
 
1
 
 
2
 
 
3
################## mysql-test\t\character_set_system_basic.test ###############
 
4
#                                                                             #
 
5
# Variable Name: character_set_system                                         #
 
6
# Scope: Global                                                               #
 
7
# Access Type: Static                                                         #
 
8
# Data Type: string                                                           #
 
9
#                                                                             #
 
10
#                                                                             #
 
11
# Creation Date: 2008-02-07                                                   #
 
12
# Author : Sharique Abdullah                                                  #
 
13
#                                                                             #
 
14
#                                                                             #
 
15
# Description:Test Cases of Dynamic System Variable character_set_system      #
 
16
#             that checks the behavior of this variable in the following ways #
 
17
#              * Value Check                                                  #
 
18
#              * Scope Check                                                  #
 
19
#                                                                             #
 
20
# Reference: http://dev.mysql.com/doc/refman/5.1/en/                          #
 
21
#  server-system-variables.html                                               #
 
22
#                                                                             #
 
23
###############################################################################
 
24
 
 
25
--echo '#---------------------BS_STVARS_003_01----------------------#'
 
26
####################################################################
 
27
#   Displaying default value                                       #
 
28
####################################################################
 
29
SELECT COUNT(@@GLOBAL.character_set_system);
 
30
--echo 1 Expected
 
31
 
 
32
 
 
33
--echo '#---------------------BS_STVARS_003_02----------------------#'
 
34
####################################################################
 
35
#   Check if Value can set                                         #
 
36
####################################################################
 
37
 
 
38
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
 
39
SET @@GLOBAL.character_set_system=1;
 
40
--echo Expected error 'Read only variable'
 
41
 
 
42
SELECT COUNT(@@GLOBAL.character_set_system);
 
43
--echo 1 Expected
 
44
 
 
45
 
 
46
 
 
47
 
 
48
--echo '#---------------------BS_STVARS_003_03----------------------#'
 
49
#################################################################
 
50
# Check if the value in GLOBAL Table matches value in variable  #
 
51
#################################################################
 
52
 
 
53
SELECT @@GLOBAL.character_set_system = VARIABLE_VALUE
 
54
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
 
55
WHERE VARIABLE_NAME='character_set_system';
 
56
--echo 1 Expected
 
57
 
 
58
SELECT COUNT(@@GLOBAL.character_set_system);
 
59
--echo 1 Expected
 
60
 
 
61
SELECT COUNT(VARIABLE_VALUE)
 
62
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
 
63
WHERE VARIABLE_NAME='character_set_system';
 
64
--echo 1 Expected
 
65
 
 
66
 
 
67
 
 
68
--echo '#---------------------BS_STVARS_003_04----------------------#'
 
69
################################################################################
 
70
#  Check if accessing variable with and without GLOBAL point to same variable  #
 
71
################################################################################
 
72
SELECT @@character_set_system = @@GLOBAL.character_set_system;
 
73
--echo 1 Expected
 
74
 
 
75
 
 
76
 
 
77
--echo '#---------------------BS_STVARS_003_05----------------------#'
 
78
################################################################################
 
79
#   Check if character_set_system can be accessed with and without @@ sign     #
 
80
################################################################################
 
81
 
 
82
SELECT COUNT(@@character_set_system);
 
83
--echo 1 Expected
 
84
 
 
85
--Error ER_INCORRECT_GLOBAL_LOCAL_VAR
 
86
SELECT COUNT(@@local.character_set_system);
 
87
--echo Expected error 'Variable is a GLOBAL variable'
 
88
 
 
89
--Error ER_INCORRECT_GLOBAL_LOCAL_VAR
 
90
SELECT COUNT(@@SESSION.character_set_system);
 
91
--echo Expected error 'Variable is a GLOBAL variable'
 
92
 
 
93
SELECT COUNT(@@GLOBAL.character_set_system);
 
94
--echo 1 Expected
 
95
 
 
96
--Error ER_BAD_FIELD_ERROR
 
97
SELECT character_set_system = @@SESSION.character_set_system;
 
98
--echo Expected error 'Readonly variable'
 
99
 
 
100