summaryrefslogtreecommitdiff
path: root/mysql-test/t/character_set_server_func.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/character_set_server_func.test')
-rw-r--r--mysql-test/t/character_set_server_func.test106
1 files changed, 0 insertions, 106 deletions
diff --git a/mysql-test/t/character_set_server_func.test b/mysql-test/t/character_set_server_func.test
deleted file mode 100644
index c17568c35ea..00000000000
--- a/mysql-test/t/character_set_server_func.test
+++ /dev/null
@@ -1,106 +0,0 @@
-############## mysql-test\t\character_set_server_func.test ###################
-# #
-# Variable Name: character_set_server #
-# Scope: GLOBAL | SESSION #
-# Access Type: Dynamic #
-# Data Type: string #
-# Default Value: utf8 (session), latin1 (global) #
-# Range: NA #
-# #
-# #
-# Creation Date: 2008-03-08 #
-# Author: Rizwan #
-# #
-# Description: Test Cases of Dynamic System Variable character_set_server #
-# that checks the behavior of this variable #
-# #
-# Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
-# server-system-variables.html #
-# #
-###############################################################################
---echo '#--------------------FN_DYNVARS_009_01-------------------------#'
-######################################################################
-# Check if setting character_set_server is changed in new connection #
-######################################################################
-
-#save
-SET @global_character_set_server = @@global.character_set_server;
-SET @session_character_set_server = @@session.character_set_server;
-
-
-SET @@global.character_set_server = utf8;
---echo 'connect (con1,localhost,root,,,,)'
-connect (con1,localhost,root,,,,);
---echo 'connection con1'
-connection con1;
-SELECT @@global.character_set_server;
-SELECT @@session.character_set_server;
-disconnect con1;
-
---echo '#--------------------FN_DYNVARS_009_02-------------------------#'
-#############################################################
-# Begin the functionality Testing of character_set_server #
-#############################################################
-
---echo 'connection default'
-connection default;
-#The server character set and collation are used as default values if the database
-#character set and collation are not specified in CREATE DATABASE statements.
-
-#==============================================================================
---echo '---global character_set_server should not effects current connection---'
-#==============================================================================
-
-SET @@global.character_set_server = utf8;
-CREATE DATABASE db1;
-USE db1;
-SHOW CREATE DATABASE db1;
-DROP DATABASE db1;
-select @@character_set_database;
-
-#==============================================================================
---echo '---session character_set_server should effects current connection---'
-#==============================================================================
-SET @@session.character_set_server = utf8;
-CREATE DATABASE db1;
-USE db1;
-SHOW CREATE DATABASE db1;
-DROP DATABASE db1;
-select @@character_set_database;
-
-#==============================================================================
---echo '----test with new connection----'
-#==============================================================================
-
---echo 'connect (con1,localhost,root,,,,)'
-connect (con1,localhost,root,,,,);
---echo 'connection con1'
-connection con1;
-
-SELECT @@session.character_set_server;
-
---echo '----------character set not specified---------'
-CREATE DATABASE db1;
-USE db1;
-SHOW CREATE DATABASE db1;
-DROP DATABASE db1;
-SELECT @@character_set_database;
-
---echo '----------ascii character set specified----------'
-CREATE DATABASE db1 character set ascii;
-USE db1;
-SHOW CREATE DATABASE db1;
-DROP DATABASE db1;
-select @@character_set_database;
-
-disconnect con1;
-
-#restore
---echo 'connection default;'
-connection default;
-SET @@global.character_set_server = @global_character_set_server;
-SET @@session.character_set_server = @session_character_set_server;
-
-############################################################
-# End of functionality Testing for character_set_server #
-############################################################