SQLServer2005LimitHandler creates invalid query when quoted column uses keywords.

Description

When a field name contains the " from " word in a field name and you enable the pagination the result query is wrong.

For example:

Whill cause the pagination to fail because the expression created here:

is wrong. Its value is "[Created ". This means that "alias" variable is null and the query will add something like this:

Environment

None

Activity

Show:
Gail Badner
May 5, 2017, 5:49 AM

Fixed in 5.1 branch as well.

Assignee

Chris Cranford

Reporter

Andrea Palmatè

Fix versions

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure