← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/t/character_set_client_func.test

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/character_set_client_func.test
 
1
############## mysql-test\t\character_set_client_func.test  ###################
 
2
#                                                                             #
 
3
# Variable Name: character_set_client                                         #
 
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_client     #
 
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_010_01-------------------------#'
 
23
######################################################################
 
24
# Check if setting character_set_client is changed in new connection # 
 
25
######################################################################
 
26
 
 
27
# save
 
28
SET @global_character_set_client = @@global.character_set_client;
 
29
SET @session_character_set_client = @@session.character_set_client;
 
30
 
 
31
 
 
32
SET @@global.character_set_client = utf8;
 
33
--echo 'connect (con1,localhost,root,,,,)'
 
34
connect (con1,localhost,root,,,,);
 
35
--echo 'connection con1'
 
36
connection con1;
 
37
SELECT @@global.character_set_client;
 
38
SELECT @@session.character_set_client;
 
39
disconnect con1;
 
40
 
 
41
--echo 'Bug# 35372: session character_set_client is not effected by global character_set_client'
 
42
 
 
43
--echo '#--------------------FN_DYNVARS_010_02-------------------------#'
 
44
#############################################################
 
45
# Begin the functionality Testing of character_set_client   #
 
46
#############################################################
 
47
 
 
48
--echo 'connection default'
 
49
connection default;
 
50
 
 
51
SHOW VARIABLES like 'character_set_client';
 
52
 
 
53
--disable_warnings
 
54
DROP TABLE IF EXISTS t1;
 
55
--enable_warnings
 
56
 
 
57
CREATE TABLE t1(a CHAR(3) character set utf8);
 
58
 
 
59
#==============================================================================
 
60
--echo '---verifying character_set_client with a utf8 character----'
 
61
#==============================================================================
 
62
--echo 'For latin1 characterset';
 
63
SET @@session.character_set_client = latin1;
 
64
INSERT INTO t1 values('�');
 
65
SELECT a,CHAR_LENGTH(a) FROM t1;
 
66
DELETE FROM t1;
 
67
 
 
68
--echo 'For utf8 characterset';
 
69
SET @@session.character_set_client = utf8;
 
70
INSERT INTO t1 values('�');
 
71
SELECT a,CHAR_LENGTH(a) FROM t1;
 
72
DELETE FROM t1;
 
73
 
 
74
--disable_warnings
 
75
DROP TABLE IF EXISTS t1;
 
76
--enable_warnings
 
77
 
 
78
# restore
 
79
SET @@global.character_set_client = @global_character_set_client;
 
80
SET @@session.character_set_client = @session_character_set_client;
 
81
 
 
82
############################################################
 
83
# End of functionality Testing for character_set_client    #
 
84
############################################################