Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix minor problems in tcl test scripts. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
56b664185e3e56ad22e0c16a5b946fc8 |
| User & Date: | dan 2019-04-12 12:10:03 |
Context
|
2019-04-12
| ||
| 13:40 | Tweaks to wapptest.tcl: Ensure that the "Debug" checkbox is disabled unless the app is in "config" state, and have Debug variants run "test" instead of "fulltest". check-in: dd248c18 user: dan tags: trunk | |
| 12:10 | Fix minor problems in tcl test scripts. check-in: 56b66418 user: dan tags: trunk | |
|
2019-04-11
| ||
| 19:07 | Add the test/wapptest.tcl script, an alternative to releasetest.tcl that uses wapp to provide the user-interface. check-in: edd87cd6 user: dan tags: trunk | |
Changes
Changes to test/altertab3.test.
95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 |
BEGIN;
ALTER TABLE t3 RENAME TO t4;
} {1 {error in trigger tr1: no such table: main.t2}}
do_execsql_test 4.1.2 {
COMMIT;
}
do_execsql_test 4.1.3 {
SELECT * FROM sqlite_master WHERE type='table' AND name!='t1';
} {table t3 t3 3 {CREATE TABLE t3(e, f)}}
do_catchsql_test 4.2.1 {
BEGIN;
ALTER TABLE t3 RENAME e TO eee;
} {1 {error in trigger tr1: no such table: main.t2}}
do_execsql_test 4.2.2 {
COMMIT;
}
do_execsql_test 4.2.3 {
SELECT * FROM sqlite_master WHERE type='table' AND name!='t1';
} {table t3 t3 3 {CREATE TABLE t3(e, f)}}
#-------------------------------------------------------------------------
reset_db
do_execsql_test 5.0 {
CREATE TABLE t1 (
c1 integer, c2, PRIMARY KEY(c1 collate rtrim),
UNIQUE(c2)
|
> | | > | | |
95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 |
BEGIN;
ALTER TABLE t3 RENAME TO t4;
} {1 {error in trigger tr1: no such table: main.t2}}
do_execsql_test 4.1.2 {
COMMIT;
}
do_execsql_test 4.1.3 {
SELECT type, name, tbl_name, sql
FROM sqlite_master WHERE type='table' AND name!='t1';
} {table t3 t3 {CREATE TABLE t3(e, f)}}
do_catchsql_test 4.2.1 {
BEGIN;
ALTER TABLE t3 RENAME e TO eee;
} {1 {error in trigger tr1: no such table: main.t2}}
do_execsql_test 4.2.2 {
COMMIT;
}
do_execsql_test 4.2.3 {
SELECT type, name, tbl_name, sql
FROM sqlite_master WHERE type='table' AND name!='t1';
} {table t3 t3 {CREATE TABLE t3(e, f)}}
#-------------------------------------------------------------------------
reset_db
do_execsql_test 5.0 {
CREATE TABLE t1 (
c1 integer, c2, PRIMARY KEY(c1 collate rtrim),
UNIQUE(c2)
|
Changes to test/corruptC.test.
93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 |
forcecopy test.bu test.db
# insert corrupt byte(s)
hexio_write test.db 2053 [format %02x 0x04]
sqlite3 db test.db
catchsql {PRAGMA integrity_check}
} {1 {database disk image is malformed}}
# test that a corrupt content offset size is handled (seed 5649)
#
# Update 2016-12-27: As of check-in [0b86fbca66] "In sqlite3BtreeInsert() when
# replacing a re-existing row, try to overwrite the cell directly rather than
# deallocate and reallocate the cell" on 2016-12-09, this test case no longer
# detects the offset size problem during the UPDATE. We have to run a subsequent
|
| > |
93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 |
forcecopy test.bu test.db
# insert corrupt byte(s)
hexio_write test.db 2053 [format %02x 0x04]
sqlite3 db test.db
catchsql {PRAGMA integrity_check}
} {0 {{*** in database main ***
Page 3: free space corruption}}}
# test that a corrupt content offset size is handled (seed 5649)
#
# Update 2016-12-27: As of check-in [0b86fbca66] "In sqlite3BtreeInsert() when
# replacing a re-existing row, try to overwrite the cell directly rather than
# deallocate and reallocate the cell" on 2016-12-09, this test case no longer
# detects the offset size problem during the UPDATE. We have to run a subsequent
|
Changes to test/memdb1.test.
182
183
184
185
186
187
188
189
190
191
192
193
194
195
...
196
197
198
199
200
201
202
203
204
|
} {1 {unknown option: a}}
do_test 620 {
set rc [catch {db serialize a b} msg]
lappend rc $msg
} {1 {wrong # args: should be "db serialize ?DATABASE?"}}
#-------------------------------------------------------------------------
reset_db
do_execsql_test 700 {
CREATE TABLE t1(a, b);
PRAGMA schema_version = 0;
}
do_test 710 {
set ser [db serialize main]
................................................................................
db close
sqlite3 db
db deserialize main $ser
catchsql {
CREATE VIRTUAL TABLE t1 USING rtree(id, a, b, c, d);
}
} {1 {table t1 already exists}}
finish_test
|
>
|
>
|
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
...
197
198
199
200
201
202
203
204
205
206
|
} {1 {unknown option: a}}
do_test 620 {
set rc [catch {db serialize a b} msg]
lappend rc $msg
} {1 {wrong # args: should be "db serialize ?DATABASE?"}}
#-------------------------------------------------------------------------
ifcapable vtab {
reset_db
do_execsql_test 700 {
CREATE TABLE t1(a, b);
PRAGMA schema_version = 0;
}
do_test 710 {
set ser [db serialize main]
................................................................................
db close
sqlite3 db
db deserialize main $ser
catchsql {
CREATE VIRTUAL TABLE t1 USING rtree(id, a, b, c, d);
}
} {1 {table t1 already exists}}
}
finish_test
|
Changes to test/pragma4.test.
170 171 172 173 174 175 176 177 178 179 180 181 182 183 ... 188 189 190 191 192 193 194 195 196 197 198 199 200 201 ... 212 213 214 215 216 217 218 219 220 221 222 223 224 225 |
}
do_test 4.3.4 {
sqlite3 db3 test.db
sqlite3 db2 test.db2
execsql { DROP INDEX i1 } db3
execsql { DROP INDEX i2 } db2
} {}
ifcapable vtab {
do_execsql_test 4.3.5 { SELECT * FROM pragma_index_info('i1') }
do_execsql_test 4.3.6 { SELECT * FROM pragma_index_info('i2') }
}
execsql {SELECT * FROM main.sqlite_master, aux.sqlite_master}
do_execsql_test 4.4.0 {
................................................................................
do_execsql_test 4.4.1 { SELECT * FROM pragma_index_list('t1') } {0 i1 0 c 0}
do_execsql_test 4.4.2 { SELECT * FROM pragma_index_list('t2') } {0 i2 0 c 0}
}
do_test 4.4.3 {
execsql { DROP INDEX i1 } db3
execsql { DROP INDEX i2 } db2
} {}
ifcapable vtab {
do_execsql_test 4.4.5 { SELECT * FROM pragma_index_list('t1') } {}
do_execsql_test 4.4.6 { SELECT * FROM pragma_index_list('t2') } {}
}
execsql {SELECT * FROM main.sqlite_master, aux.sqlite_master}
do_execsql_test 4.5.0 {
................................................................................
0 0 t2 r d {NO ACTION} {NO ACTION} NONE
}
}
do_test 4.5.3 {
execsql { DROP TABLE c1 } db3
execsql { DROP TABLE c2 } db2
} {}
ifcapable vtab {
do_execsql_test 4.5.4 { SELECT * FROM pragma_foreign_key_list('c1') }
do_execsql_test 4.5.5 { SELECT * FROM pragma_foreign_key_list('c2') }
}
execsql {SELECT * FROM main.sqlite_master, aux.sqlite_master}
do_execsql_test 4.6.0 {
|
> > > > > > > |
170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 ... 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 ... 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 |
}
do_test 4.3.4 {
sqlite3 db3 test.db
sqlite3 db2 test.db2
execsql { DROP INDEX i1 } db3
execsql { DROP INDEX i2 } db2
} {}
if {[permutation]=="prepare"} { catchsql { SELECT * FROM sqlite_master } }
ifcapable vtab {
do_execsql_test 4.3.5 { SELECT * FROM pragma_index_info('i1') }
do_execsql_test 4.3.6 { SELECT * FROM pragma_index_info('i2') }
}
execsql {SELECT * FROM main.sqlite_master, aux.sqlite_master}
do_execsql_test 4.4.0 {
................................................................................
do_execsql_test 4.4.1 { SELECT * FROM pragma_index_list('t1') } {0 i1 0 c 0}
do_execsql_test 4.4.2 { SELECT * FROM pragma_index_list('t2') } {0 i2 0 c 0}
}
do_test 4.4.3 {
execsql { DROP INDEX i1 } db3
execsql { DROP INDEX i2 } db2
} {}
if {[permutation]=="prepare"} {
catchsql { SELECT * FROM sqlite_master, aux.sqlite_master }
}
ifcapable vtab {
do_execsql_test 4.4.5 { SELECT * FROM pragma_index_list('t1') } {}
do_execsql_test 4.4.6 { SELECT * FROM pragma_index_list('t2') } {}
}
execsql {SELECT * FROM main.sqlite_master, aux.sqlite_master}
do_execsql_test 4.5.0 {
................................................................................
0 0 t2 r d {NO ACTION} {NO ACTION} NONE
}
}
do_test 4.5.3 {
execsql { DROP TABLE c1 } db3
execsql { DROP TABLE c2 } db2
} {}
if {[permutation]=="prepare"} {
catchsql { SELECT * FROM sqlite_master, aux.sqlite_master }
}
ifcapable vtab {
do_execsql_test 4.5.4 { SELECT * FROM pragma_foreign_key_list('c1') }
do_execsql_test 4.5.5 { SELECT * FROM pragma_foreign_key_list('c2') }
}
execsql {SELECT * FROM main.sqlite_master, aux.sqlite_master}
do_execsql_test 4.6.0 {
|