diff options
| author | Horst Hunger <horst@mysql.com> | 2008-12-19 16:03:32 +0100 |
|---|---|---|
| committer | Horst Hunger <horst@mysql.com> | 2008-12-19 16:03:32 +0100 |
| commit | 357b5009409ed6666bf1df48a80d76cd42a482c8 (patch) | |
| tree | 7a2fa9b404ffb20d1572c51a0bca7ecc64992310 /mysql-test/t/lc_time_names_func.test | |
| parent | ba816c14a9bc8012759da9d58f858f1e73bec708 (diff) | |
| download | mariadb-git-357b5009409ed6666bf1df48a80d76cd42a482c8.tar.gz | |
WL#4681: Took the system variable tests out of the main test suite, put them into "sys_vars", updated some reult files and tests.
Diffstat (limited to 'mysql-test/t/lc_time_names_func.test')
| -rw-r--r-- | mysql-test/t/lc_time_names_func.test | 87 |
1 files changed, 0 insertions, 87 deletions
diff --git a/mysql-test/t/lc_time_names_func.test b/mysql-test/t/lc_time_names_func.test deleted file mode 100644 index 2c86a597773..00000000000 --- a/mysql-test/t/lc_time_names_func.test +++ /dev/null @@ -1,87 +0,0 @@ -###################### mysql-test\t\lc_time_names_func.test ################## -# # -# Variable Name: lc_time_names # -# Scope: GLOBAL | SESSION # -# Access Type: Dynamic # -# Data Type: string # -# Default Value: en_US # -# Range: NA # -# # -# # -# Creation Date: 2008-03-08 # -# Author: Rizwan # -# # -# Description: Test Cases of Dynamic System Variable lc_time_names # -# that checks the behavior of this variable # -# # -# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # -# server-system-variables.html # -# # -############################################################################### - ---echo '#--------------------FN_DYNVARS_060_01-------------------------#' -###################################################################### -# Check if setting global lc_time_names is changed in new connection # -###################################################################### - -SET @@global.lc_time_names = "en_CA"; ---echo 'connect (con1,localhost,root,,,,)' -connect (con1,localhost,root,,,,); ---echo 'connection con1' -connection con1; -SELECT @@global.lc_time_names; -SELECT @@session.lc_time_names; -SET @@global.lc_time_names = "en_IN"; ---echo 'connect (con2,localhost,root,,,,)' -connect (con2,localhost,root,,,,); ---echo 'connection con2' -connection con2; -SELECT @@global.lc_time_names; -SELECT @@session.lc_time_names; -disconnect con2; -disconnect con1; - - ---echo '#--------------------FN_DYNVARS_060_02-------------------------#' -################################################################# -# Begin the functionality Testing of lc_time_names # -################################################################# - ---echo 'connection default' -connection default; - -SET NAMES 'utf8'; - -SET @@session.lc_time_names = 'en_US'; -SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); - - -SET @@session.lc_time_names = 'ar_AE'; -SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); - -SET @@session.lc_time_names = 'es_ES'; -SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); - -SET @@session.lc_time_names = 'fi_FI'; -SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); - -SET @@session.lc_time_names = 'gu_IN'; -SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); - -SET @@session.lc_time_names = 'it_IT'; -SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); - -SET @@session.lc_time_names = 'pt_BR'; -SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); - -SET @@session.lc_time_names = 'ur_PK'; -SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); - - -# restore default -SET @@global.lc_time_names = "en_US"; - -########################################################## -# End of functionality Testing for lc_time_names # -########################################################## - |