Import SQLite 3.10.2.

third_party/sqlite/src/test/rowid.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 126 matching lines @@
   execsql $sql
   execsql {SELECT x FROM t1 ORDER BY x}
 } {1 2 5 7 9}
 do_test rowid-2.8 {
   global x2rowid
   set sql "UPDATE t1 SET x=3 WHERE _rowid_==$x2rowid(3)"
   execsql $sql
   execsql {SELECT x FROM t1 ORDER BY x}
 } {1 3 5 7 9}
 
+if 0 {  # With the index-on-expressions enhancement, creating
+        # an index on ROWID has become possible.
 # We cannot index by ROWID
 #
 do_test rowid-2.9 {
   set v [catch {execsql {CREATE INDEX idxt1 ON t1(rowid)}} msg]
   lappend v $msg
 } {1 {table t1 has no column named rowid}}
 do_test rowid-2.10 {
   set v [catch {execsql {CREATE INDEX idxt1 ON t1(_rowid_)}} msg]
   lappend v $msg
 } {1 {table t1 has no column named _rowid_}}
 do_test rowid-2.11 {
   set v [catch {execsql {CREATE INDEX idxt1 ON t1(oid)}} msg]
   lappend v $msg
 } {1 {table t1 has no column named oid}}
 do_test rowid-2.12 {
   set v [catch {execsql {CREATE INDEX idxt1 ON t1(x, rowid)}} msg]
   lappend v $msg
 } {1 {table t1 has no column named rowid}}
+}
 
 # Columns defined in the CREATE statement override the buildin ROWID
 # column names.
 #
 do_test rowid-3.1 {
   execsql {
     CREATE TABLE t2(rowid int, x int, y int);
     INSERT INTO t2 VALUES(0,2,3);
     INSERT INTO t2 VALUES(4,5,6);
     INSERT INTO t2 VALUES(7,8,9);
@@ skipping 535 matching lines @@
 }
 db function addrow rowid_addrow_func
 do_execsql_test rowid-13.1 {
   CREATE TABLE t13(x);
   INSERT INTO t13(rowid,x) VALUES(1234,5);
   SELECT rowid, x, addrow(rowid+1000), '|' FROM t13 LIMIT 3;
   SELECT last_insert_rowid();
 } {1234 5 2234 | 2234 4990756 3234 | 3234 10458756 4234 | 4234}
 
 finish_test