Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[IDS] Use of SKIP instead of OFFSET #175

Open
oeil2lynx opened this issue Aug 8, 2024 · 1 comment
Open

[IDS] Use of SKIP instead of OFFSET #175

oeil2lynx opened this issue Aug 8, 2024 · 1 comment

Comments

@oeil2lynx
Copy link

oeil2lynx commented Aug 8, 2024

Hello,

Thanks a lot for the great job but actually, the pagination is not working on Informix.

Could you please use SKIP instead of OFFSET for Informix please ?

Here is an example of a working request :

select skip 10 * from systables limit 10

@oeil2lynx oeil2lynx changed the title [IDS] Use of SKIP and FIRST instead of OFFSET and LIMIT [IDS] Use of SKIP instead of OFFSET Aug 8, 2024
@praveen-db2
Copy link
Collaborator

As fix to issue #167 I removed offset clause, as Informix doesn't support offset clause. Will check if i can provide skip clause.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants