Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add a test to ensure that if BEGIN IMMEDIATE fails with SQLITE_BUSY, it does not leave the user with an open read transaction (unless one was already open). |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
22bced36f0f121f29d94f1f9eab45c87 |
| User & Date: | dan 2013-06-27 14:24:15 |
Context
|
2013-06-27
| ||
| 17:40 | Make sure that sqlite3_stmt_readonly reports false for PRAGMA journal_mode and PRAGMA wal_checkpoint. Ticket [a589ec069e3]. Also keep track of whether a prepared statement does no reading or writing. (check-in: 1937fd8e user: drh tags: trunk) | |
| 14:24 | Add a test to ensure that if BEGIN IMMEDIATE fails with SQLITE_BUSY, it does not leave the user with an open read transaction (unless one was already open). (check-in: 22bced36 user: dan tags: trunk) | |
| 14:07 | If the filename argument to the ".import" command in the command-line shell begins with '|' then treat it as an input pipe rather than a file. (check-in: 4c02b344 user: drh tags: trunk) | |
Changes
Changes to test/wal6.test.
138 139 140 141 142 143 144 145 146 147 |
do_execsql_test 2.6.3 { DELETE FROM t1 }
db eval {SELECT test3('2.6.4')}
}
do_test 2.x {
db2 close
} {}
finish_test
|
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 |
do_execsql_test 2.6.3 { DELETE FROM t1 }
db eval {SELECT test3('2.6.4')}
}
do_test 2.x {
db2 close
} {}
#-------------------------------------------------------------------------
# Check that if BEGIN IMMEDIATE fails, it does not leave the user with
# an open read-transaction (unless one was already open before the BEGIN
# IMMEDIATE). Even if there are other active VMs.
#
proc test4 {prefix} {
do_test $prefix.1 {
catchsql { BEGIN IMMEDIATE }
} {1 {database is locked}}
do_test $prefix.2 {
execsql { COMMIT } db2
} {}
do_test $prefix.3 {
execsql { BEGIN IMMEDIATE }
} {}
do_test $prefix.4 {
execsql { COMMIT }
} {}
}
reset_db
sqlite3 db2 test.db
do_execsql_test 3.1 {
PRAGMA journal_mode = WAL;
CREATE TABLE ab(a PRIMARY KEY, b);
} {wal}
do_test 3.2.1 {
execsql {
BEGIN;
INSERT INTO ab VALUES(1, 2);
} db2
} {}
test4 3.2.2
db func test4 test4
do_test 3.3.1 {
execsql {
BEGIN;
INSERT INTO ab VALUES(3, 4);
} db2
} {}
db eval {SELECT test4('3.3.2')}
do_test 3.x {
db2 close
} {}
finish_test
|