Import SQLite 3.10.2.

third_party/sqlite/src/test/without_rowid5.test

 # 2013-11-26
 #
 # 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 114 matching lines @@
 } {1 {PRIMARY KEY missing on table error3}}
 
 # EVIDENCE-OF: R-48230-36247 The special behaviors associated "INTEGER
 # PRIMARY KEY" do not apply on WITHOUT ROWID tables.
 #
 do_execsql_test without_rowid5-5.1 {
   CREATE TABLE ipk(key INTEGER PRIMARY KEY, val TEXT) WITHOUT ROWID;
   INSERT INTO ipk VALUES('rival','bonus'); -- ok to insert non-integer key
   SELECT * FROM ipk;
 } {rival bonus}
-do_catchsql_test without_rowid5-5.2 {
+do_catchsql_test without_rowid5-5.2a {
+  BEGIN;
   INSERT INTO ipk VALUES(NULL,'sample'); -- no automatic generation of keys
 } {1 {NOT NULL constraint failed: ipk.key}}
+do_execsql_test without_rowid5-5.2b {
+  ROLLBACK;
+} {}
 
 # EVIDENCE-OF: R-33142-02092 AUTOINCREMENT does not work on WITHOUT
 # ROWID tables.
 #
 # EVIDENCE-OF: R-53084-07740 An error is raised if the "AUTOINCREMENT"
 # keyword is used in the CREATE TABLE statement for a WITHOUT ROWID
 # table.
 #
 do_catchsql_test without_rowid5-5.3 {
   CREATE TABLE ipk2(key INTEGER PRIMARY KEY AUTOINCREMENT, val TEXT)WITHOUT ROWID;
@@ skipping 30 matching lines @@
 do_catchsql_test without_rowid5-5.8 {
   INSERT INTO nnw VALUES(4,5,6,7,NULL)
 } {1 {NOT NULL constraint failed: nnw.e}}
 do_execsql_test without_rowid5-5.9 {
   SELECT count(*) FROM nnw;
 } {1}
 
 # EVIDENCE-OF: R-12643-30541 The incremental blob I/O mechanism does not
 # work for WITHOUT ROWID tables.
 #
-# EVIDENCE-OF: R-25760-33257 The sqlite3_blob_open() interface will fail
-# for a WITHOUT ROWID table.
+# EVIDENCE-OF: R-40134-30296 Table zTable is a WITHOUT ROWID table
 #
 do_execsql_test without_rowid5-6.1 {
   CREATE TABLE b1(a INTEGER PRIMARY KEY, b BLOB) WITHOUT ROWID;
   INSERT INTO b1 VALUES(1,x'0102030405060708090a0b0c0d0e0f');
 } {}
 do_test without_rowid5-6.2 {
   set rc [catch {db incrblob b1 b 1} msg]
   lappend rc $msg
 } {1 {cannot open table without rowid: b1}}
 
 
 finish_test