Hello, we are registered user of Hxtt and we have one application that access SQL Server, Oracle and Postgres, and now I'm in the process to use Hxtt too, but one query os the application is the following:
SELECT Sales FROM Sale GROUP BY Sales ORDER BY sum(Quantity)
When whe run it, we receive the following error:
Exception in thread "main" java.sql.SQLException: The aggregate function SUM(Quantity) should be in select-list.
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.df.a(Unknown Source)
at com.hxtt.sql.df.a(Unknown Source)
at com.hxtt.sql.df.a(Unknown Source)
at com.hxtt.sql.df.a(Unknown Source)
at com.hxtt.sql.bn.a(Unknown Source)
at com.hxtt.sql.bn.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.dh.executeQuery(Unknown Source)
If i put the "Quantity" field in the selection list the query works.
But, can this behavior changed ? In the other databases that we access the the order criteria must not be in the selection list, and, for me specific case, is very hard tho change the application.
Thanks for your time.
|
|
Supported. Please download the latest package.
|
The update worked like a charm
Thanks for your always quick responses.
|
Main
webmaster@hxtt.com