Debian Codegraph @

mysql-test/suite/sys_vars/t/character_set_server_func.test

raw
1 ############## mysql-test\t\character_set_server_func.test ###################
2 # #
3 # Variable Name: character_set_server #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: string #
7 # Default Value: utf8 (session), latin1 (global) #
8 # Range: NA #
9 # #
10 # #
11 # Creation Date: 2008-03-08 #
12 # Author: Rizwan #
13 # #
14 # Description: Test Cases of Dynamic System Variable character_set_server #
15 # that checks the behavior of this variable #
16 # #
17 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
18 # server-system-variables.html #
19 # #
20 ###############################################################################
21 --echo '#--------------------FN_DYNVARS_009_01-------------------------#'
22 ######################################################################
23 # Check if setting character_set_server is changed in new connection #
24 ######################################################################
25
26 #save
27 SET @global_character_set_server = @@global.character_set_server;
28 SET @session_character_set_server = @@session.character_set_server;
29
30
31 SET @@global.character_set_server = utf8;
32 --echo 'connect (con1,localhost,root,,,,)'
33 connect (con1,localhost,root,,,,);
34 --echo 'connection con1'
35 connection con1;
36 SELECT @@global.character_set_server;
37 SELECT @@session.character_set_server;
38 disconnect con1;
39
40 --echo '#--------------------FN_DYNVARS_009_02-------------------------#'
41 #############################################################
42 # Begin the functionality Testing of character_set_server #
43 #############################################################
44
45 --echo 'connection default'
46 connection default;
47 #The server character set and collation are used as default values if the database
48 #character set and collation are not specified in CREATE DATABASE statements.
49
50 #==============================================================================
51 --echo '---global character_set_server should not effects current connection---'
52 #==============================================================================
53
54 SET @@global.character_set_server = utf8;
55 CREATE DATABASE db1;
56 USE db1;
57 SHOW CREATE DATABASE db1;
58 DROP DATABASE db1;
59 select @@character_set_database;
60
61 #==============================================================================
62 --echo '---session character_set_server should effects current connection---'
63 #==============================================================================
64 SET @@session.character_set_server = utf8;
65 CREATE DATABASE db1;
66 USE db1;
67 SHOW CREATE DATABASE db1;
68 DROP DATABASE db1;
69 select @@character_set_database;
70
71 #==============================================================================
72 --echo '----test with new connection----'
73 #==============================================================================
74
75 --echo 'connect (con1,localhost,root,,,,)'
76 connect (con1,localhost,root,,,,);
77 --echo 'connection con1'
78 connection con1;
79
80 SELECT @@session.character_set_server;
81
82 --echo '----------character set not specified---------'
83 CREATE DATABASE db1;
84 USE db1;
85 SHOW CREATE DATABASE db1;
86 DROP DATABASE db1;
87 SELECT @@character_set_database;
88
89 --echo '----------ascii character set specified----------'
90 CREATE DATABASE db1 character set ascii;
91 USE db1;
92 SHOW CREATE DATABASE db1;
93 DROP DATABASE db1;
94 select @@character_set_database;
95
96 disconnect con1;
97
98 #restore
99 --echo 'connection default;'
100 connection default;
101 SET @@global.character_set_server = @global_character_set_server;
102 SET @@session.character_set_server = @session_character_set_server;
103
104 ############################################################
105 # End of functionality Testing for character_set_server #
106 ############################################################