diff --git a/mysql-test/r/memory_leak.result b/mysql-test/r/memory_leak.result
new file mode 100644
index 0000000..55fe58b
--- /dev/null
+++ b/mysql-test/r/memory_leak.result
@@ -0,0 +1,13 @@
+CREATE TABLE `ta` (
+`id` bigint(20) NOT NULL AUTO_INCREMENT,
+`u` bigint(20) NOT NULL,
+`t` datetime NOT NULL,
+PRIMARY KEY (`id`),
+KEY `t` (`t`),
+KEY `u` (`u`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+INSERT INTO `ta` VALUES (1,21,'2013-12-24 05:02:01'),(2,22,'2013-12-24 06:19:37'),(3,23,'2013-12-24 06:19:38'),(4,24,'2013-12-24 06:19:39'),(5,25,'2013-12-24 06:19:41'),(6,26,'2013-12-24 06:19:42'),(7,27,'2013-12-24 06:19:43'),(8,28,'2013-12-24 06:19:44'),(9,29,'2013-12-24 06:19:45'),(10,30,'2013-12-24 06:19:46'),(11,31,'2013-12-24 06:19:47'),(12,32,'2013-12-24 06:19:48'),(13,33,'2013-12-24 06:19:49'),(14,34,'2013-12-24 06:19:50'),(15,35,'2013-12-24 06:19:51'),(16,36,'2013-12-24 06:19:52'),(17,37,'2013-12-24 06:19:52'),(18,38,'2013-12-24 06:19:53'),(19,39,'2013-12-24 06:19:53'),(20,40,'2013-12-24 06:19:54'),(21,41,'2013-12-25 06:19:55'),(22,42,'2013-12-24 06:19:55'),(23,43,'2013-12-24 06:19:56'),(24,44,'2013-12-24 06:19:57'),(25,45,'2013-12-24 06:19:58'),(26,46,'2013-12-25 06:19:58'),(27,47,'2013-12-24 06:19:59'),(28,48,'2013-12-24 06:20:00'),(29,49,'2013-12-25 06:20:00'),(30,50,'2013-12-26 06:20:01'),(31,51,'2013-12-24 06:20:01'),(32,52,'2013-12-24 06:20:02'),(33,53,'2013-12-24 06:20:03'),(34,54,'2013-12-25 06:20:03'),(35,55,'2013-12-24 06:20:04'),(36,56,'2013-12-24 06:20:05'),(69,62,'2013-12-25 07:13:59'),(70,62,'2013-12-25 07:18:21'),(71,62,'2013-12-25 07:23:23'),(72,62,'2013-12-25 07:29:29'),(73,62,'2013-12-25 07:38:36'),(74,62,'2013-12-25 07:44:08'),(75,62,'2013-12-25 07:49:13'),(76,62,'2013-12-25 07:54:38'),(77,62,'2013-12-25 12:56:53'),(78,62,'2013-12-25 14:31:00'),(79,62,'2013-12-25 20:22:00'),(80,62,'2013-12-25 20:34:58'),(81,62,'2013-12-26 07:26:36'),(82,62,'2013-12-26 07:32:03'),(83,63,'2013-12-26 08:39:21'),(84,62,'2013-12-26 09:27:25'),(85,62,'2013-12-26 14:04:07'),(86,62,'2013-12-27 00:30:56'),(87,62,'2013-12-27 00:48:23'),(88,62,'2013-12-27 01:13:12'),(102,21,'2013-12-27 04:51:06'),(131,62,'2013-12-27 12:37:45'),(132,62,'2013-12-27 13:16:31'),(133,62,'2013-12-27 13:30:28'),(135,62,'2013-12-27 21:32:44'),(136,62,'2013-12-28 02:23:38'),(139,62,'2013-12-28 02:51:33'),(140,62,'2013-12-28 03:06:13'),(148,64,'2013-12-28 05:32:11'),(150,63,'2013-12-28 05:38:22'),(151,62,'2013-12-28 05:39:26'),(154,64,'2013-12-28 05:42:46'),(155,62,'2013-12-28 05:44:41'),(156,62,'2013-12-28 05:50:48'),(157,62,'2013-12-28 06:11:59'),(158,62,'2013-12-28 06:37:45'),(160,63,'2013-12-28 06:38:57'),(162,62,'2013-12-28 08:17:42'),(163,64,'2013-12-28 08:28:04'),(164,64,'2013-12-28 08:33:04'),(165,64,'2013-12-28 08:38:51'),(166,64,'2013-12-28 08:46:48'),(167,64,'2013-12-28 08:51:50'),(168,64,'2013-12-28 08:56:50'),(169,64,'2013-12-28 09:01:56'),(172,64,'2013-12-28 09:24:13'),(173,62,'2013-12-28 09:29:52'),(174,62,'2013-12-28 09:35:59'),(175,64,'2013-12-28 10:59:38'),(176,64,'2013-12-28 11:12:00'),(179,62,'2013-12-28 13:09:24'),(184,64,'2013-12-28 14:09:43'),(185,64,'2013-12-28 14:20:35'),(186,64,'2013-12-28 14:30:37'),(187,64,'2013-12-28 14:35:39'),(188,64,'2013-12-28 14:40:37'),(189,64,'2013-12-28 14:45:37'),(190,64,'2013-12-28 14:50:38'),(191,64,'2013-12-28 14:57:14'),(192,64,'2013-12-28 23:52:08'),(193,64,'2013-12-28 23:59:43'),(194,64,'2013-12-29 00:04:51'),(195,64,'2013-12-29 00:13:19'),(196,64,'2013-12-29 00:19:42'),(197,62,'2013-12-29 01:40:25'),(198,64,'2013-12-29 03:24:01'),(199,64,'2013-12-29 03:30:03'),(200,64,'2013-12-29 03:35:30'),(201,64,'2013-12-29 03:40:50'),(202,64,'2013-12-29 03:46:14'),(203,64,'2013-12-29 03:51:21'),(204,64,'2013-12-29 03:56:25'),(205,64,'2013-12-29 04:26:44'),(206,64,'2013-12-29 04:32:01'),(207,64,'2013-12-29 04:36:28'),(208,64,'2013-12-29 07:04:52'),(209,64,'2013-12-29 08:24:33'),(210,62,'2013-12-29 10:33:41'),(211,62,'2013-12-29 10:41:14'),(212,64,'2013-12-29 11:16:37'),(213,64,'2013-12-29 11:25:32'),(214,64,'2013-12-29 12:19:09'),(215,62,'2013-12-29 14:32:34'),(216,62,'2013-12-29 14:38:42'),(217,62,'2013-12-29 14:45:31'),(218,64,'2013-12-29 22:55:48'),(219,64,'2013-12-29 23:26:31'),(220,64,'2013-12-29 23:32:14'),(221,64,'2013-12-29 23:37:46'),(222,64,'2013-12-29 23:43:03'),(223,64,'2013-12-29 23:51:57'),(224,64,'2013-12-29 23:57:42'),(225,64,'2013-12-30 00:02:51'),(226,64,'2013-12-30 00:11:42'),(227,62,'2013-12-30 00:47:19'),(228,62,'2013-12-30 01:18:54'),(231,64,'2013-12-30 05:00:13'),(232,64,'2013-12-30 05:00:22'),(234,64,'2013-12-30 05:41:08'),(235,64,'2013-12-30 05:46:52'),(236,64,'2013-12-30 05:52:06'),(237,64,'2013-12-30 05:57:13'),(238,64,'2013-12-30 06:02:13'),(239,64,'2013-12-30 06:07:15'),(242,64,'2013-12-30 10:29:20'),(243,64,'2013-12-30 10:35:01'),(246,62,'2013-12-30 12:32:26'),(249,62,'2013-12-30 12:41:35'),(252,63,'2013-12-30 13:51:35'),(257,62,'2013-12-30 14:32:01'),(261,66,'2013-12-30 17:02:15'),(268,66,'2013-12-31 00:39:34'),(269,62,'2013-12-31 00:55:18'),(270,63,'2013-12-31 01:12:25'),(271,62,'2013-12-31 01:12:56'),(272,62,'2013-12-31 01:17:59'),(273,66,'2013-12-31 01:25:33'),(274,66,'2013-12-31 01:30:37'),(277,66,'2013-12-31 04:46:35'),(278,66,'2013-12-31 04:56:56'),(279,66,'2013-12-31 05:04:54'),(281,66,'2013-12-31 05:36:14'),(283,66,'2013-12-31 05:43:27'),(286,66,'2013-12-31 06:33:58'),(287,66,'2013-12-31 06:52:07'),(296,66,'2013-12-31 10:55:42'),(298,66,'2013-12-31 11:49:16'),(302,67,'2013-12-31 12:08:41'),(306,62,'2013-12-31 12:44:36'),(308,63,'2013-12-31 13:04:20'),(309,63,'2013-12-31 13:06:04'),(310,63,'2013-12-31 13:08:42'),(311,63,'2013-12-31 13:13:55'),(312,63,'2013-12-31 13:19:12'),(314,63,'2013-12-31 13:24:34'),(316,63,'2013-12-31 13:29:36'),(317,62,'2013-12-31 13:44:10'),(318,62,'2013-12-31 13:49:56'),(319,62,'2013-12-31 14:01:14'),(320,66,'2013-12-31 14:01:30'),(321,62,'2013-12-31 14:37:20'),(322,62,'2013-12-31 14:43:30'),(323,66,'2013-12-31 14:54:36'),(324,62,'2013-12-31 15:05:47'),(325,62,'2013-12-31 15:10:53'),(326,62,'2013-12-31 15:19:16'),(327,62,'2013-12-31 15:24:17'),(328,62,'2013-12-31 15:29:22'),(329,62,'2013-12-31 15:34:50'),(330,62,'2013-12-31 15:40:15'),(331,62,'2013-12-31 15:46:17'),(332,62,'2013-12-31 16:10:41'),(333,62,'2013-12-31 16:15:36'),(334,62,'2013-12-31 16:20:40'),(335,62,'2013-12-31 16:26:58'),(344,66,'2014-01-01 05:18:27'),(345,66,'2014-01-01 05:27:33'),(346,66,'2014-01-01 05:35:42'),(347,66,'2014-01-01 05:41:57'),(349,66,'2014-01-01 07:32:08'),(368,66,'2014-01-01 11:55:30'),(369,66,'2014-01-01 13:26:22'),(374,63,'2014-01-02 01:17:10'),(375,66,'2014-01-02 01:20:52'),(376,63,'2014-01-02 01:22:17'),(377,63,'2014-01-02 01:27:32'),(378,66,'2014-01-02 01:30:17'),(379,63,'2014-01-02 01:34:16'),(380,63,'2014-01-02 01:42:21'),(381,63,'2014-01-02 01:47:38'),(397,66,'2014-01-02 04:28:52'),(408,63,'2014-01-02 06:28:07'),(410,63,'2014-01-02 06:37:12'),(416,69,'2014-01-02 06:58:28'),(448,66,'2014-01-02 08:31:04'),(506,63,'2014-01-02 10:24:03'),(508,63,'2014-01-02 10:31:13'),(553,61,'2014-01-02 12:14:23'),(574,63,'2014-01-02 12:47:39'),(579,69,'2014-01-02 12:55:44'),(580,66,'2014-01-02 13:00:00'),(581,69,'2014-01-02 13:12:11'),(584,69,'2014-01-02 13:22:10'),(586,63,'2014-01-02 13:25:39'),(587,66,'2014-01-02 13:27:16'),(588,63,'2014-01-02 13:31:07'),(589,63,'2014-01-02 13:36:56'),(590,63,'2014-01-02 13:42:03'),(591,63,'2014-01-02 13:47:14'),(592,63,'2014-01-02 13:52:23'),(612,63,'2014-01-03 01:53:35'),(614,63,'2014-01-03 01:59:00'),(615,63,'2014-01-03 02:05:43'),(617,66,'2014-01-03 02:41:15'),(618,66,'2014-01-03 02:54:47'),(725,63,'2014-01-03 06:23:32'),(760,66,'2014-01-03 07:40:17'),(776,69,'2014-01-03 08:03:28'),(834,63,'2014-01-03 11:23:29'),(837,63,'2014-01-03 11:28:42'),(838,69,'2014-01-03 11:28:57'),(840,63,'2014-01-03 11:34:57'),(841,63,'2014-01-03 11:40:04'),(847,63,'2014-01-03 11:56:31'),(849,69,'2014-01-03 11:57:59'),(858,66,'2014-01-03 13:06:59'),(860,69,'2014-01-03 14:03:16'),(861,63,'2014-01-03 14:33:44'),(862,63,'2014-01-03 15:06:51'),(863,63,'2014-01-03 15:07:55'),(865,66,'2014-01-04 00:19:59'),(873,66,'2014-01-04 03:27:51'),(874,66,'2014-01-04 03:29:20'),(875,66,'2014-01-04 03:30:11'),(880,69,'2014-01-04 04:02:54'),(884,66,'2014-01-04 10:25:16'),(885,66,'2014-01-04 10:30:18'),(886,66,'2014-01-04 10:36:22'),(887,66,'2014-01-04 10:42:28'),(889,63,'2014-01-04 10:59:28'),(891,66,'2014-01-04 12:13:37'),(892,66,'2014-01-04 13:26:16'),(893,66,'2014-01-04 13:32:20'),(901,66,'2014-01-05 04:14:07'),(907,66,'2014-01-05 04:37:36'),(913,66,'2014-01-05 05:47:41'),(914,66,'2014-01-05 05:52:42'),(915,66,'2014-01-05 06:09:35'),(916,62,'2014-01-05 06:44:37'),(917,62,'2014-01-05 06:44:37'),(918,62,'2014-01-05 06:44:37'),(919,62,'2014-01-05 06:44:37'),(920,62,'2014-01-05 06:44:37'),(921,62,'2014-01-05 06:44:38'),(922,62,'2014-01-05 06:49:37'),(923,62,'2014-01-05 06:55:55'),(924,62,'2014-01-05 07:19:09'),(925,62,'2014-01-05 07:25:15'),(926,62,'2014-01-05 08:39:09'),(927,66,'2014-01-05 08:44:37'),(928,62,'2014-01-05 09:44:43'),(929,62,'2014-01-05 09:49:47'),(930,62,'2014-01-05 09:54:47'),(931,62,'2014-01-05 10:05:04'),(932,62,'2014-01-05 10:10:15'),(933,62,'2014-01-05 10:19:17'),(934,62,'2014-01-05 10:28:23'),(935,62,'2014-01-05 10:37:27'),(936,62,'2014-01-05 10:50:42'),(941,66,'2014-01-05 11:48:00'),(945,62,'2014-01-05 12:25:29'),(946,62,'2014-01-05 12:33:17'),(947,66,'2014-01-05 12:59:12'),(948,66,'2014-01-05 13:04:43'),(949,62,'2014-01-06 00:38:21'),(950,62,'2014-01-06 00:44:54'),(951,62,'2014-01-06 00:55:48'),(952,62,'2014-01-06 01:16:01'),(953,66,'2014-01-06 01:20:05'),(954,62,'2014-01-06 01:21:21'),(955,66,'2014-01-06 01:26:32'),(957,66,'2014-01-06 01:39:27'),(1028,66,'2014-01-06 08:33:58'),(1031,66,'2014-01-06 08:43:37');
+SELECT * FROM  ta h WHERE   h.t = (SELECT t FROM ta h1  WHERE h1.t <= '2014-01-01 7:40:53' AND h1.u = h.u ORDER BY t DESC LIMIT 1)   LIMIT 0 , 1;
+id	u	t
+2	22	2013-12-24 06:19:37
+drop table ta;
diff --git a/mysql-test/t/memory_leak.test b/mysql-test/t/memory_leak.test
new file mode 100644
index 0000000..21f31df
--- /dev/null
+++ b/mysql-test/t/memory_leak.test
@@ -0,0 +1,12 @@
+CREATE TABLE `ta` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `u` bigint(20) NOT NULL,
+  `t` datetime NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `t` (`t`),
+  KEY `u` (`u`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+INSERT INTO `ta` VALUES (1,21,'2013-12-24 05:02:01'),(2,22,'2013-12-24 06:19:37'),(3,23,'2013-12-24 06:19:38'),(4,24,'2013-12-24 06:19:39'),(5,25,'2013-12-24 06:19:41'),(6,26,'2013-12-24 06:19:42'),(7,27,'2013-12-24 06:19:43'),(8,28,'2013-12-24 06:19:44'),(9,29,'2013-12-24 06:19:45'),(10,30,'2013-12-24 06:19:46'),(11,31,'2013-12-24 06:19:47'),(12,32,'2013-12-24 06:19:48'),(13,33,'2013-12-24 06:19:49'),(14,34,'2013-12-24 06:19:50'),(15,35,'2013-12-24 06:19:51'),(16,36,'2013-12-24 06:19:52'),(17,37,'2013-12-24 06:19:52'),(18,38,'2013-12-24 06:19:53'),(19,39,'2013-12-24 06:19:53'),(20,40,'2013-12-24 06:19:54'),(21,41,'2013-12-25 06:19:55'),(22,42,'2013-12-24 06:19:55'),(23,43,'2013-12-24 06:19:56'),(24,44,'2013-12-24 06:19:57'),(25,45,'2013-12-24 06:19:58'),(26,46,'2013-12-25 06:19:58'),(27,47,'2013-12-24 06:19:59'),(28,48,'2013-12-24 06:20:00'),(29,49,'2013-12-25 06:20:00'),(30,50,'2013-12-26 06:20:01'),(31,51,'2013-12-24 06:20:01'),(32,52,'2013-12-24 06:20:02'),(33,53,'2013-12-24 06:20:03'),(34,54,'2013-12-25 06:20:03'),(35,55,'2013-12-24 06:20:04'),(36,56,'2013-12-24 06:20:05'),(69,62,'2013-12-25 07:13:59'),(70,62,'2013-12-25 07:18:21'),(71,62,'2013-12-25 07:23:23'),(72,62,'2013-12-25 07:29:29'),(73,62,'2013-12-25 07:38:36'),(74,62,'2013-12-25 07:44:08'),(75,62,'2013-12-25 07:49:13'),(76,62,'2013-12-25 07:54:38'),(77,62,'2013-12-25 12:56:53'),(78,62,'2013-12-25 14:31:00'),(79,62,'2013-12-25 20:22:00'),(80,62,'2013-12-25 20:34:58'),(81,62,'2013-12-26 07:26:36'),(82,62,'2013-12-26 07:32:03'),(83,63,'2013-12-26 08:39:21'),(84,62,'2013-12-26 09:27:25'),(85,62,'2013-12-26 14:04:07'),(86,62,'2013-12-27 00:30:56'),(87,62,'2013-12-27 00:48:23'),(88,62,'2013-12-27 01:13:12'),(102,21,'2013-12-27 04:51:06'),(131,62,'2013-12-27 12:37:45'),(132,62,'2013-12-27 13:16:31'),(133,62,'2013-12-27 13:30:28'),(135,62,'2013-12-27 21:32:44'),(136,62,'2013-12-28 02:23:38'),(139,62,'2013-12-28 02:51:33'),(140,62,'2013-12-28 03:06:13'),(148,64,'2013-12-28 05:32:11'),(150,63,'2013-12-28 05:38:22'),(151,62,'2013-12-28 05:39:26'),(154,64,'2013-12-28 05:42:46'),(155,62,'2013-12-28 05:44:41'),(156,62,'2013-12-28 05:50:48'),(157,62,'2013-12-28 06:11:59'),(158,62,'2013-12-28 06:37:45'),(160,63,'2013-12-28 06:38:57'),(162,62,'2013-12-28 08:17:42'),(163,64,'2013-12-28 08:28:04'),(164,64,'2013-12-28 08:33:04'),(165,64,'2013-12-28 08:38:51'),(166,64,'2013-12-28 08:46:48'),(167,64,'2013-12-28 08:51:50'),(168,64,'2013-12-28 08:56:50'),(169,64,'2013-12-28 09:01:56'),(172,64,'2013-12-28 09:24:13'),(173,62,'2013-12-28 09:29:52'),(174,62,'2013-12-28 09:35:59'),(175,64,'2013-12-28 10:59:38'),(176,64,'2013-12-28 11:12:00'),(179,62,'2013-12-28 13:09:24'),(184,64,'2013-12-28 14:09:43'),(185,64,'2013-12-28 14:20:35'),(186,64,'2013-12-28 14:30:37'),(187,64,'2013-12-28 14:35:39'),(188,64,'2013-12-28 14:40:37'),(189,64,'2013-12-28 14:45:37'),(190,64,'2013-12-28 14:50:38'),(191,64,'2013-12-28 14:57:14'),(192,64,'2013-12-28 23:52:08'),(193,64,'2013-12-28 23:59:43'),(194,64,'2013-12-29 00:04:51'),(195,64,'2013-12-29 00:13:19'),(196,64,'2013-12-29 00:19:42'),(197,62,'2013-12-29 01:40:25'),(198,64,'2013-12-29 03:24:01'),(199,64,'2013-12-29 03:30:03'),(200,64,'2013-12-29 03:35:30'),(201,64,'2013-12-29 03:40:50'),(202,64,'2013-12-29 03:46:14'),(203,64,'2013-12-29 03:51:21'),(204,64,'2013-12-29 03:56:25'),(205,64,'2013-12-29 04:26:44'),(206,64,'2013-12-29 04:32:01'),(207,64,'2013-12-29 04:36:28'),(208,64,'2013-12-29 07:04:52'),(209,64,'2013-12-29 08:24:33'),(210,62,'2013-12-29 10:33:41'),(211,62,'2013-12-29 10:41:14'),(212,64,'2013-12-29 11:16:37'),(213,64,'2013-12-29 11:25:32'),(214,64,'2013-12-29 12:19:09'),(215,62,'2013-12-29 14:32:34'),(216,62,'2013-12-29 14:38:42'),(217,62,'2013-12-29 14:45:31'),(218,64,'2013-12-29 22:55:48'),(219,64,'2013-12-29 23:26:31'),(220,64,'2013-12-29 23:32:14'),(221,64,'2013-12-29 23:37:46'),(222,64,'2013-12-29 23:43:03'),(223,64,'2013-12-29 23:51:57'),(224,64,'2013-12-29 23:57:42'),(225,64,'2013-12-30 00:02:51'),(226,64,'2013-12-30 00:11:42'),(227,62,'2013-12-30 00:47:19'),(228,62,'2013-12-30 01:18:54'),(231,64,'2013-12-30 05:00:13'),(232,64,'2013-12-30 05:00:22'),(234,64,'2013-12-30 05:41:08'),(235,64,'2013-12-30 05:46:52'),(236,64,'2013-12-30 05:52:06'),(237,64,'2013-12-30 05:57:13'),(238,64,'2013-12-30 06:02:13'),(239,64,'2013-12-30 06:07:15'),(242,64,'2013-12-30 10:29:20'),(243,64,'2013-12-30 10:35:01'),(246,62,'2013-12-30 12:32:26'),(249,62,'2013-12-30 12:41:35'),(252,63,'2013-12-30 13:51:35'),(257,62,'2013-12-30 14:32:01'),(261,66,'2013-12-30 17:02:15'),(268,66,'2013-12-31 00:39:34'),(269,62,'2013-12-31 00:55:18'),(270,63,'2013-12-31 01:12:25'),(271,62,'2013-12-31 01:12:56'),(272,62,'2013-12-31 01:17:59'),(273,66,'2013-12-31 01:25:33'),(274,66,'2013-12-31 01:30:37'),(277,66,'2013-12-31 04:46:35'),(278,66,'2013-12-31 04:56:56'),(279,66,'2013-12-31 05:04:54'),(281,66,'2013-12-31 05:36:14'),(283,66,'2013-12-31 05:43:27'),(286,66,'2013-12-31 06:33:58'),(287,66,'2013-12-31 06:52:07'),(296,66,'2013-12-31 10:55:42'),(298,66,'2013-12-31 11:49:16'),(302,67,'2013-12-31 12:08:41'),(306,62,'2013-12-31 12:44:36'),(308,63,'2013-12-31 13:04:20'),(309,63,'2013-12-31 13:06:04'),(310,63,'2013-12-31 13:08:42'),(311,63,'2013-12-31 13:13:55'),(312,63,'2013-12-31 13:19:12'),(314,63,'2013-12-31 13:24:34'),(316,63,'2013-12-31 13:29:36'),(317,62,'2013-12-31 13:44:10'),(318,62,'2013-12-31 13:49:56'),(319,62,'2013-12-31 14:01:14'),(320,66,'2013-12-31 14:01:30'),(321,62,'2013-12-31 14:37:20'),(322,62,'2013-12-31 14:43:30'),(323,66,'2013-12-31 14:54:36'),(324,62,'2013-12-31 15:05:47'),(325,62,'2013-12-31 15:10:53'),(326,62,'2013-12-31 15:19:16'),(327,62,'2013-12-31 15:24:17'),(328,62,'2013-12-31 15:29:22'),(329,62,'2013-12-31 15:34:50'),(330,62,'2013-12-31 15:40:15'),(331,62,'2013-12-31 15:46:17'),(332,62,'2013-12-31 16:10:41'),(333,62,'2013-12-31 16:15:36'),(334,62,'2013-12-31 16:20:40'),(335,62,'2013-12-31 16:26:58'),(344,66,'2014-01-01 05:18:27'),(345,66,'2014-01-01 05:27:33'),(346,66,'2014-01-01 05:35:42'),(347,66,'2014-01-01 05:41:57'),(349,66,'2014-01-01 07:32:08'),(368,66,'2014-01-01 11:55:30'),(369,66,'2014-01-01 13:26:22'),(374,63,'2014-01-02 01:17:10'),(375,66,'2014-01-02 01:20:52'),(376,63,'2014-01-02 01:22:17'),(377,63,'2014-01-02 01:27:32'),(378,66,'2014-01-02 01:30:17'),(379,63,'2014-01-02 01:34:16'),(380,63,'2014-01-02 01:42:21'),(381,63,'2014-01-02 01:47:38'),(397,66,'2014-01-02 04:28:52'),(408,63,'2014-01-02 06:28:07'),(410,63,'2014-01-02 06:37:12'),(416,69,'2014-01-02 06:58:28'),(448,66,'2014-01-02 08:31:04'),(506,63,'2014-01-02 10:24:03'),(508,63,'2014-01-02 10:31:13'),(553,61,'2014-01-02 12:14:23'),(574,63,'2014-01-02 12:47:39'),(579,69,'2014-01-02 12:55:44'),(580,66,'2014-01-02 13:00:00'),(581,69,'2014-01-02 13:12:11'),(584,69,'2014-01-02 13:22:10'),(586,63,'2014-01-02 13:25:39'),(587,66,'2014-01-02 13:27:16'),(588,63,'2014-01-02 13:31:07'),(589,63,'2014-01-02 13:36:56'),(590,63,'2014-01-02 13:42:03'),(591,63,'2014-01-02 13:47:14'),(592,63,'2014-01-02 13:52:23'),(612,63,'2014-01-03 01:53:35'),(614,63,'2014-01-03 01:59:00'),(615,63,'2014-01-03 02:05:43'),(617,66,'2014-01-03 02:41:15'),(618,66,'2014-01-03 02:54:47'),(725,63,'2014-01-03 06:23:32'),(760,66,'2014-01-03 07:40:17'),(776,69,'2014-01-03 08:03:28'),(834,63,'2014-01-03 11:23:29'),(837,63,'2014-01-03 11:28:42'),(838,69,'2014-01-03 11:28:57'),(840,63,'2014-01-03 11:34:57'),(841,63,'2014-01-03 11:40:04'),(847,63,'2014-01-03 11:56:31'),(849,69,'2014-01-03 11:57:59'),(858,66,'2014-01-03 13:06:59'),(860,69,'2014-01-03 14:03:16'),(861,63,'2014-01-03 14:33:44'),(862,63,'2014-01-03 15:06:51'),(863,63,'2014-01-03 15:07:55'),(865,66,'2014-01-04 00:19:59'),(873,66,'2014-01-04 03:27:51'),(874,66,'2014-01-04 03:29:20'),(875,66,'2014-01-04 03:30:11'),(880,69,'2014-01-04 04:02:54'),(884,66,'2014-01-04 10:25:16'),(885,66,'2014-01-04 10:30:18'),(886,66,'2014-01-04 10:36:22'),(887,66,'2014-01-04 10:42:28'),(889,63,'2014-01-04 10:59:28'),(891,66,'2014-01-04 12:13:37'),(892,66,'2014-01-04 13:26:16'),(893,66,'2014-01-04 13:32:20'),(901,66,'2014-01-05 04:14:07'),(907,66,'2014-01-05 04:37:36'),(913,66,'2014-01-05 05:47:41'),(914,66,'2014-01-05 05:52:42'),(915,66,'2014-01-05 06:09:35'),(916,62,'2014-01-05 06:44:37'),(917,62,'2014-01-05 06:44:37'),(918,62,'2014-01-05 06:44:37'),(919,62,'2014-01-05 06:44:37'),(920,62,'2014-01-05 06:44:37'),(921,62,'2014-01-05 06:44:38'),(922,62,'2014-01-05 06:49:37'),(923,62,'2014-01-05 06:55:55'),(924,62,'2014-01-05 07:19:09'),(925,62,'2014-01-05 07:25:15'),(926,62,'2014-01-05 08:39:09'),(927,66,'2014-01-05 08:44:37'),(928,62,'2014-01-05 09:44:43'),(929,62,'2014-01-05 09:49:47'),(930,62,'2014-01-05 09:54:47'),(931,62,'2014-01-05 10:05:04'),(932,62,'2014-01-05 10:10:15'),(933,62,'2014-01-05 10:19:17'),(934,62,'2014-01-05 10:28:23'),(935,62,'2014-01-05 10:37:27'),(936,62,'2014-01-05 10:50:42'),(941,66,'2014-01-05 11:48:00'),(945,62,'2014-01-05 12:25:29'),(946,62,'2014-01-05 12:33:17'),(947,66,'2014-01-05 12:59:12'),(948,66,'2014-01-05 13:04:43'),(949,62,'2014-01-06 00:38:21'),(950,62,'2014-01-06 00:44:54'),(951,62,'2014-01-06 00:55:48'),(952,62,'2014-01-06 01:16:01'),(953,66,'2014-01-06 01:20:05'),(954,62,'2014-01-06 01:21:21'),(955,66,'2014-01-06 01:26:32'),(957,66,'2014-01-06 01:39:27'),(1028,66,'2014-01-06 08:33:58'),(1031,66,'2014-01-06 08:43:37');
+SELECT * FROM  ta h WHERE   h.t = (SELECT t FROM ta h1  WHERE h1.t <= '2014-01-01 7:40:53' AND h1.u = h.u ORDER BY t DESC LIMIT 1)   LIMIT 0 , 1;
+drop table ta;
diff --git a/sql/sql_select.cc b/sql/sql_select.cc
index 7a2a22d..53c3629 100644
--- a/sql/sql_select.cc
+++ b/sql/sql_select.cc
@@ -13927,6 +13927,8 @@ test_if_skip_sort_order(JOIN_TAB *tab,ORDER *order,ha_rows select_limit,
         key_map map;
         map.clear_all();       // Force the creation of quick select
         map.set_bit(best_key); // only best_key.
+        if (select->quick)
+          delete select->quick;
         select->quick= 0;
         select->test_quick_select(join->thd, map, 0,
                                   join->select_options & OPTION_FOUND_ROWS ?