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

Bug: ORDER BY RANDOM ON SQLite3 #3768

Closed
wiedhodho opened this issue Oct 13, 2020 · 0 comments · Fixed by #3769
Closed

Bug: ORDER BY RANDOM ON SQLite3 #3768

wiedhodho opened this issue Oct 13, 2020 · 0 comments · Fixed by #3769
Labels
bug Verified issues on the current code behavior or pull requests that will fix them

Comments

@wiedhodho
Copy link

wiedhodho commented Oct 13, 2020 •
edited
Loading

When using $builder->orderBy('','RANDOM') on database SQLite3, the query builders produce

SELECT * FROM TABLE ORDER BY RAND();

It must be,

SELECT * FROM TABLE ORDER BY RANDOM();
@wiedhodho wiedhodho added the bug Verified issues on the current code behavior or pull requests that will fix them label Oct 13, 2020
@michalsn michalsn mentioned this issue Oct 13, 2020
Merged
3 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Verified issues on the current code behavior or pull requests that will fix them
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Fix orderBy() random for SQLite3 michalsn/CodeIgniter4
1 participant
@wiedhodho