Import SQLite 3.10.2.

third_party/sqlite/src/test/select8.test

 # 2001 September 15
 #
 # 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 14 matching lines @@
   INSERT INTO songs VALUES(3,'two',3);
   INSERT INTO songs VALUES(4,'three',5);
   INSERT INTO songs VALUES(5,'one',7);
   INSERT INTO songs VALUES(6,'two',11);
 }
 set result [execsql {
   SELECT DISTINCT artist,sum(timesplayed) AS total      
   FROM songs      
   GROUP BY LOWER(artist)      
 }]
-puts result=$result
 do_test select8-1.1 {
   execsql {
     SELECT DISTINCT artist,sum(timesplayed) AS total      
     FROM songs      
     GROUP BY LOWER(artist)      
     LIMIT 1 OFFSET 1
   }
 } [lrange $result 2 3]
 do_test select8-1.2 {
   execsql {
     SELECT DISTINCT artist,sum(timesplayed) AS total      
     FROM songs      
     GROUP BY LOWER(artist)      
     LIMIT 2 OFFSET 1
   }
 } [lrange $result 2 5]
 do_test select8-1.3 {
   execsql {
     SELECT DISTINCT artist,sum(timesplayed) AS total      
     FROM songs      
     GROUP BY LOWER(artist)      
     LIMIT -1 OFFSET 2
   }
 } [lrange $result 4 end]
 
 
 finish_test