Index: third_party/sqlite/src/test/without_rowid3.test |
diff --git a/third_party/sqlite/src/test/without_rowid3.test b/third_party/sqlite/src/test/without_rowid3.test |
index a0dc76d3f99221f075fd043fb12694d9b3b09ff0..2af43a9191594c004865fb64958fd6ca5cfe3b5f 100644 |
--- a/third_party/sqlite/src/test/without_rowid3.test |
+++ b/third_party/sqlite/src/test/without_rowid3.test |
@@ -2081,4 +2081,20 @@ do_test without_rowid3-ce7c13.1.6 { |
} |
} {1 {FOREIGN KEY constraint failed}} |
+# Confirm that changes() works on WITHOUT ROWID tables that use the |
+# xfer optimization. |
+# |
+db close |
+sqlite3 db :memory: |
+do_execsql_test without_rowid3-30.1 { |
+ CREATE TABLE t1(a,b,PRIMARY KEY(a,b)) WITHOUT ROWID; |
+ CREATE TABLE t2(a,b,PRIMARY KEY(a,b)) WITHOUT ROWID; |
+ INSERT INTO t1 VALUES(1,2),(3,4),(5,6); |
+ SELECT changes(); |
+} {3} |
+do_execsql_test without_rowid3-30.2 { |
+ INSERT INTO t2 SELECT * FROM t1; |
+ SELECT changes(); |
+} {3} |
+ |
finish_test |