diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-09-18 13:30:44 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-09-18 13:30:44 +0400 |
| commit | 79140b03839a6b46a92736bd2ce03cefd43a5058 (patch) | |
| tree | fc7f6b612b2f2ae29abcfc3cbdd30a98c9e7be99 /mysql-test/r/func_time.result | |
| parent | f789158ddfa90933678dc927a05719ba692d0854 (diff) | |
| download | mariadb-git-79140b03839a6b46a92736bd2ce03cefd43a5058.tar.gz | |
MDEV-8793 Wrong result set for SELECT ...
WHERE COALESCE(time_column)=TIME('00:00:00')
AND COALESCE(time_column)=DATE('2015-09-11')
MDEV-8814 Wrong result for WHERE datetime_column > TIME('00:00:00')
Diffstat (limited to 'mysql-test/r/func_time.result')
| -rw-r--r-- | mysql-test/r/func_time.result | 2 |
1 files changed, 0 insertions, 2 deletions
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result index b829bb6ead7..043350ce022 100644 --- a/mysql-test/r/func_time.result +++ b/mysql-test/r/func_time.result @@ -1824,8 +1824,6 @@ create table t1 (f1 datetime, key (f1)); insert into t1 values ('2000-09-12 00:00:00'), ('2007-04-25 05:08:49'); select * from t1 where f1 > time('-23:00:06'); f1 -2000-09-12 00:00:00 -2007-04-25 05:08:49 drop table t1; select maketime(20,61,10)+0; maketime(20,61,10)+0 |