Zend Framework

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: None
• Fix Version/s: 1.9.2
• Component/s: Zend_Db
• Labels:

  None

MsSql does not support OFFSET parameter for LIMIT.
Zend_Db_Adapter_Pdo_Mssql implements a workaround by using the original query as a subquery, so it prepends and appends the required code to the original query.
Zend_Db_Adapter_Pdo_Mssql->limit method not takes care of the DISTINCT clause, so generates
... (SELECT TOP xx DISTINCT ... like query, but the correct syntax would be ...( SELECT DISTINCT TOP xx ...

Possible correction use '/^SELECT\s+(DISTINCT\s+)?/i' regular expression insead of '/^SELECT\s/i'

• Assignee:

  Ralph Schindler

  Reporter:

  Zsolt Gyöngyösi

• Created:

  11/Sep/08 8:26 AM

  Updated:

  24/Aug/09 10:50 AM

  Resolved:

  24/Aug/09 10:50 AM