Import SQLite 3.7.6.3.

third_party/sqlite/src/test/pagesize.test

 # 2004 September 2
 #
 # 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 170 matching lines @@
   do_test pagesize-2.$PGSZ.15 {
     execsql {DELETE FROM t1 WHERE rowid%5!=0}
     ifcapable {vacuum} {execsql VACUUM}
     execsql {SELECT count(*) FROM t1}
   } 38
   do_test pagesize-2.$PGSZ.16 {
     execsql {DROP TABLE t1}
     ifcapable {vacuum} {execsql VACUUM}
   } {}
   integrity_check pagesize-2.$PGSZ.17
+
+  db close
+  file delete -force test.db
+  sqlite3 db test.db
+  do_test pagesize-2.$PGSZ.30 {
+    execsql "
+      CREATE TABLE t1(x);
+      PRAGMA temp.page_size=$PGSZ;
+      CREATE TEMP TABLE t2(y);
+      PRAGMA main.page_size;
+      PRAGMA temp.page_size;
+    "
+  } [list 1024 $PGSZ]
+
+  db close
+  file delete -force test.db
+  sqlite3 db test.db
+  do_test pagesize-2.$PGSZ.40 {
+    execsql "
+      PRAGMA page_size=$PGSZ;
+      CREATE TABLE t1(x);
+      CREATE TEMP TABLE t2(y);
+      PRAGMA main.page_size;
+      PRAGMA temp.page_size;
+    "
+  } [list $PGSZ $PGSZ]
 }
 
 finish_test