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.

Sign up for GitHub

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

Jump to bottom

Possible issue with OFFSET / LIMIT query #53

Open
1beb opened this issue Jun 14, 2022 · 2 comments
Open

Possible issue with OFFSET / LIMIT query #53

1beb opened this issue Jun 14, 2022 · 2 comments

Comments

@1beb
Copy link
Contributor

1beb commented Jun 14, 2022 •
edited
Loading

https://stackoverflow.com/a/39680636

Right now, we use a really basic OFFSET and LIMIT query. I have run into a few situations where the results come out differently using PostgreSQL.

Need to add ORDER BY X where X is a column in the table, to be certain that we are getting consistent results otherwise the window can change.

@cboettig I'm thinking we add this as a required argument in ark. What do you think?
@1beb
Copy link
Contributor Author

1beb commented Jan 12, 2023

Bump @cboettig

@cboettig
Copy link
Member

👍 thanks sounds good to me

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@cboettig @1beb