Debian Codegraph @

mysql-test/suite/sys_vars/t/character_set_database_func_myisam.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/force_myisam_default.inc
23 --source include/have_myisam.inc
24
25 --echo '#--------------------FN_DYNVARS_008_01-------------------------#'
26 ########################################################################
27 # Check if setting character_set_database is changed in new connection #
28 ########################################################################
29 #save
30 SET @global_character_set_database = @@global.character_set_database;
31 SET @session_character_set_database = @@session.character_set_database;
32 SET @session_character_set_server = @@session.character_set_server;
33 SET @global_character_set_server = @@global.character_set_server;
34
35 SET @@global.character_set_database = utf8;
36 --echo 'connect (con1,localhost,root,,,,)'
37 connect (con1,localhost,root,,,,);
38 --echo 'connection con1'
39 connection con1;
40 SELECT @@global.character_set_database;
41 SELECT @@session.character_set_database;
42 disconnect con1;
43
44 --echo '#--------------------FN_DYNVARS_008_02-------------------------#'
45 #############################################################
46 # Begin the functionality Testing of character_set_database #
47 #############################################################
48
49 --echo 'connection default'
50 connection default;
51
52 --disable_warnings
53 DROP TABLE IF EXISTS t1;
54 --enable_warnings
55
56 #==============================================================================
57 --echo '------Check if load data uses character_set_database----------'
58 #==============================================================================
59
60 USE test;
61 CREATE TABLE t1 (a CHAR(4) CHARACTER SET utf8) ENGINE=MyISAM CHARACTER SET utf8;
62
63 --echo 'Verify with latin';
64 SET @@session.character_set_database = latin1;
65 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
66 eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/std_data/charset_utf8.txt' INTO TABLE t1;
67 SELECT count(*) FROM t1 WHERE CHAR_LENGTH(a)>1;
68 TRUNCATE TABLE t1;
69
70 --echo 'Verify with utf8';
71 SET @@session.character_set_database = utf8;
72 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
73 eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/std_data/charset_utf8.txt' INTO TABLE t1;
74 SELECT count(*) FROM t1 WHERE CHAR_LENGTH(a)>1;
75
76 --disable_warnings
77 DROP TABLE IF EXISTS t1;
78 --enable_warnings
79
80 #restore
81 SET @@global.character_set_database = @global_character_set_database;
82 SET @@session.character_set_database = @session_character_set_database;
83 SET @@session.character_set_server = @session_character_set_server;
84 SET @@global.character_set_server = @global_character_set_server;
85 ############################################################
86 # End of functionality Testing for character_set_database #
87 ############################################################