Querydsl

JPA / Native Queries : COUNT fails in MYSQL

Bug #768345 reported by Timo Westkämper on 2011-04-21

This bug affects 1 person

Affects

Status

Importance

Assigned to

Milestone

Querydsl

Fix Released

Undecided

Unassigned

You need to log in to change this bug's status.

Target

Status	Importance
	Undecided

Assigned to

	Nobody
	Me

Remote Watch

	None, the status of the bug is updated manually.
	None, the status of the bug is updated manually.
	URL:

The information about this bug in Launchpad is automatically pulled daily from the remote bug.

Comment on this change (optional)

Email me about changes to this bug report

(?)

HibernateSQLQuery query = new HibernateSQLQuery(session, templates);
query.from(SExample.example);
Long l = query.count();

MySQL's JDBC driver seems to alway return count as BigInteger, same result with

SQLQuery squery = session.createSQLQuery("select count(*) from example")

and jdbc api

Add tags Tag help

Timo Westkämper (timo-westkamper) wrote on 2011-04-21:

Fixed in SVN trunk

Changed in querydsl:
status:	New → Fix Committed

Timo Westkämper (timo-westkamper) wrote on 2011-04-28:

Released in 2.2.0-beta4

Changed in querydsl:
status:	Fix Committed → Fix Released

This report contains Public information Edit

Everyone can see this information.

You are

Subscribing...