nutzdao mysql_nutz dao fetch 在MySQL5.6报错？

代码如下

UserOpenId userOpenId = ApplicationContext.ioc.get(UserOpenIdManager).fetch(Cnd.where('openId', '=', ticket))

本地MySQL 5.5没啥问题，上到腾讯云MySQL5.6，运行报错如下， 看着像是SQL语句转换出问题了？

org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT * FROM (SELECT ROW_NUMBER() OVER() AS ROWNUM, T.* FROM ( SELECT * FROM user_open_id WHERE open_id='oVamkuDlM0ZImtY1RAGXmIrC4rm0') T) AS A WHERE ROWNUM BETWEEN 1 AND 1 '

PreparedStatement:

'SELECT * FROM (SELECT ROW_NUMBER() OVER() AS ROWNUM, T.* FROM ( SELECT * FROM user_open_id WHERE open_id=?) T) AS A WHERE ROWNUM BETWEEN 1 AND 1 '

CaseMessage=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '() AS ROWNUM, T.* FROM ( SELECT * FROM user_open_id WHERE open_id='oVamkuDlM0ZI' at line 1

at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)

at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)

at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)

at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158)

at org.nutz.dao.impl.sql.run.NutDaoR