+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forumdisplay.php?fid=6)
+--- Forum: Issues (https://forum.codeigniter.com/forumdisplay.php?fid=19)
+--- Thread: ORDER BY ON SQLite3 (/showthread.php?tid=77730)
ORDER BY ON SQLite3 - wiedhodho - 10-12-2020
When using database SQLite3 and using order by, the query builders produce
SELECT * FROM TABLE ORDER BY RAND();
It must be,
SELECT * FROM TABLE ORDER BY RANDOM();
RE: ORDER BY ON SQLite3 - InsiteFX - 10-13-2020
You need to file a bug report in Issues here:
Issues - for bug reporting