MySQL Bugs: #74705: The having results are not accurate

Bug #74705	The having results are not accurate
Submitted:	6 Nov 2014 2:53	Modified:	6 Nov 2014 3:16
Reporter:	Jorcen Michael	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S3 (Non-critical)
Version:	5.6.17-log	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	GROUP BY, having

Description:
Use the "group by having MAX in SQL (CREATE_TIME) = CREATE_TIME" may lose some packet content

How to repeat:
--------------------------------------
 --- Structure and data
--------------------------------------
/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50617
Source Host           : localhost:3306
Source Database       : new_sai

Target Server Type    : MYSQL
Target Server Version : 50617
File Encoding         : 65001

Date: 2014-11-06 10:48:17
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for T_TEST_DUMP
-- ----------------------------
DROP TABLE IF EXISTS `T_TEST_DUMP`;
CREATE TABLE `T_TEST_DUMP` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `GET_USER_ID` varchar(255) DEFAULT NULL,
  `CREATE_TIME` datetime DEFAULT NULL,
  `CONTEXT` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_TEST_DUMP
-- ----------------------------
INSERT INTO `T_TEST_DUMP` VALUES ('4', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-23 16:09:40', '41231231');
INSERT INTO `T_TEST_DUMP` VALUES ('6', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-11-04 18:21:30', 'fffffffffffff');
INSERT INTO `T_TEST_DUMP` VALUES ('10', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-23 16:08:11', '4123');
INSERT INTO `T_TEST_DUMP` VALUES ('12', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-23 16:15:04', '2222222222222222222222');
INSERT INTO `T_TEST_DUMP` VALUES ('16', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-03 12:46:02', 'xxxxxxxxxxxxxxxxxxxxxxxxxxx');
INSERT INTO `T_TEST_DUMP` VALUES ('17', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-20 19:28:34', 'sfsdfasdf');
INSERT INTO `T_TEST_DUMP` VALUES ('18', 'eb02dd3b-7d01-49c1-b74e-598d9d8cdc70', '2014-10-31 03:36:15', '亲，首次登录赠送100金币，首次修改昵称可获50金币奖励，我们将不定期提供手机、家电、宠物等超级宝贝。记得经常关注哦！');
INSERT INTO `T_TEST_DUMP` VALUES ('20', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-11-04 18:20:58', 'sdgsdfadf');
INSERT INTO `T_TEST_DUMP` VALUES ('24', 'eb02dd3b-7d01-49c1-b74e-598d9d8cdc70', '2014-10-31 03:36:19', '亲，首次登录赠送100金币，首次修改昵称可获50金币奖励，我们将不定期提供手机、家电、宠物等超级宝贝。记得经常关注哦！');
INSERT INTO `T_TEST_DUMP` VALUES ('28', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-23 16:09:20', '124123123');
INSERT INTO `T_TEST_DUMP` VALUES ('33', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-28 18:47:28', '亲，请靠近，摆正，给小票拍个清晰全身照吧！务必只涂数字，以免识别出错！如有重复、模糊、半身照、批发类、电子、手写小票或非小票类照片，我会在第一时间为你清理，不再提示咯！');
INSERT INTO `T_TEST_DUMP` VALUES ('34', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-09 10:46:16', '123123132');
INSERT INTO `T_TEST_DUMP` VALUES ('36', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-23 16:11:30', '412312312412');
INSERT INTO `T_TEST_DUMP` VALUES ('39', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-20 19:28:11', '123123132');
INSERT INTO `T_TEST_DUMP` VALUES ('40', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-03 12:49:31', '22222222222222313');
INSERT INTO `T_TEST_DUMP` VALUES ('43', 'eb02dd3b-7d01-49c1-b74e-598d9d8cdc70', '2014-10-31 03:36:37', 'fsdg2123123');
INSERT INTO `T_TEST_DUMP` VALUES ('45', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-03 12:47:05', '2222222222222222');
INSERT INTO `T_TEST_DUMP` VALUES ('50', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-03 12:43:32', 'ccccccccccccc');
INSERT INTO `T_TEST_DUMP` VALUES ('51', 'eb02dd3b-7d01-49c1-b74e-598d9d8cdc70', '2014-10-31 03:36:17', '亲，首次登录赠送100金币，首次修改昵称可获50金币奖励，我们将不定期提供手机、家电、宠物等超级宝贝。记得经常关注哦！');
INSERT INTO `T_TEST_DUMP` VALUES ('58', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-09 10:50:14', '系统提示：由于部分不符小票被清理，导致金币不足，兑换话费失败，金币已退还！');
INSERT INTO `T_TEST_DUMP` VALUES ('59', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-09 10:50:28', '123123132');
INSERT INTO `T_TEST_DUMP` VALUES ('68', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-23 16:05:41', '3123');
INSERT INTO `T_TEST_DUMP` VALUES ('69', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-08 15:05:14', '你的兑换话费订单已完成，已为手机号：13724770797   充值2元。请注意查收！');
INSERT INTO `T_TEST_DUMP` VALUES ('70', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-20 19:19:58', 'var c = \"\";var c = \"\";var c = \"\";');
INSERT INTO `T_TEST_DUMP` VALUES ('72', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-17 12:46:35', '你的兑换话费订单已完成，已为手机号：13724770797   充值2元。请注意查收！');
INSERT INTO `T_TEST_DUMP` VALUES ('73', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-03 12:47:35', '333333333333333333333');
INSERT INTO `T_TEST_DUMP` VALUES ('74', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-20 19:21:38', 'var c = \"\";var c = \"\";var c = \"\";');
INSERT INTO `T_TEST_DUMP` VALUES ('75', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-09 20:59:08', '亲，你有账单已通过人工识别，请注意查对你的历史账单哦！');
INSERT INTO `T_TEST_DUMP` VALUES ('79', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-17 12:44:18', '你的兑换话费订单已完成，已为手机号：13724770797   充值null元。请注意查收！');
INSERT INTO `T_TEST_DUMP` VALUES ('82', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-20 19:23:08', 'xxxxxxxxxxxxxxxxxxxxxxxxxxx');
INSERT INTO `T_TEST_DUMP` VALUES ('89', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-10-03 12:47:59', '33333333333213');
INSERT INTO `T_TEST_DUMP` VALUES ('96', '25353aa8-7617-49ae-b6a8-de1efb9f0f92', '2014-09-23 16:05:07', '3123');

--------------------- 
 --- DML:
---------------------
SELECT
	*
FROM
	T_TEST_DUMP
GROUP BY
	GET_USER_ID
 HAVING
 	MAX(CREATE_TIME) = CREATE_TIME

Suggested fix:
I do not know !

I was wrong

I was wrong