Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix autoinc.test and resetdb.test so that they work with all permutations. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
89f56d6b0a6847b042a1556cdf79c598 |
| User & Date: | dan 2018-05-29 16:37:12 |
Context
|
2018-05-29
| ||
| 19:12 | Increase the number of database handles opened by test script oserror.test to provoke an "out of file-descriptors" error to 20000 (from 2000). check-in: 3b00f734 user: dan tags: trunk | |
| 16:37 | Fix autoinc.test and resetdb.test so that they work with all permutations. check-in: 89f56d6b user: dan tags: trunk | |
| 15:18 | Add a comment to justify a goto statement. No code changes. check-in: f141d806 user: drh tags: trunk | |
Changes
Changes to test/autoinc.test.
20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
# If the library is not compiled with autoincrement support then
# skip all tests in this file.
#
ifcapable {!autoinc} {
finish_test
return
}
sqlite3_db_config_lookaside db 0 0 0
# The database is initially empty.
#
do_test autoinc-1.1 {
execsql {
|
> > > > > |
20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 |
# If the library is not compiled with autoincrement support then
# skip all tests in this file.
#
ifcapable {!autoinc} {
finish_test
return
}
if {[permutation]=="inmemory_journal"} {
finish_test
return
}
sqlite3_db_config_lookaside db 0 0 0
# The database is initially empty.
#
do_test autoinc-1.1 {
execsql {
|
Changes to test/resetdb.test.
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
...
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
}
# 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 auto_vacuum = 0;
................................................................................
} {1 {file is not a database}}
do_test 330 {
catchsql {
PRAGMA quick_check
} db2
} {1 {file is not a database}}
# Reset the database yet again. Verify that the page size and
# journal mode are preserved.
#
do_test 400 {
sqlite3_db_config db RESET_DB 1
db eval VACUUM
|
>
>
|
>
>
>
>
|
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
...
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
|
} # 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". # # Permutation "journaltest" does not support wal mode. # if {[permutation]=="inmemory_journal" || [permutation]=="journaltest" } { finish_test return } # Create a sample database do_execsql_test 100 { PRAGMA auto_vacuum = 0; ................................................................................ } {1 {file is not a database}} do_test 330 { catchsql { PRAGMA quick_check } db2 } {1 {file is not a database}} db2 cache flush ;# Required by permutation "prepare". # Reset the database yet again. Verify that the page size and # journal mode are preserved. # do_test 400 { sqlite3_db_config db RESET_DB 1 db eval VACUUM |