diff options
| author | unknown <hf@deer.(none)> | 2004-03-23 21:10:23 +0400 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2004-03-23 21:10:23 +0400 |
| commit | 9079dc1a662f470688802294571c685f8532c39a (patch) | |
| tree | 82f5452104b98b0806bd9f1f63f6042f14fd6717 /mysql-test/t/func_time.test | |
| parent | 78b4ba746b79ea7d89044e3eecd56338a8f4eb6f (diff) | |
| download | mariadb-git-9079dc1a662f470688802294571c685f8532c39a.tar.gz | |
Fix for #3264 (FROM_DAYS doesn't work properly in range comparison)
Item_func_from_days::get_date didn't change 'hr', 'min' and some
other fields of incoming ltime, so they got random values.
bzeroing of the ltime added
mysql-test/r/func_time.result:
appropriate test result
mysql-test/t/func_time.test:
test case
sql/item_timefunc.cc:
cleaning ltime added
Diffstat (limited to 'mysql-test/t/func_time.test')
| -rw-r--r-- | mysql-test/t/func_time.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index 6417d5448e5..ecb440ff079 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -272,3 +272,11 @@ select strcmp(date_format(utc_timestamp(),"%Y-%m-%d"), utc_date())=0; select strcmp(concat(utc_date(),' ',utc_time()),utc_timestamp())=0; explain extended select period_add("9602",-12),period_diff(199505,"9404"),from_days(to_days("960101")),dayofmonth("1997-01-02"), month("1997-01-02"), monthname("1972-03-04"),dayofyear("0000-00-00"),HOUR("1997-03-03 23:03:22"),MINUTE("23:03:22"),SECOND(230322),QUARTER(980303),WEEK("1998-03-03"),yearweek("2000-01-01",1),week(19950101,1),year("98-02-03"),weekday(curdate())-weekday(now()),dayname("1962-03-03"),unix_timestamp(),sec_to_time(time_to_sec("0:30:47")/6.21),curtime(),utc_time(),curdate(),utc_date(),utc_timestamp(),date_format("1997-01-02 03:04:05", "%M %W %D %Y %y %m %d %h %i %s %w"),from_unixtime(unix_timestamp("1994-03-02 10:11:12")),"1997-12-31 23:59:59" + INTERVAL 1 SECOND,"1998-01-01 00:00:00" - INTERVAL 1 SECOND,INTERVAL 1 DAY + "1997-12-31", extract(YEAR FROM "1999-01-02 10:11:12"),date_add("1997-12-31 23:59:59",INTERVAL 1 SECOND); + +CREATE TABLE t1 (d DATETIME); +INSERT INTO t1 VALUES (NOW()); +INSERT INTO t1 VALUES (NOW()); +INSERT INTO t1 VALUES (NOW()); +SELECT count(*) FROM t1 WHERE d>FROM_DAYS(TO_DAYS(NOW())) AND d<=FROM_DAYS(TO_DAYS(NOW())+1); +DROP TABLE t1; + |