执行sql是

			SELECT 
				a.visit_log_id,
				a.openid,
				a.unionid,
				a.goods_def_id,
				a.create_time,
				b.nickname
			FROM
				visit_log a
			LEFT JOIN we_chat_user_info b ON (a.unionid = b.unionid or a.openid = b.openid)
			WHERE
				datediff(NOW(), a.create_time) <= 14
			AND a.goods_def_id = 1
			group by a.unionid
			ORDER BY
				a.create_time DESC

navicate 没有问题的。

报错内容
Exception in thread "main" java.lang.StringIndexOutOfBoundsException: String index out of range: 654
at java.lang.String.substring(String.java:1963)
at org.beetl.sql.core.kit.PageKit.getCountSql(PageKit.java:85)
at com.manli.api.util.AliYunSmsUtil.main(AliYunSmsUtil.java:119)

执行的sql是这种的。 就报数组下标越界
SELECT
*
FROM
(
SELECT
*
FROM
(
SELECT DISTINCT
a.visit_log_id,
a.openid,
a.unionid,
a.goods_def_id,
a.create_time,
b.nickname
FROM
visit_log a
LEFT JOIN we_chat_user_info b ON a.unionid = b.unionid
WHERE
datediff(NOW(), a.create_time) <= 14
AND a.goods_def_id = 1
ORDER BY
a.create_time DESC
) main
GROUP BY
main.unionid
) c