Update SQLServer2005LimitHandler to handle multiselects (*, table.*)

Description

PagingAndLockingTest#testNativeSql on MSSQL

If only setFirstResult is used, this query results:

With only setMaxResults, this query results:

With both, the following:

That last query fails with the following exception:

I'm not sure which 'as' it's complaining about, nor am I sure exactly how that query is working.

Environment

None

Status

Assignee

Brett Meyer

Reporter

Brett Meyer

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Priority

Major
Configure