SQLite
View Ticket
Not logged in
Ticket UUID: 65bdeb9739605cc22966f49208452996ff29a640
Title: "ORDER BY random()" gets optimized out
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2014-02-26 02:26:29
Version Found In: 3.8.3.1
User Comments:
drh added on 2014-02-26 00:48:49: (text/x-fossil-wiki)
In the following query, the ORDER BY clause is ignored:

<blockquote><verbatim>
CREATE TABLE t1(a INTEGER PRIMARY KEY, b DEFAULT 1);
INSERT INTO t1(a) VALUES(1),(2),(3),(4),(5);
CREATE TABLE t2(x INTEGER PRIMARY KEY);
INSERT INTO t2 VALUES(1);
SELECT * FROM t1, t2 WHERE x=1 ORDER BY random();
</verbatim></blockquote>

This problem appears to have been introduced on 2013-06-21 (version 3.8.0)
with the introduction of the NGQP.