We're updating the issue view to help you get more done. 

SQLServer2005Dialect: scalar query fails with pagination

Description

Following scalar query is working:

1 Integer n = (Integer) s.createSQLQuery("select id from Product2 order by id" ).list().get(0);

By using the pagination feature, suddenly the returned records are no more scalar values but arrays.
Cause: by using pagination feature, implicitely a second result column is added.

Pullrequest will follow asap...

Environment

SQLServer2005, SQLServer2008, SQLServer2010

Status

Assignee

Lukasz Antoniak

Reporter

Guenther Demetz

Fix versions

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

4.1.4

Priority

Minor