Limit Handler for SQL server doesn't work with CTE queries with strings literals

Description

The pagination using CTE queries which has string literals doesn't work because of issue in SQLServer2005LimitHandler in the method advanceOverCTEInnerQuery, specifically in this line of code in which doesn't recognize the end of string literal.

Example of CTE query with string literals (see 'GASTOS VIAJE' and 'SUMINISTROS' string literals):

Environment

None

Assignee

Jason Jijón

Reporter

Jason Jijón

Fix versions

Labels

backPortable

Backport?

Suitable for new contributors

None

Requires Release Note

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure