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 collation_server variables
27 SET @global_collation_server = @@global.collation_server;
28 SET @session_collation_server = @@session.collation_server;
29
30 #save
31 SET @global_character_set_server = @@global.character_set_server;
32 SET @session_character_set_server = @@session.character_set_server;
33
34
35 SET NAMES utf8mb4;
36 SET @@global.character_set_server = utf8;
37 connect (con1,localhost,root,,,,);
38 connection con1;
39 SELECT @@global.character_set_server;
40 SELECT @@session.character_set_server;
41 disconnect con1;
42
43 --echo '#--------------------FN_DYNVARS_009_02-------------------------#'
44 #############################################################
45 # Begin the functionality Testing of character_set_server #
46 #############################################################
47
48 connection default;
49 #The server character set and collation are used as default values if the database
50 #character set and collation are not specified in CREATE DATABASE statements.
51
52 #==============================================================================
53 --echo '--global character_set_server should not effects current connection--'
54 #==============================================================================
55
56 --source include/default_charset.inc
57 select @@character_set_database,@@character_set_connection;
58 select @@character_set_database=@@character_set_connection;
59 SET @@global.character_set_server = utf8;
60 CREATE DATABASE db1;
61 USE db1;
62 SHOW CREATE DATABASE db1;
63 DROP DATABASE db1;
64 select @@character_set_database;
65
66 #==============================================================================
67 --echo '---session character_set_server should effects current connection---'
68 #==============================================================================
69 SET @@session.character_set_server = utf8;
70 CREATE DATABASE db1;
71 USE db1;
72 SHOW CREATE DATABASE db1;
73 DROP DATABASE db1;
74 select @@character_set_database;
75
76 #==============================================================================
77 --echo '----test with new connection----'
78 #==============================================================================
79
80 connect (con1,localhost,root,,,,);
81 connection con1;
82
83 SELECT @@session.character_set_server;
84
85 --echo '----------character set not specified---------'
86 CREATE DATABASE db1;
87 USE db1;
88 SHOW CREATE DATABASE db1;
89 DROP DATABASE db1;
90 SELECT @@character_set_database;
91
92 --echo '----------ascii character set specified----------'
93 CREATE DATABASE db1 character set ascii;
94 USE db1;
95 SHOW CREATE DATABASE db1;
96 DROP DATABASE db1;
97 select @@character_set_database;
98
99 disconnect con1;
100
101 #restore
102 connection default;
103 SET @@global.collation_server = @global_collation_server;
104 SET @@session.collation_server = @session_collation_server;
105
106 ############################################################
107 # End of functionality Testing for character_set_server #
108 ############################################################