Hibernate: select distinct A.ID AS DOCID,D.GROUPNAME AS GROUPNAME,D.ID AS GROUPID,D.GROUPIMG AS GROUPIMG,A.DOMTYPE AS DOMTYPE,A.TITLE AS TITLE,A.DOCDESCRIBE AS DOCDESCRIBE,A.AUTHOR AS AUTHOR,A.PUBTIME AS PUBTIME,A.TAGKEY AS TAGKEY ,A.IMGID AS IMGID,B.VISITNUM AS VISITNUM,B.PRAISEYES AS PRAISEYES,B.PRAISENO AS PRAISENO,B.HOTNUM AS HOTNUM,B.EVALUATE AS EVALUATE,B.ANSWERINGNUM AS ANSWERINGNUM, E.ID AS USERID, E.NAME AS USERNAME, E.IMGID AS USERIMGID FROM FARM_DOC a LEFT JOIN farm_docruninfo b on a.RUNINFOID=b.ID left join FARM_RF_DOCTYPE f on a.id=f.docid left join FARM_DOCTYPE g on g.id=f.typeid left join FARM_DOCGROUP d on a.DOCGROUPID=d.ID left join FARM_DOCGROUP_USER c on c.GROUPID=d.ID and c.USERID='none' LEFT JOIN ALONE_AUTH_USER e ON e.ID = a.CUSER WHERE 1=1 AND A.STATE = '1' AND A.DOCGROUPID = '4028b8815ce8a673015ce8af49680009' AND DOMTYPE != '4' and g.READPOP='0' and a.DOCGROUPID is not null AND ( a.READPOP = '1' OR ( a.READPOP = '2' AND d.JOINCHECK = '0' ) OR ( a.READPOP = '2' AND d.JOINCHECK = '1' AND c.PSTATE = '1' )) ORDER BY a.etime desc limit ?
ERROR: Expression #1:增加开放和关闭用户注册功能 of ORDER BY clause is not in SELECT list, references column 'wcp2op.a.ETIME' which is not in SELECT list; this is incompatible with DISTINCT(org.hibernate.engine.jdbc.spi.SqlExceptionHelper#logExceptions ) 2017年06月27日18点08分
ERROR: java.sql.SQLException: java.lang.RuntimeException: java.sql.SQLException: java.lang.RuntimeException: org.hibernate.exception.GenericJDBCException: could not extract ResultSet(com.farm.doc.server.impl.FarmDocgroupManagerImpl#getNewGroupDoc ) 2017年06月27日18点08分
DEBUG: web-simple/docgroup/groupSite(com.farm.core.page.ViewMode#returnModelAndView ) 2017年06月27日18点08分