[IGNITE-1259] OFFSET clause does not work correctly in SQL queries

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Assignee: Sergei Vladykin
• Reporter: Sergei Vladykin
• Created: 17/Aug/15 15:54
• Updated: 17/Aug/15 18:26
• Resolved: 17/Aug/15 18:26

Description

Query generator from

SELECT ... LIMIT 10 OFFSET 10

generates map query incorrectly

SELECT ... LIMIT 10

while it must be

SELECT ... LIMIT 10 + 10

Reduce query is correct:

SELECT ... LIMIT 10 OFFSET 10