summaryrefslogtreecommitdiff
path: root/mysql-test/r/locale.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/locale.result')
-rw-r--r--mysql-test/r/locale.result63
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;