QoQ Problem in Railo 4.2

error.txt

Query 
Execution Time: 0 ms 
Record Count: 1 
Cached: No 
Lazy: No 
 	resourceId	resourcetitle	publishdate	S	RANK	resourcedetailspath
1	1942	HUD's Implementation Plan for the National HIV/AIDS Strategy	2011-02-01	<b>...</b> Journal of Epidemiology and Community Health, 55(7):515-‐<br> 520. 4 Steffen, BL, <b>Fudge</b>, K., Martin, M., Souza, MT,<br> Vandenbroucke, DA, and Yao, YGD (2011). <b>...</b>	1	https://www.hudexchange.info/resource/1942/huds-implementation-plan-for-the-national-hiv-aids-strategy
Railo 4.2.1.000 Error (database)
Message	Encountered "INTEGER" at line 2, column 36.
Was expecting one of:
"," ...
")" ...
"." ...
"+" ...
"-" ...
"*" ...
"||" ...
"/" ...
"**" ...
"(" ...
SQL	
SELECT
cast( "resourceid" as INTEGER ) as "resourceid"
FROM
qry
GROUP BY
cast( "resourceid" as INTEGER )
Stacktrace	The Error Occurred in
/test/test.cfm: line 12 
10: GROUP BY
11: cast( "resourceid" as INTEGER )
12: </cfquery>

Java Stacktrace	Encountered "INTEGER" at line 2, column 36.
 Was expecting one of:
  "," ...
  ")" ...
  "." ...
  "+" ...
  "-" ...
  "*" ...
  "||" ...
  "/" ...
  "**" ...
  "(" ...
  
 	at railo.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:306):306
 	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:12):12
 	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 7:26:33 PM UTC

hsqldb_direct_test.sql

drop table if exists test;
create table test(resourceid integer);
insert into test (resourceid) values(1942);
select * from test;
select cast(resourceid as integer) as resourceid from test;
select cast(resourceid as integer) as resourceid from test group by cast(resourceid as integer);

test.cfm

<cffile action="read" variable="wddx" file="wddx" />
<cfwddx action="wddx2cfml" input="#wddx#" output="qry" />
<cfdump var="#qry#" />

<cfquery name="local.qryResultsMetaObject" dbtype="query">
	SELECT
		cast( "resourceid" as INTEGER ) as "resourceid"
	FROM
		qry
	GROUP BY
		cast( "resourceid" as INTEGER )
</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>