/ Check-in [95d33812]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update test file "resetdb.test" so that it works with the "prepare" permutation.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 95d338124be2e0e18f17354b28f4320336202f1a4ec1177df753b2800e954bfb
User & Date: dan 2019-02-05 08:55:43
Context
2019-02-05
12:16
Keep the temp_store_directory and data_store_directory pragmas even when compiling with SQLITE_OMIT_DEPRECATED. check-in: 93386a7c user: drh tags: trunk
08:55
Update test file "resetdb.test" so that it works with the "prepare" permutation. check-in: 95d33812 user: dan tags: trunk
2019-02-04
21:10
Early detection of implausibly sized records to avoid unnecessary large memory allocations. check-in: 2c8769c6 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to test/resetdb.test.

79
80
81
82
83
84
85




86
87
88
89
90
91
92

do_test 210 {
  # Reset the database file using SQLITE_DBCONFIG_RESET_DATABASE
  sqlite3_db_config db RESET_DB 1
  db eval VACUUM
  sqlite3_db_config db RESET_DB 0





  # Verify that the reset took, even on the separate database connection
  catchsql {
     PRAGMA page_count;
     PRAGMA page_size;
     PRAGMA quick_check;
     PRAGMA journal_mode;
  } db2







>
>
>
>







79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96

do_test 210 {
  # Reset the database file using SQLITE_DBCONFIG_RESET_DATABASE
  sqlite3_db_config db RESET_DB 1
  db eval VACUUM
  sqlite3_db_config db RESET_DB 0

  # If using sqlite3_prepare() instead of _v2() or _v3(), the block 
  # below raises an SQLITE_SCHEMA error. The following fixes this.
  if {[permutation]=="prepare"} { catchsql "SELECT * FROM sqlite_master" db2 }

  # Verify that the reset took, even on the separate database connection
  catchsql {
     PRAGMA page_count;
     PRAGMA page_size;
     PRAGMA quick_check;
     PRAGMA journal_mode;
  } db2