diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-04-18 21:01:49 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-04-18 21:01:49 +0200 |
| commit | a7ff7918a055a8dbae10c59279b2d9ee7f5c07e0 (patch) | |
| tree | a139785343b761506e934d45b349388b683ee0b4 /mysql-test/r/range.result | |
| parent | b1cd09600787e26665be7125c140a67474b654f1 (diff) | |
| download | mariadb-git-a7ff7918a055a8dbae10c59279b2d9ee7f5c07e0.tar.gz | |
lp:750117 Bogus warning with aggregate and datetime column
implement Item_cache_int::getdate() and Item_cache_int::save_in_field()
that handle the case of the cached packed datetime value.
Diffstat (limited to 'mysql-test/r/range.result')
| -rw-r--r-- | mysql-test/r/range.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result index 8ece431eee2..a472772a7e9 100644 --- a/mysql-test/r/range.result +++ b/mysql-test/r/range.result @@ -1659,3 +1659,9 @@ c_key c_notkey 3 3 DROP TABLE t1; End of 5.1 tests +create table t1 (f1 datetime, key (f1)); +insert into t1 values ('2000-03-09 15:56:59'),('2000-05-05 23:24:28'),('2000-06-13 13:12:06'); +select min(f1) from t1 where f1 >= '2006-05-25 07:00:20' and f1 between '2003-11-23 10:00:09' and '2010-01-01 01:01:01' and f1 > '2001-01-01 01:01:01'; +min(f1) +NULL +drop table t1; |