diff options
| author | unknown <serg@serg.mylan> | 2003-07-02 23:37:24 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2003-07-02 23:37:24 +0200 |
| commit | 4872adb66367d64737147c45347d277c61fb884f (patch) | |
| tree | 5695d47e1e9a53c1bc8f2f1ca77fe5fac5d77639 /mysql-test/r | |
| parent | 8c113acf966cb0dab9684d781323a34029e76700 (diff) | |
| parent | 7bb4166a9aa53755b49de865cc639afa9098de7c (diff) | |
| download | mariadb-git-4872adb66367d64737147c45347d277c61fb884f.tar.gz | |
Merge bk-internal:/home/bk/mysql-4.0/
into serg.mylan:/usr/home/serg/Abk/mysql-4.0
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/type_datetime.result | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/mysql-test/r/type_datetime.result b/mysql-test/r/type_datetime.result index 4785f790069..5df4f355cfb 100644 --- a/mysql-test/r/type_datetime.result +++ b/mysql-test/r/type_datetime.result @@ -52,10 +52,17 @@ a 0000-00-00 00:00:00 drop table t1; create table t1 (id int, dt datetime); -insert into t1 values (1,"2001-08-14 00:00:00"),(2,"2001-08-15 00:00:00"),(3,"2001-08-16 00:00:00"); +insert into t1 values (1,"2001-08-14 00:00:00"),(2,"2001-08-15 00:00:00"),(3,"2001-08-16 00:00:00"),(4,"2003-09-15 01:20:30"); select * from t1 where dt='2001-08-14 00:00:00' and dt = if(id=1,'2001-08-14 00:00:00','1999-08-15'); id dt 1 2001-08-14 00:00:00 +create index dt on t1 (dt); +select * from t1 where dt > 20021020; +id dt +4 2003-09-15 01:20:30 +select * from t1 ignore index (dt) where dt > 20021020; +id dt +4 2003-09-15 01:20:30 drop table t1; CREATE TABLE `t1` ( `date` datetime NOT NULL default '0000-00-00 00:00:00', |