mysql 报错 MySQLSyntaxErrorException

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
Sql :
	SELECT
	count( 0 ) 
FROM
	(
	SELECT
		id_ AS 'id',  
		user_id_ AS 'userId',
		user_name_ AS 'userName',
		org_id_ AS 'orgId',
		org_name_ AS 'orgName',
		clock_time_ AS 'clockTime',
		clock_type_ AS 'clockType' 
	FROM
		sys_clock_in 
	WHERE
		TO_DAYS( clock_time_ ) = TO_DAYS( NOW( ) ) 
	GROUP BY
		id_,  --不设置主键  导致查询报错  设置主键分组可以解决
		user_id_,
		org_id_ 
	HAVING
	count( user_id_ ) = 1 
	) tmp_count

原因
MySql版本的问题，在5.7.5以上的版本实现了对功能依赖的检测，MySql5.7.5以上默认启用了only_full_group_by SQL模式.
5.7.5以下默认关闭

select @@global.sql_mode

set sql_mode = “ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”