1DROP TABLE IF EXISTS t1; 2Start of 5.4 tests 3# 4# WL#4642 Greek locale for DAYNAME, MONTHNAME, DATE_FORMAT 5# 6SET NAMES utf8; 7SET @@lc_time_names=109; 8SELECT @@lc_time_names; 9@@lc_time_names 10el_GR 11CREATE TABLE t1 (a DATE); 12INSERT INTO t1 VALUES 13('2006-01-01'),('2006-01-02'),('2006-01-03'), 14('2006-01-04'),('2006-01-05'),('2006-01-06'),('2006-01-07'); 15SELECT a, date_format(a,'%a') as abday, dayname(a) as day FROM t1 ORDER BY a; 16a abday day 172006-01-01 Κυρ Κυριακή 182006-01-02 Δευ Δευτέρα 192006-01-03 Τρί Τρίτη 202006-01-04 Τετ Τετάρτη 212006-01-05 Πέμ Πέμπτη 222006-01-06 Παρ Παρασκευή 232006-01-07 Σάβ Σάββατο 24DROP TABLE t1; 25CREATE TABLE t1 (a DATE); 26INSERT INTO t1 VALUES 27('2006-01-01'),('2006-02-01'),('2006-03-01'), 28('2006-04-01'),('2006-05-01'),('2006-06-01'), 29('2006-07-01'),('2006-08-01'),('2006-09-01'), 30('2006-10-01'),('2006-11-01'),('2006-12-01'); 31SELECT a, date_format(a,'%b') as abmon, monthname(a) as mon FROM t1 ORDER BY a; 32a abmon mon 332006-01-01 Ιαν Ιανουάριος 342006-02-01 Φεβ Φεβρουάριος 352006-03-01 Μάρ Μάρτιος 362006-04-01 Απρ Απρίλιος 372006-05-01 Μάι Μάιος 382006-06-01 Ιούν Ιούνιος 392006-07-01 Ιούλ Ιούλιος 402006-08-01 Αύγ Αύγουστος 412006-09-01 Σεπ Σεπτέμβριος 422006-10-01 Οκτ Οκτώβριος 432006-11-01 Νοέ Νοέμβριος 442006-12-01 Δεκ Δεκέμβριος 45SELECT format(123456.789, 3, 'el_GR'); 46format(123456.789, 3, 'el_GR') 47123456,789 48DROP TABLE t1; 49# 50# Bug#46633 Obsolete Serbian locale name 51# 52SET lc_messages=sr_YU; 53Warnings: 54Warning 1287 'sr_YU' ist veraltet. Bitte benutzen Sie 'sr_RS' 55SHOW VARIABLES LIKE 'lc_messages'; 56Variable_name Value 57lc_messages sr_RS 58SET lc_messages=sr_RS; 59SHOW VARIABLES LIKE 'lc_messages'; 60Variable_name Value 61lc_messages sr_RS 62SET lc_time_names=sr_RS; 63SELECT format(123456.789, 3, 'sr_RS'); 64format(123456.789, 3, 'sr_RS') 65123456.789 66# 67# Bug#43207 wrong LC_TIME names for romanian locale 68# 69SET NAMES utf8; 70SET lc_time_names=ro_RO; 71SELECT DATE_FORMAT('2001-01-01', '%w %a %W'); 72DATE_FORMAT('2001-01-01', '%w %a %W') 731 Lu Luni 74SELECT DATE_FORMAT('2001-01-02', '%w %a %W'); 75DATE_FORMAT('2001-01-02', '%w %a %W') 762 Ma Marţi 77SELECT DATE_FORMAT('2001-01-03', '%w %a %W'); 78DATE_FORMAT('2001-01-03', '%w %a %W') 793 Mi Miercuri 80SELECT DATE_FORMAT('2001-01-04', '%w %a %W'); 81DATE_FORMAT('2001-01-04', '%w %a %W') 824 Jo Joi 83SELECT DATE_FORMAT('2001-01-05', '%w %a %W'); 84DATE_FORMAT('2001-01-05', '%w %a %W') 855 Vi Vineri 86SELECT DATE_FORMAT('2001-01-06', '%w %a %W'); 87DATE_FORMAT('2001-01-06', '%w %a %W') 886 Sâ Sâmbătă 89SELECT DATE_FORMAT('2001-01-07', '%w %a %W'); 90DATE_FORMAT('2001-01-07', '%w %a %W') 910 Du Duminică 92End of 5.4 tests 93SET NAMES utf8; 94SET lc_time_names=de_AT; 95SELECT monthname('2001-01-01'); 96monthname('2001-01-01') 97Jänner 98SELECT monthname('2001-02-01'); 99monthname('2001-02-01') 100Februar 101SELECT monthname('2001-03-01'); 102monthname('2001-03-01') 103März 104# 105# MDEV-10052 Illegal mix of collations with DAYNAME(date_field)<>varchar_field 106# 107SET NAMES utf8; 108CREATE TABLE t1 (c VARCHAR(8) CHARACTER SET latin1, d DATE); 109INSERT INTO t1 VALUES ('test',now()); 110Warnings: 111Note 1265 Data truncated for column 'd' at row 1 112SET lc_time_names=ru_RU; 113SELECT c FROM t1 WHERE DAYNAME(d)<>c; 114ERROR HY000: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation '<>' 115SELECT c FROM t1 WHERE MONTHNAME(d)<>c; 116ERROR HY000: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation '<>' 117SET lc_time_names=en_US; 118SELECT c FROM t1 WHERE DAYNAME(d)<>c; 119c 120test 121SELECT c FROM t1 WHERE MONTHNAME(d)<>c; 122c 123test 124SET NAMES latin1; 125SELECT c FROM t1 WHERE DAYNAME(d)<>c; 126c 127test 128SELECT c FROM t1 WHERE MONTHNAME(d)<>c; 129c 130test 131DROP TABLE t1; 132# 133# Start of 5.6 tests 134# 135# 136# WL#5303 Romansh locale for DAYNAME, MONTHNAME, DATE_FORMAT 137# 138SET NAMES utf8; 139SET @old_50915_lc_time_names := @@lc_time_names; 140SET lc_time_names=en_US; 141SELECT DATE_FORMAT('2001-01-01', '%w %a %W'); 142DATE_FORMAT('2001-01-01', '%w %a %W') 1431 Mon Monday 144SELECT DATE_FORMAT('2001-03-01', '%c %b %M'); 145DATE_FORMAT('2001-03-01', '%c %b %M') 1463 Mar March 147SET lc_time_names=rm_CH; 148SELECT DATE_FORMAT('2001-01-01', '%w %a %W'); 149DATE_FORMAT('2001-01-01', '%w %a %W') 1501 gli glindesdi 151SELECT DATE_FORMAT('2001-01-02', '%w %a %W'); 152DATE_FORMAT('2001-01-02', '%w %a %W') 1532 ma mardi 154SELECT DATE_FORMAT('2001-01-03', '%w %a %W'); 155DATE_FORMAT('2001-01-03', '%w %a %W') 1563 me mesemna 157SELECT DATE_FORMAT('2001-01-04', '%w %a %W'); 158DATE_FORMAT('2001-01-04', '%w %a %W') 1594 gie gievgia 160SELECT DATE_FORMAT('2001-01-05', '%w %a %W'); 161DATE_FORMAT('2001-01-05', '%w %a %W') 1625 ve venderdi 163SELECT DATE_FORMAT('2001-01-06', '%w %a %W'); 164DATE_FORMAT('2001-01-06', '%w %a %W') 1656 so sonda 166SELECT DATE_FORMAT('2001-01-07', '%w %a %W'); 167DATE_FORMAT('2001-01-07', '%w %a %W') 1680 du dumengia 169SELECT DATE_FORMAT('2001-01-01', '%c %b %M'); 170DATE_FORMAT('2001-01-01', '%c %b %M') 1711 schan schaner 172SELECT DATE_FORMAT('2001-02-01', '%c %b %M'); 173DATE_FORMAT('2001-02-01', '%c %b %M') 1742 favr favrer 175SELECT DATE_FORMAT('2001-03-01', '%c %b %M'); 176DATE_FORMAT('2001-03-01', '%c %b %M') 1773 mars mars 178SELECT DATE_FORMAT('2001-04-01', '%c %b %M'); 179DATE_FORMAT('2001-04-01', '%c %b %M') 1804 avr avrigl 181SELECT DATE_FORMAT('2001-05-01', '%c %b %M'); 182DATE_FORMAT('2001-05-01', '%c %b %M') 1835 matg matg 184SELECT DATE_FORMAT('2001-06-01', '%c %b %M'); 185DATE_FORMAT('2001-06-01', '%c %b %M') 1866 zercl zercladur 187SELECT DATE_FORMAT('2001-07-01', '%c %b %M'); 188DATE_FORMAT('2001-07-01', '%c %b %M') 1897 fan fanadur 190SELECT DATE_FORMAT('2001-08-01', '%c %b %M'); 191DATE_FORMAT('2001-08-01', '%c %b %M') 1928 avust avust 193SELECT DATE_FORMAT('2001-09-01', '%c %b %M'); 194DATE_FORMAT('2001-09-01', '%c %b %M') 1959 sett settember 196SELECT DATE_FORMAT('2001-10-01', '%c %b %M'); 197DATE_FORMAT('2001-10-01', '%c %b %M') 19810 oct october 199SELECT DATE_FORMAT('2001-11-01', '%c %b %M'); 200DATE_FORMAT('2001-11-01', '%c %b %M') 20111 nov november 202SELECT DATE_FORMAT('2001-12-01', '%c %b %M'); 203DATE_FORMAT('2001-12-01', '%c %b %M') 20412 dec december 205SET lc_time_names=de_CH; 206SELECT DATE_FORMAT('2001-01-06', '%w %a %W'); 207DATE_FORMAT('2001-01-06', '%w %a %W') 2086 Sa Samstag 209SELECT DATE_FORMAT('2001-09-01', '%c %b %M'); 210DATE_FORMAT('2001-09-01', '%c %b %M') 2119 Sep September 212SELECT DATE_FORMAT('2010-03-23 11:00:00','%h %p'); 213DATE_FORMAT('2010-03-23 11:00:00','%h %p') 21411 AM 215SELECT DATE_FORMAT('2010-03-23 13:00:00','%h %p'); 216DATE_FORMAT('2010-03-23 13:00:00','%h %p') 21701 PM 218SELECT format(123456789,2,'rm_CH'); 219format(123456789,2,'rm_CH') 220123'456'789,00 221SET lc_messages=rm_CH; 222SELECT * FROM non_existent; 223ERROR 42S02: Table 'test.non_existent' doesn't exist 224SET lc_time_names=@old_50915_lc_time_names; 225# 226# End of 10.0 tests 227# 228# 229# End of 10.1 tests 230# 231create view v1 as select 232date_format('2001-10-02', '%c %b %M') as a, 233date_format('2001-10-02', '%c %b %M', 'ru_RU') as a1, 234format(123456789,2) as b, 235format(123456789,2,'rm_CH') as b1; 236select * from v1; 237a a1 b b1 23810 Oct October 10 Окт Октября 123,456,789.00 123'456'789,00 239show create view v1; 240View Create View character_set_client collation_connection 241v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select date_format('2001-10-02','%c %b %M') AS `a`,date_format('2001-10-02','%c %b %M','ru_RU') AS `a1`,format(123456789,2) AS `b`,format(123456789,2,'rm_CH') AS `b1` utf8 utf8_general_ci 242drop view v1; 243# 244# End of 10.2 tests 245# 246select date_format('2001-01-01', '%w %a %W', 'ro_RO'); 247date_format('2001-01-01', '%w %a %W', 'ro_RO') 2481 Lu Luni 249select date_format('2001-01-03', '%w %a %W', 'ro_RO'); 250date_format('2001-01-03', '%w %a %W', 'ro_RO') 2513 Mi Miercuri 252select date_format('2001-01-05', '%w %a %W', 'ro_RO'); 253date_format('2001-01-05', '%w %a %W', 'ro_RO') 2545 Vi Vineri 255select date_format('2001-01-07', '%w %a %W', 'ro_RO'); 256date_format('2001-01-07', '%w %a %W', 'ro_RO') 2570 Du Duminică 258select date_format('2001-01-01', '%w %a %W', 'de_AT'); 259date_format('2001-01-01', '%w %a %W', 'de_AT') 2601 Mon Montag 261select date_format('2001-02-01', '%w %a %W', 'de_AT'); 262date_format('2001-02-01', '%w %a %W', 'de_AT') 2634 Don Donnerstag 264select date_format('2001-03-01', '%w %a %W', 'de_AT'); 265date_format('2001-03-01', '%w %a %W', 'de_AT') 2664 Don Donnerstag 267select date_format('2001-01-01', '%w %a %W', 'en_US'); 268date_format('2001-01-01', '%w %a %W', 'en_US') 2691 Mon Monday 270select date_format('2001-03-01', '%c %b %M', 'en_US'); 271date_format('2001-03-01', '%c %b %M', 'en_US') 2723 Mar March 273select date_format('2001-01-01', '%w %a %W', 'rm_CH'); 274date_format('2001-01-01', '%w %a %W', 'rm_CH') 2751 gli glindesdi 276select date_format('2001-01-03', '%w %a %W', 'rm_CH'); 277date_format('2001-01-03', '%w %a %W', 'rm_CH') 2783 me mesemna 279select date_format('2001-01-05', '%w %a %W', 'rm_CH'); 280date_format('2001-01-05', '%w %a %W', 'rm_CH') 2815 ve venderdi 282select date_format('2001-01-07', '%w %a %W', 'rm_CH'); 283date_format('2001-01-07', '%w %a %W', 'rm_CH') 2840 du dumengia 285select date_format('2001-02-01', '%c %b %M', 'rm_CH'); 286date_format('2001-02-01', '%c %b %M', 'rm_CH') 2872 favr favrer 288select date_format('2001-04-01', '%c %b %M', 'rm_CH'); 289date_format('2001-04-01', '%c %b %M', 'rm_CH') 2904 avr avrigl 291select date_format('2001-06-01', '%c %b %M', 'rm_CH'); 292date_format('2001-06-01', '%c %b %M', 'rm_CH') 2936 zercl zercladur 294select date_format('2001-08-01', '%c %b %M', 'rm_CH'); 295date_format('2001-08-01', '%c %b %M', 'rm_CH') 2968 avust avust 297select date_format('2001-10-01', '%c %b %M', 'rm_CH'); 298date_format('2001-10-01', '%c %b %M', 'rm_CH') 29910 oct october 300select date_format('2001-12-01', '%c %b %M', 'rm_CH'); 301date_format('2001-12-01', '%c %b %M', 'rm_CH') 30212 dec december 303select date_format('2001-01-06', '%w %a %W', 'de_CH'); 304date_format('2001-01-06', '%w %a %W', 'de_CH') 3056 Sa Samstag 306select date_format('2001-09-01', '%c %b %M', 'de_CH'); 307date_format('2001-09-01', '%c %b %M', 'de_CH') 3089 Sep September 309