Query of Query Runs in ACF9 but Not Railo 4.2

error.txt

Railo 4.2.1.000 Error (database)
Message	
Detail	Not in aggregate function or group by clause: org.hsqldb.Expression@62256a2a in statement [
SELECT
CAST(resourceid as INTEGER) as resourceid
,CAST(rank as INTEGER) as rank
,CAST(s as VARCHAR) as s
,CAST(resourcetitle as VARCHAR) as resourcetitle
,CAST(publishdate as VARCHAR) as publishdate
,CAST(resourcedetailspath as VARCHAR) as resourcedetailspath
FROM
qry
WHERE 
resourceid IS NOT NULL
GROUP BY
resourceid
ORDER BY
rank asc
]
SQL	
SELECT
CAST(resourceid as INTEGER) as resourceid
,CAST(rank as INTEGER) as rank
,CAST(s as VARCHAR) as s
,CAST(resourcetitle as VARCHAR) as resourcetitle
,CAST(publishdate as VARCHAR) as publishdate
,CAST(resourcedetailspath as VARCHAR) as resourcedetailspath
FROM
qry
WHERE 
resourceid IS NOT NULL
GROUP BY
resourceid
ORDER BY
rank asc
DatabaseName	HSQL Database Engine
DatabaseVersion	1.8.0
DriverName	HSQL Database Engine Driver
DriverVersion	1.8.0
Datasource	_queryofquerydb
Stacktrace	The Error Occurred in
/test/test.cfm: line 19 
17: ORDER BY
18: rank asc
19: </cfquery>

Java Stacktrace	
 	at org.hsqldb.jdbc.Util.sqlException(Unknown Source):-1
 	at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source):-1
 	at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source):-1
 	at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:19):19
 	at railo.runtime.db.driver.state.StateStatement.execute(StateStatement.java:25):25
 	at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:214):214
 	at railo.runtime.type.QueryImpl.(QueryImpl.java:224):224
 	at railo.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:349):349
 	at railo.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:313):313
 	at railo.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:302):302
 	at railo.runtime.tag.Query.executeQoQ(Query.java:678):678
 	at railo.runtime.tag.Query.doEndTag(Query.java:502):502
 	at test.test_cfm$cf.call(/test/test.cfm:19):19
 	at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:913):913
 	at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:865):865
 	at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:206):206
 	at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:18):18
 	at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2218):2218
 	at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2185):2185
 	at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:332):332
 	at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727):727
 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303):303
 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208
 	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52
 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241
 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208
 	at org.apache.catalina.filters.RemoteIpFilter.doFilter(RemoteIpFilter.java:834):834
 	at org.apache.catalina.filters.RemoteIpFilter.doFilter(RemoteIpFilter.java:870):870
 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241
 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208
 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220):220
 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122):122
 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501):501
 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171):171
 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102):102
 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116):116
 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408):408
 	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040):1040
 	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607):607
 	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314):314
 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145):1145
 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615):615
 	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61
 	at java.lang.Thread.run(Thread.java:745):745
 
Timestamp	9/23/14 5:18:58 PM UTC

test.cfm

<cffile action="read" variable="wddx" file="wddx" />
<cfwddx action="wddx2cfml" input="#wddx#" output="qry" />
<cfquery name="local.qryResultsMetaObject" dbtype="query">
	SELECT
		CAST(resourceid as INTEGER) as resourceid
	   ,CAST(rank as INTEGER) as rank
	   ,CAST(s as VARCHAR) as s
	   ,CAST(resourcetitle as VARCHAR) as resourcetitle
	   ,CAST(publishdate as VARCHAR) as publishdate
	   ,CAST(resourcedetailspath as VARCHAR) as resourcedetailspath
	FROM
		qry
	WHERE 
		resourceid IS NOT NULL
	GROUP BY
		resourceid
	ORDER BY
		rank asc
</cfquery>

wddx

<wddxPacket version='1.0'><header/><data><recordset rowCount='1' fieldNames='resourceId,resourcetitle,publishdate,S,RANK,resourcedetailspath' type='coldfusion.sql.QueryTable'><field name='resourceId'><string>1942</string></field><field name='resourcetitle'><string>HUD's Implementation Plan for the National HIV/AIDS Strategy</string></field><field name='publishdate'><string>2011-02-01</string></field><field name='S'><string>&lt;b&gt;...&lt;/b&gt; Journal of Epidemiology and Community Health, 55(7):515-‐&lt;br&gt; 520. 4 Steffen, BL, &lt;b&gt;Fudge&lt;/b&gt;, K., Martin, M., Souza, MT,&lt;br&gt; Vandenbroucke, DA, and Yao, YGD (2011). &lt;b&gt;...&lt;/b&gt;  </string></field><field name='RANK'><string>1</string></field><field name='resourcedetailspath'><string>https://www.hudexchange.info/resource/1942/huds-implementation-plan-for-the-national-hiv-aids-strategy</string></field></recordset></data></wddxPacket>