diff options
Diffstat (limited to 'mysql-test/t/locale.test')
-rw-r--r-- | mysql-test/t/locale.test | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/mysql-test/t/locale.test b/mysql-test/t/locale.test index 7ceb49fd1f4..04ac95cea06 100644 --- a/mysql-test/t/locale.test +++ b/mysql-test/t/locale.test @@ -3,6 +3,44 @@ DROP TABLE IF EXISTS t1; --enable_warnings --echo Start of 5.4 tests + +--echo # +--echo # WL#4642 Greek locale for DAYNAME, MONTHNAME, DATE_FORMAT +--echo # + +SET NAMES utf8; + +SET @@lc_time_names=109; +SELECT @@lc_time_names; + +CREATE TABLE t1 (a DATE); +INSERT INTO t1 VALUES +('2006-01-01'),('2006-01-02'),('2006-01-03'), +('2006-01-04'),('2006-01-05'),('2006-01-06'),('2006-01-07'); +SELECT a, date_format(a,'%a') as abday, dayname(a) as day FROM t1 ORDER BY a; +DROP TABLE t1; + +CREATE TABLE t1 (a DATE); +INSERT INTO t1 VALUES +('2006-01-01'),('2006-02-01'),('2006-03-01'), +('2006-04-01'),('2006-05-01'),('2006-06-01'), +('2006-07-01'),('2006-08-01'),('2006-09-01'), +('2006-10-01'),('2006-11-01'),('2006-12-01'); +SELECT a, date_format(a,'%b') as abmon, monthname(a) as mon FROM t1 ORDER BY a; + +SELECT format(123456.789, 3, 'el_GR'); +DROP TABLE t1; + +--echo # +--echo # Bug#46633 Obsolete Serbian locale name +--echo # +SET lc_messages=sr_YU; +SHOW VARIABLES LIKE 'lc_messages'; +SET lc_messages=sr_RS; +SHOW VARIABLES LIKE 'lc_messages'; +SET lc_time_names=sr_RS; +SELECT format(123456.789, 3, 'sr_RS'); + --echo # --echo # Bug#43207 wrong LC_TIME names for romanian locale --echo # |