summaryrefslogtreecommitdiff
path: root/mysql-test/t/ps.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/ps.test')
-rw-r--r--mysql-test/t/ps.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test
index f53e72defcd..18329a1aa75 100644
--- a/mysql-test/t/ps.test
+++ b/mysql-test/t/ps.test
@@ -3369,3 +3369,13 @@ FROM (SELECT 1 UNION SELECT 2) t;
--echo # End of 5.5 tests.
###########################################################################
+#
+# restoring of the Item tree in BETWEEN with dates
+#
+prepare stmt from "select date('2010-10-10') between '2010-09-09' and ?";
+set @a='2010-11-11';
+execute stmt using @a;
+execute stmt using @a;
+set @a='2010-08-08';
+execute stmt using @a;
+execute stmt using @a;