Bug: testGetPixelsCount failing

[wmoore]

wjm:OmeroPy will$ python test/integration/iquery.py
E
======================================================================
ERROR: testGetPixelsCount (__main__.TestQuery)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test/integration/iquery.py", line 28, in testGetPixelsCount
    """, None, {"omero.group":str(group.id.val)})
  File "/Users/will/Desktop/OMERO/components/tools/OmeroPy/build/lib/omero_api_IQuery_ice.py", line 150, in projection
    return _M_omero.api.IQuery._op_projection.invoke(self, ((query, params), _ctx))
ValidationException: exception ::omero::ValidationException
{
    serverStackTrace = ome.conditions.ValidationException: could not execute query; SQL [select pixelstype1_.value as col_0_0_, sum(pixels0_.sizeX*pixels0_.sizeY*pixels0_.sizeZ*pixels0_.sizeT*pixels0_.sizeC) as col_1_0_ from pixels pixels0_, pixelstype pixelstype1_ where (

  ( pixels0_.group_id = ? AND 
     ( 1 = ? OR 
       1 = ? OR 
       pixels0_.owner_id = ?
     )
  ) OR
  pixels0_.group_id = 1 OR 
 1 = ?
) and pixels0_.pixelsType=pixelstype1_.id group by pixelstype1_.value]; nested exception is org.hibernate.exception.DataException: could not execute query
	at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:642)
	at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
	at ome.logic.QueryImpl.projection(QueryImpl.java:433)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:592)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at ome.security.basic.EventHandler.invoke(EventHandler.java:150)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at ome.tools.hibernate.ProxyCleanupFilter$Interceptor.invoke(ProxyCleanupFilter.java:231)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at ome.services.util.ServiceHandler.invoke(ServiceHandler.java:111)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy75.projection(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:592)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at ome.security.basic.BasicSecurityWiring.invoke(BasicSecurityWiring.java:83)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at ome.services.blitz.fire.AopContextInitializer.invoke(AopContextInitializer.java:43)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy75.projection(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:592)
	at ome.services.blitz.util.IceMethodInvoker.invoke(IceMethodInvoker.java:179)
	at ome.services.throttling.Callback.run(Callback.java:56)
	at ome.services.throttling.InThreadThrottlingStrategy.callInvokerWithMappedArgs(InThreadThrottlingStrategy.java:70)
	at ome.services.blitz.impl.AbstractAmdServant.callInvokerOnMappedArgs(AbstractAmdServant.java:145)
	at ome.services.blitz.impl.QueryI.projection_async(QueryI.java:124)
	at omero.api._IQueryTie.projection_async(_IQueryTie.java:134)
	at omero.api._IQueryDisp.___projection(_IQueryDisp.java:416)
	at omero.api._IQueryDisp.__dispatch(_IQueryDisp.java:536)
	at IceInternal.Incoming.invoke(Incoming.java:159)
	at Ice.ConnectionI.invokeAll(ConnectionI.java:2037)
	at Ice.ConnectionI.message(ConnectionI.java:972)
	at IceInternal.ThreadPool.run(ThreadPool.java:577)
	at IceInternal.ThreadPool.access$100(ThreadPool.java:12)
	at IceInternal.ThreadPool$EventHandlerThread.run(ThreadPool.java:971)

    serverExceptionClass = ome.conditions.ValidationException
    message = could not execute query; SQL [select pixelstype1_.value as col_0_0_, sum(pixels0_.sizeX*pixels0_.sizeY*pixels0_.sizeZ*pixels0_.sizeT*pixels0_.sizeC) as col_1_0_ from pixels pixels0_, pixelstype pixelstype1_ where (

  ( pixels0_.group_id = ? AND 
     ( 1 = ? OR 
       1 = ? OR 
       pixels0_.owner_id = ?
     )
  ) OR
  pixels0_.group_id = 1 OR 
 1 = ?
) and pixels0_.pixelsType=pixelstype1_.id group by pixelstype1_.value]; nested exception is org.hibernate.exception.DataException: could not execute query
}

----------------------------------------------------------------------
Ran 1 test in 6.435s

FAILED (errors=1)
wjm:OmeroPy will$ 

[wmoore]

Blitz log from running test above

[jmoore <josh@…>]

(In [a4061b103b8258d3b7609e0f2ab1f4b13e554afc/ome.git] on branch develop) Adding cast to sum of pixel sizes (Fix #5738)