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 --source include/have_utf8.inc
23
24 --echo '#--------------------FN_DYNVARS_008_01-------------------------#'
25 ########################################################################
26 # Check if setting character_set_database is changed in new connection #
27 ########################################################################
28 #save
29 SET @global_collation_database = @@global.collation_database;
30 SET @global_collation_server = @@global.collation_server;
31 SET @session_collation_database = @@session.collation_database;
32 SET @session_collation_server = @@session.collation_server;
33
34 SET @global_character_set_database = @@global.character_set_database;
35 SET @session_character_set_database = @@session.character_set_database;
36 SET @session_character_set_server = @@session.character_set_server;
37 SET @global_character_set_server = @@global.character_set_server;
38
39 SET @@global.character_set_database = utf8;
40 connect (con1,localhost,root,,,,);
41 connection con1;
42 SELECT @@global.character_set_database;
43 SELECT @@session.character_set_database;
44 disconnect con1;
45
46 --echo '#--------------------FN_DYNVARS_008_02-------------------------#'
47 #############################################################
48 # Begin the functionality Testing of character_set_database #
49 #############################################################
50
51 connection default;
52
53 --disable_warnings
54 DROP TABLE IF EXISTS t1;
55 --enable_warnings
56
57 #==============================================================================
58 --echo '--check if setting session character_set_database effects new databases'
59 #==============================================================================
60
61 SET @@session.character_set_server = utf8;
62 SELECT @@session.character_set_database;
63 SET @@session.character_set_database = latin5;
64 SELECT @@session.character_set_database;
65
66 CREATE DATABASE db1;
67 USE db1;
68 SHOW CREATE DATABASE db1;
69 CREATE TABLE t1(a INT, b VARCHAR(40));
70 SHOW CREATE TABLE t1;
71 DROP TABLE t1;
72 DROP DATABASE db1;
73
74 #==============================================================================
75 --echo '--ascii character set specified--'
76 #==============================================================================
77 CREATE DATABASE db1 CHARACTER SET ascii;
78 USE db1;
79 SHOW CREATE DATABASE db1;
80 CREATE TABLE t1(a INT, b VARCHAR(40));
81 SHOW CREATE TABLE t1;
82 DROP TABLE t1;
83 DROP DATABASE db1;
84
85 #==============================================================================
86 --echo '------Check if load data uses character_set_database----------'
87 #==============================================================================
88
89 USE test;
90 CREATE TABLE t1 (a CHAR(4) CHARACTER SET utf8) ENGINE=MyISAM CHARACTER SET utf8;
91
92 --echo 'Verify with latin';
93 SET @@session.character_set_database = latin1;
94 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
95 eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/std_data/charset_utf8.txt' INTO TABLE t1;
96 SELECT count(*) FROM t1 WHERE CHAR_LENGTH(a)>1;
97 TRUNCATE TABLE t1;
98
99 --echo 'Verify with utf8';
100 SET @@session.character_set_database = utf8;
101 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
102 eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/std_data/charset_utf8.txt' INTO TABLE t1;
103 SELECT count(*) FROM t1 WHERE CHAR_LENGTH(a)>1;
104
105 --disable_warnings
106 DROP TABLE IF EXISTS t1;
107 --enable_warnings
108
109
110 #==============================================================================
111 SET GLOBAL character_set_server=latin5;
112
113 connect (con2, localhost, root,,);
114 connection con2;
115
116 CREATE DATABASE csdb CHARACTER SET = utf8;
117 USE csdb;
118 DROP DATABASE csdb;
119 SELECT @@character_set_database;
120
121 connection default;
122 disconnect con2;
123
124
125 #restore
126 SET @@global.collation_database = @global_collation_database;
127 SET @@session.collation_database = @session_collation_database;
128 SET @@session.collation_server = @session_collation_server;
129 SET @@global.collation_server = @global_collation_server;
130 ############################################################
131 # End of functionality Testing for character_set_database #
132 ############################################################