[CAY-1131] Add LIMIT / OFFSET clause generation method to SelectTranslator lifecycle

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0M5
• Assignee: Andrus Adamchik
• Reporter: Andrus Adamchik
• Created: 02/Nov/08 20:56
• Updated: 09/Nov/08 01:18
• Resolved: 02/Nov/08 21:01

Description

Superclass SelectTranslator does not support LIMIT / OFFSET clauses. All this functionality is done via adapter provided subclasses. We need to have a common method in the superclass (with noop default implementation, as there all DB's are different in LIMIT syntax, and most don't support it). This is partially motivated by CAY-1130 that will require support of optional limit clause turning on and off depending on other query parameters.