Hibernate version:
1.0.3.0

Code between sessionFactory.openSession() and session.close():

String query =
"SELECT sum(Amount) , count(*) "+
"From Transaction t ";

IQuery q = Persistor.getSession().CreateQuery(query);
q.SetParameter("Batch",b);
IEnumerable results = q.Enumerable();
foreach(object[] o in results)
{
theSet.Add(o);
}

Full stack trace of any exception that occurs:
au.com.compassion.eftrerun.readWriteTest.getTransactionsTest : System.InvalidCastException : Specified cast is not valid.


Ok so the problem is when i issue a Query with multiple scalar Queries i get only one result returned in the IEnumerable object (the documentation says it should return an object[], this seems to be incorect) a Bug or is my code is wrong.

Thanks for your help

And what is the type of the result, then?

a single System.Int32 has been returned, it has the first Agregate function value. (acording to the NHibernate.Impl.EnumerableImpl object)

however this is also incoreect as it should be returning a float or Decimal type. as the sum is summing a money SQL type

the statement that hits the MSSQL server is


When i run this in Query analyser it returns corectly.

1325872.5000 22769


thanks for your help

interestingly i changed the Query to


and everything worked fine......

The query is exactly the same in SQL Profiler.

anyway problem solved