(text/x-fossil-wiki)
The output from the following script occurs in the wrong order:
<blockquote><verbatim>
CREATE TABLE t1(x);
INSERT INTO t1 VALUES(1),(2),(3),(4),(5),(6);
CREATE INDEX t1xd ON t1(x DESC);
SELECT x FROM t1 WHERE x IN (2,4,6) ORDER BY x DESC;
</verbatim></blockquote>
The problem appears to have been introduced by check-in
[2cef8b68f0e1216] and has never been part of an official
release. The problem was detected by the SQLLogicTest
test harness during release testing. for version 3.7.16.
|