summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_time.result
diff options
context:
space:
mode:
authorunknown <serg@sergbook.mysql.com>2002-11-06 16:21:41 +0100
committerunknown <serg@sergbook.mysql.com>2002-11-06 16:21:41 +0100
commitc5d4041347524e1e4e415db15071fb7dd6aa79ac (patch)
tree066d458d95cd9cffe9746287acc7ae19dc814630 /mysql-test/r/func_time.result
parentf9b7e3abc8bb0b3440fd2a10e0b201cefb587f4a (diff)
downloadmariadb-git-c5d4041347524e1e4e415db15071fb7dd6aa79ac.tar.gz
BETWEEN fixed
myisam/ft_nlq_search.c: cleanup mysql-test/r/func_time.result: updated
Diffstat (limited to 'mysql-test/r/func_time.result')
-rw-r--r--mysql-test/r/func_time.result1
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result
index 671b56ef005..e4fd25a34f0 100644
--- a/mysql-test/r/func_time.result
+++ b/mysql-test/r/func_time.result
@@ -380,6 +380,7 @@ CREATE TABLE t3 (ctime1 char(19) NOT NULL, ctime2 char(19) NOT NULL);
INSERT INTO t3 VALUES ("2002-10-29 16:51:06","2002-11-05 16:47:31");
select * from t1, t2 where t1.start between t2.ctime1 and t2.ctime2;
start ctime1 ctime2
+2002-11-04 00:00:00 20021029165106 20021105164731
select * from t1, t2 where t1.start >= t2.ctime1 and t1.start <= t2.ctime2;
start ctime1 ctime2
2002-11-04 00:00:00 20021029165106 20021105164731