Hibernate Community • View topic - Constant expresion in select count phrase

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Constant expresion in select count phrase

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

soltys

Post subject: Constant expresion in select count phrase

Posted: Thu Jan 29, 2009 6:27 am

Newbie

Joined: Tue Jan 20, 2009 3:25 am
Posts: 6
Location: Poland

I'm using Hibernate 3.2.5.GA, but also tried 3.3.1.GA (with Oracle database and JDBC ver. 11.1.0.6.0) and found that using constant expression in select count phrase is illegal.
Is there a chance that I missed something. If no, is there a chance that next versions will?

From DB point of view using

Code:

select count(1) from ...

is much more efficient than

Code:

select count(field) from ...

not even mentioning the star version.

Regards,
Maciej

Top

soltys

Post subject:

Posted: Thu Feb 05, 2009 9:47 am