Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add test case to incrblob4.test. No changes to code. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
fd9c6ff05f2052810549a1a6a384f4b4 |
| User & Date: | dan 2016-10-20 11:48:48 |
Context
|
2016-10-21
| ||
| 10:09 | If SQLITE_DIRECT_OVERFLOW_READ is defined at compile time, add "DIRECT_OVERFLOW_READ" to the list of symbols returned by "PRAGMA compile_options". check-in: b7d9727b user: dan tags: trunk | |
|
2016-10-20
| ||
| 11:48 | Add test case to incrblob4.test. No changes to code. check-in: fd9c6ff0 user: dan tags: trunk | |
|
2016-10-18
| ||
| 16:36 | Minor simplification of the comparison opcodes. check-in: 56474ebc user: drh tags: trunk | |
Changes
Changes to test/incrblob4.test.
82 83 84 85 86 87 88 89 |
do_test 3.3 {
set new [string repeat % 900]
execsql { UPDATE t1 SET v = $new WHERE k = 20 }
execsql { DELETE FROM t1 WHERE k=19 }
execsql { INSERT INTO t1(v) VALUES($new) }
} {}
finish_test
|
> > > > > > > > > > > > > > > > > > > > > |
82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 |
do_test 3.3 {
set new [string repeat % 900]
execsql { UPDATE t1 SET v = $new WHERE k = 20 }
execsql { DELETE FROM t1 WHERE k=19 }
execsql { INSERT INTO t1(v) VALUES($new) }
} {}
#-------------------------------------------------------------------------
# Test that it is not possible to DROP a table with an incremental blob
# cursor open on it.
#
do_execsql_test 4.1 {
CREATE TABLE t2(a INTEGER PRIMARY KEY, b);
INSERT INTO t2 VALUES(456, '0123456789');
}
do_test 4.2 {
set blob [db incrblob -readonly t2 b 456]
read $blob 5
} {01234}
do_catchsql_test 4.3 {
DROP TABLE t2
} {1 {database table is locked}}
do_test 4.4 {
sqlite3_extended_errcode db
} {SQLITE_LOCKED}
close $blob
finish_test
|