diff options
Diffstat (limited to 'mysql-test/r/locale.result')
-rw-r--r-- | mysql-test/r/locale.result | 63 |
1 files changed, 63 insertions, 0 deletions
diff --git a/mysql-test/r/locale.result b/mysql-test/r/locale.result index 89883b070d2..af7f9e3c132 100644 --- a/mysql-test/r/locale.result +++ b/mysql-test/r/locale.result @@ -1,6 +1,69 @@ DROP TABLE IF EXISTS t1; Start of 5.4 tests # +# WL#4642 Greek locale for DAYNAME, MONTHNAME, DATE_FORMAT +# +SET NAMES utf8; +SET @@lc_time_names=109; +SELECT @@lc_time_names; +@@lc_time_names +el_GR +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; +a abday day +2006-01-01 Κυρ Κυριακή +2006-01-02 Δευ Δευτέρα +2006-01-03 Τρί Τρίτη +2006-01-04 Τετ Τετάρτη +2006-01-05 Πέμ Πέμπτη +2006-01-06 Παρ Παρασκευή +2006-01-07 Σάβ Σάββατο +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; +a abmon mon +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 format(123456.789, 3, 'el_GR'); +format(123456.789, 3, 'el_GR') +123456.789 +DROP TABLE t1; +# +# Bug#46633 Obsolete Serbian locale name +# +SET lc_messages=sr_YU; +Warnings: +Warning 1287 'sr_YU' is deprecated; use 'sr_RS' instead +SHOW VARIABLES LIKE 'lc_messages'; +Variable_name Value +lc_messages sr_RS +SET lc_messages=sr_RS; +SHOW VARIABLES LIKE 'lc_messages'; +Variable_name Value +lc_messages sr_RS +SET lc_time_names=sr_RS; +SELECT format(123456.789, 3, 'sr_RS'); +format(123456.789, 3, 'sr_RS') +123456.789 +# # Bug#43207 wrong LC_TIME names for romanian locale # SET NAMES utf8; |