Debian Codegraph @

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

raw
1 ############## mysql-test\t\character_set_database_func.test #################
2 # #
3 # Variable Name: character_set_database #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: string #
7 # Default Value: latin1 (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_database #
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
22 --echo '#--------------------FN_DYNVARS_008_01-------------------------#'
23 ########################################################################
24 # Check if setting character_set_database is changed in new connection #
25 ########################################################################
26 #save
27 SET @global_character_set_database = @@global.character_set_database;
28 SET @session_character_set_database = @@session.character_set_database;
29 SET @session_character_set_server = @@session.character_set_server;
30 SET @global_character_set_server = @@global.character_set_server;
31
32 SET @@global.character_set_database = utf8;
33 --echo 'connect (con1,localhost,root,,,,)'
34 connect (con1,localhost,root,,,,);
35 --echo 'connection con1'
36 connection con1;
37 SELECT @@global.character_set_database;
38 SELECT @@session.character_set_database;
39 disconnect con1;
40
41 --echo '#--------------------FN_DYNVARS_008_02-------------------------#'
42 #############################################################
43 # Begin the functionality Testing of character_set_database #
44 #############################################################
45
46 --echo 'connection default'
47 connection default;
48
49 --disable_warnings
50 DROP TABLE IF EXISTS t1;
51 --enable_warnings
52
53 #==============================================================================
54 --echo '--check if setting session character_set_database effects new databases'
55 #==============================================================================
56
57 SET @@session.character_set_server = utf8;
58 SELECT @@session.character_set_database;
59 SET @@session.character_set_database = latin5;
60 SELECT @@session.character_set_database;
61
62 CREATE DATABASE db1;
63 USE db1;
64 SHOW CREATE DATABASE db1;
65 CREATE TABLE t1(a INT, b VARCHAR(40));
66 SHOW CREATE TABLE t1;
67 DROP TABLE t1;
68 DROP DATABASE db1;
69
70 #==============================================================================
71 --echo '--ascii character set specified--'
72 #==============================================================================
73 CREATE DATABASE db1 CHARACTER SET ascii;
74 USE db1;
75 SHOW CREATE DATABASE db1;
76 CREATE TABLE t1(a INT, b VARCHAR(40));
77 SHOW CREATE TABLE t1;
78 DROP TABLE t1;
79 DROP DATABASE db1;
80
81 #==============================================================================
82 SET GLOBAL character_set_server=latin5;
83
84 connect (con2, localhost, root,,);
85 connection con2;
86
87 CREATE DATABASE csdb CHARACTER SET = utf8;
88 USE csdb;
89 DROP DATABASE csdb;
90 SELECT @@character_set_database;
91
92 connection default;
93 disconnect con2;
94
95
96 #restore
97 SET @@global.character_set_database = @global_character_set_database;
98 SET @@session.character_set_database = @session_character_set_database;
99 SET @@session.character_set_server = @session_character_set_server;
100 SET @@global.character_set_server = @global_character_set_server;
101 ############################################################
102 # End of functionality Testing for character_set_database #
103 ############################################################