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

improve Handling of dynamic queries like ORDER BY RAND() #564

Open
liuliu-dev opened this issue Dec 18, 2024 · 0 comments
Open

improve Handling of dynamic queries like ORDER BY RAND() #564

liuliu-dev opened this issue Dec 18, 2024 · 0 comments
Assignees
@liuliu-dev
Labels
bug Something isn't working

Comments

@liuliu-dev
Copy link

queries using ORDER BY RAND() are returning the same results on repeated executions due to the cache-first fetch policy when we call useSqlSelect hook.

possible work around: identify dynamic queries and use network-only or no-cache for them.
@liuliu-dev liuliu-dev added the bug Something isn't working label Dec 18, 2024
@liuliu-dev liuliu-dev self-assigned this Dec 18, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@liuliu-dev liuliu-dev

Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@liuliu-dev