Infomix limit handler support for offset

Description

The current Informix limit handler doesn't have an offset support. But Informix does.
There is a skip keyword for that. Without offset support a scrollable result will be used. I've identified the scrollable result as a performance problem in my application.

*select SKIP 10 FIRST 10 FROM table. *

I've create a custom limit handler below.
If required I'll provide a pull request on github and integrate it directly in the InformixDialect.

Environment

None

Status

Assignee

Chris Cranford

Reporter

meleagros

Fix versions

Labels

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

backportDecision

None

Components

Affects versions

Priority

Critical
Configure