Import SQLite 3.7.6.3.

third_party/sqlite/src/test/tkt3824.test

 # 2009 April 24                                                                 
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
@@ skipping 54 matching lines @@
 } {5 9 sort}
 do_test tkt3824-2.2 {
   execsql_status {
     SELECT a FROM t2 WHERE b=2 AND c IS NULL ORDER BY b, a;
   }
 } {5 9 sort}
 do_test tkt3824-2.3 {
   lsort [execsql_status {
     SELECT a FROM t2 WHERE b=2 AND c IS NULL ORDER BY b;
   }]
-} {5 9 sort}
+} {5 9 nosort}
 
 do_test tkt3824-3.1 {
   db eval {
     CREATE TABLE t3(x,y);
     INSERT INTO t3 SELECT a, b FROM t1;
     INSERT INTO t3 VALUES(234,567);
     CREATE UNIQUE INDEX t3y ON t3(y);
     DELETE FROM t3 WHERE y IS NULL;
     SELECT * FROM t3;
   }
 } {234 567}
 
 do_test tkt3824-4.1 {
   db eval {
     CREATE TABLE t4(x,y);
     INSERT INTO t4 SELECT a, b FROM t1;
     INSERT INTO t4 VALUES(234,567);
     CREATE UNIQUE INDEX t4y ON t4(y);
     UPDATE t4 SET rowid=rowid+100 WHERE y IS NULL;
     SELECT rowid, x FROM t4 ORDER BY rowid;
   }
 } {6 234 101 1 102 9 103 5 104 123 105 -10}
 
 finish_test