Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | More test-case adjustments for defensive mode. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | read-only-shadow |
| Files: | files | file ages | folders |
| SHA3-256: |
911e8a17a3810cd7042e91a32aba80dc |
| User & Date: | drh 2018-11-07 14:41:08 |
Context
|
2018-11-07
| ||
| 16:12 | Merge the onefile permutation fix from trunk. (check-in: e543bff8 user: drh tags: read-only-shadow) | |
| 14:41 | More test-case adjustments for defensive mode. (check-in: 911e8a17 user: drh tags: read-only-shadow) | |
| 13:41 | Merge the permutations fix from trunk. (check-in: b753d849 user: drh tags: read-only-shadow) | |
Changes
Changes to test/corrupt.test.
128 129 130 131 132 133 134 135 136 137 138 139 140 141 |
sqlite3 db test.db
list
} {}
do_test corrupt-3.2 {
set t1_r [execsql {SELECT rootpage FROM sqlite_master WHERE name = 't1i1'}]
set t1i1_r [execsql {SELECT rootpage FROM sqlite_master WHERE name = 't1'}]
set cookie [expr [execsql {PRAGMA schema_version}] + 1]
execsql "
PRAGMA writable_schema = 1;
UPDATE sqlite_master SET rootpage = $t1_r WHERE name = 't1';
UPDATE sqlite_master SET rootpage = $t1i1_r WHERE name = 't1i1';
PRAGMA writable_schema = 0;
PRAGMA schema_version = $cookie;
"
|
> |
128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 |
sqlite3 db test.db
list
} {}
do_test corrupt-3.2 {
set t1_r [execsql {SELECT rootpage FROM sqlite_master WHERE name = 't1i1'}]
set t1i1_r [execsql {SELECT rootpage FROM sqlite_master WHERE name = 't1'}]
set cookie [expr [execsql {PRAGMA schema_version}] + 1]
sqlite3_db_config db DEFENSIVE 0
execsql "
PRAGMA writable_schema = 1;
UPDATE sqlite_master SET rootpage = $t1_r WHERE name = 't1';
UPDATE sqlite_master SET rootpage = $t1i1_r WHERE name = 't1i1';
PRAGMA writable_schema = 0;
PRAGMA schema_version = $cookie;
"
|
Changes to test/default.test.
102 103 104 105 106 107 108 109 110 111 112 113 114 115 |
# Do now allow bound parameters in new DEFAULT values.
# Silently convert bound parameters to NULL in DEFAULT causes
# in the sqlite_master table, for backwards compatibility.
#
db close
forcedelete test.db
sqlite3 db test.db
do_execsql_test default-4.0 {
CREATE TABLE t1(a TEXT, b TEXT DEFAULT(99));
PRAGMA writable_schema=ON;
UPDATE sqlite_master SET sql='CREATE TABLE t1(a TEXT, b TEXT DEFAULT(:xyz))';
} {}
db close
sqlite3 db test.db
|
> |
102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 |
# Do now allow bound parameters in new DEFAULT values.
# Silently convert bound parameters to NULL in DEFAULT causes
# in the sqlite_master table, for backwards compatibility.
#
db close
forcedelete test.db
sqlite3 db test.db
sqlite3_db_config db DEFENSIVE 0
do_execsql_test default-4.0 {
CREATE TABLE t1(a TEXT, b TEXT DEFAULT(99));
PRAGMA writable_schema=ON;
UPDATE sqlite_master SET sql='CREATE TABLE t1(a TEXT, b TEXT DEFAULT(:xyz))';
} {}
db close
sqlite3 db test.db
|
Changes to test/e_fts3.test.
673 674 675 676 677 678 679 680 681 682 683 684 685 686 |
#
set DO_MALLOC_TEST 0
ddl_test 10.1.1 { CREATE VIRTUAL TABLE ta USING fts3 }
write_test 10.1.2 ta_content {
INSERT INTO ta VALUES('During a summer vacation in 1790') }
write_test 10.1.3 ta_content {
INSERT INTO ta VALUES('Wordsworth went on a walking tour') }
write_test 10.1.4 ta_content { DELETE FROM ta_content WHERE rowid = 2 }
read_test 10.1.5 {
SELECT * FROM ta WHERE ta MATCH 'summer'
} {{During a summer vacation in 1790}}
error_test 10.1.6 {
SELECT * FROM ta WHERE ta MATCH 'walking'
} {database disk image is malformed}
|
> |
673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 |
#
set DO_MALLOC_TEST 0
ddl_test 10.1.1 { CREATE VIRTUAL TABLE ta USING fts3 }
write_test 10.1.2 ta_content {
INSERT INTO ta VALUES('During a summer vacation in 1790') }
write_test 10.1.3 ta_content {
INSERT INTO ta VALUES('Wordsworth went on a walking tour') }
sqlite3_db_config db DEFENSIVE 0
write_test 10.1.4 ta_content { DELETE FROM ta_content WHERE rowid = 2 }
read_test 10.1.5 {
SELECT * FROM ta WHERE ta MATCH 'summer'
} {{During a summer vacation in 1790}}
error_test 10.1.6 {
SELECT * FROM ta WHERE ta MATCH 'walking'
} {database disk image is malformed}
|
Changes to test/misc7.test.
430 431 432 433 434 435 436 437 438 439 440 441 442 443 |
}
} {0 32}
# sqlite3_test_control_pending_page [expr ($::sqlite_pending_byte / 1024) + 1]
set ::pending_byte_page [expr ($::sqlite_pending_byte / 1024) + 1]
sqlite3_test_control_pending_byte $::sqlite_pending_byte
do_test misc7-17.3 {
db eval {
pragma writable_schema = true;
UPDATE sqlite_master
SET rootpage = $pending_byte_page
WHERE type = 'table' AND name = 't3';
}
execsql {
|
> |
430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 |
}
} {0 32}
# sqlite3_test_control_pending_page [expr ($::sqlite_pending_byte / 1024) + 1]
set ::pending_byte_page [expr ($::sqlite_pending_byte / 1024) + 1]
sqlite3_test_control_pending_byte $::sqlite_pending_byte
do_test misc7-17.3 {
sqlite3_db_config db DEFENSIVE 0
db eval {
pragma writable_schema = true;
UPDATE sqlite_master
SET rootpage = $pending_byte_page
WHERE type = 'table' AND name = 't3';
}
execsql {
|