From a7ff7918a055a8dbae10c59279b2d9ee7f5c07e0 Mon Sep 17 00:00:00 2001
From: Sergei Golubchik <sergii@pisem.net>
Date: Mon, 18 Apr 2011 21:01:49 +0200
Subject: 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.
---
 mysql-test/t/range.test | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'mysql-test/t/range.test')

diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test
index 0ad3d3e8504..8f8c8c08619 100644
--- a/mysql-test/t/range.test
+++ b/mysql-test/t/range.test
@@ -1326,3 +1326,12 @@ SELECT * FROM t1 WHERE 2 NOT BETWEEN c_notkey AND c_key;
 DROP TABLE t1;
 
 --echo End of 5.1 tests
+
+#
+# lp:750117 Bogus warning with aggregate and datetime column
+#
+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';
+drop table t1;
+
-- 
cgit v1.2.1