/ Check-in [4921e5ba]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Do not run test file "resetdb.test" as part of permutation "inmemory_journal".
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 4921e5bae4c12c3413cc0b2e58766cf2ac117ad95f92fcd1c2457db6cfabb054
User & Date: dan 2018-05-29 13:25:14
Context
2018-05-29
14:06
Fix some test script issues caused by recent EXPLAIN QUERY PLAN enhancements. check-in: f808e228 user: dan tags: trunk
13:25
Do not run test file "resetdb.test" as part of permutation "inmemory_journal". check-in: 4921e5ba user: dan tags: trunk
2018-05-28
18:29
Do not require a statement journal in cases where REPLACE conflict handling is used to insert a single row, so long as the REPLACE operation cannot fire any triggers or foreign key actions. check-in: 469a62ca user: dan tags: trunk
Changes
Hide Diffs Unified Diffs Show Whitespace Changes Patch

Changes to test/resetdb.test.

15
16
17
18
19
20
21










22
23
24
25
26
27
28
source $testdir/tester.tcl
set testprefix resetdb

ifcapable !vtab||!compound {
  finish_test
  return
}











# Create a sample database
do_execsql_test 100 {
  PRAGMA page_size=4096;
  CREATE TABLE t1(a,b);
  WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<20)
    INSERT INTO t1(a,b) SELECT x, randomblob(300) FROM c;







>
>
>
>
>
>
>
>
>
>







15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
source $testdir/tester.tcl
set testprefix resetdb

ifcapable !vtab||!compound {
  finish_test
  return
}

# In the "inmemory_journal" permutation, each new connection executes 
# "PRAGMA journal_mode = memory". This fails with SQLITE_BUSY if attempted
# on a wal mode database with existing connections. For this and a few
# other reasons, this test is not run as part of "inmemory_journal".
#
if {[permutation]=="inmemory_journal"} {
  finish_test
  return
}

# Create a sample database
do_execsql_test 100 {
  PRAGMA page_size=4096;
  CREATE TABLE t1(a,b);
  WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<20)
    INSERT INTO t1(a,b) SELECT x, randomblob(300) FROM c;