1--disable_warnings 2DROP TABLE IF EXISTS t1; 3--enable_warnings 4 5--echo Start of 5.4 tests 6 7--echo # 8--echo # WL#4642 Greek locale for DAYNAME, MONTHNAME, DATE_FORMAT 9--echo # 10 11SET NAMES utf8; 12 13SET @@lc_time_names=109; 14SELECT @@lc_time_names; 15 16CREATE TABLE t1 (a DATE); 17INSERT INTO t1 VALUES 18('2006-01-01'),('2006-01-02'),('2006-01-03'), 19('2006-01-04'),('2006-01-05'),('2006-01-06'),('2006-01-07'); 20SELECT a, date_format(a,'%a') as abday, dayname(a) as day FROM t1 ORDER BY a; 21DROP TABLE t1; 22 23CREATE TABLE t1 (a DATE); 24INSERT INTO t1 VALUES 25('2006-01-01'),('2006-02-01'),('2006-03-01'), 26('2006-04-01'),('2006-05-01'),('2006-06-01'), 27('2006-07-01'),('2006-08-01'),('2006-09-01'), 28('2006-10-01'),('2006-11-01'),('2006-12-01'); 29SELECT a, date_format(a,'%b') as abmon, monthname(a) as mon FROM t1 ORDER BY a; 30 31SELECT format(123456.789, 3, 'el_GR'); 32DROP TABLE t1; 33 34--echo # 35--echo # Bug#46633 Obsolete Serbian locale name 36--echo # 37SET lc_messages=sr_YU; 38SHOW VARIABLES LIKE 'lc_messages'; 39SET lc_messages=sr_RS; 40SHOW VARIABLES LIKE 'lc_messages'; 41SET lc_time_names=sr_RS; 42SELECT format(123456.789, 3, 'sr_RS'); 43 44--echo # 45--echo # Bug#43207 wrong LC_TIME names for romanian locale 46--echo # 47SET NAMES utf8; 48SET lc_time_names=ro_RO; 49SELECT DATE_FORMAT('2001-01-01', '%w %a %W'); 50SELECT DATE_FORMAT('2001-01-02', '%w %a %W'); 51SELECT DATE_FORMAT('2001-01-03', '%w %a %W'); 52SELECT DATE_FORMAT('2001-01-04', '%w %a %W'); 53SELECT DATE_FORMAT('2001-01-05', '%w %a %W'); 54SELECT DATE_FORMAT('2001-01-06', '%w %a %W'); 55SELECT DATE_FORMAT('2001-01-07', '%w %a %W'); 56--echo End of 5.4 tests 57 58 59--echo # 60--echo # Start of 5.6 tests 61--echo # 62 63--echo # 64--echo # WL#5303 Romansh locale for DAYNAME, MONTHNAME, DATE_FORMAT 65--echo # 66 67SET NAMES utf8; 68SET @old_50915_lc_time_names := @@lc_time_names; 69SET lc_time_names=en_US; 70SELECT DATE_FORMAT('2001-01-01', '%w %a %W'); 71SELECT DATE_FORMAT('2001-03-01', '%c %b %M'); 72SET lc_time_names=rm_CH; 73SELECT DATE_FORMAT('2001-01-01', '%w %a %W'); 74SELECT DATE_FORMAT('2001-01-02', '%w %a %W'); 75SELECT DATE_FORMAT('2001-01-03', '%w %a %W'); 76SELECT DATE_FORMAT('2001-01-04', '%w %a %W'); 77SELECT DATE_FORMAT('2001-01-05', '%w %a %W'); 78SELECT DATE_FORMAT('2001-01-06', '%w %a %W'); 79SELECT DATE_FORMAT('2001-01-07', '%w %a %W'); 80SELECT DATE_FORMAT('2001-01-01', '%c %b %M'); 81SELECT DATE_FORMAT('2001-02-01', '%c %b %M'); 82SELECT DATE_FORMAT('2001-03-01', '%c %b %M'); 83SELECT DATE_FORMAT('2001-04-01', '%c %b %M'); 84SELECT DATE_FORMAT('2001-05-01', '%c %b %M'); 85SELECT DATE_FORMAT('2001-06-01', '%c %b %M'); 86SELECT DATE_FORMAT('2001-07-01', '%c %b %M'); 87SELECT DATE_FORMAT('2001-08-01', '%c %b %M'); 88SELECT DATE_FORMAT('2001-09-01', '%c %b %M'); 89SELECT DATE_FORMAT('2001-10-01', '%c %b %M'); 90SELECT DATE_FORMAT('2001-11-01', '%c %b %M'); 91SELECT DATE_FORMAT('2001-12-01', '%c %b %M'); 92SET lc_time_names=de_CH; 93SELECT DATE_FORMAT('2001-01-06', '%w %a %W'); 94SELECT DATE_FORMAT('2001-09-01', '%c %b %M'); 95 96# Checking AM/PM 97SELECT DATE_FORMAT('2010-03-23 11:00:00','%h %p'); 98SELECT DATE_FORMAT('2010-03-23 13:00:00','%h %p'); 99 100# Checking numeric format 101SELECT format(123456789,2,'rm_CH'); 102 103# Checking that error messages point to en_US. 104SET lc_messages=rm_CH; 105--error ER_NO_SUCH_TABLE 106SELECT * FROM non_existent; 107 108SET lc_time_names=@old_50915_lc_time_names; 109 110 111--echo # 112--echo # End of 5.6 tests 113--echo # 114