Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add extra test cases to delete4.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | onepass-delete-or |
| Files: | files | file ages | folders |
| SHA1: |
571b64b923c82060f34bf6baa21d72d2 |
| User & Date: | dan 2015-12-09 17:45:58 |
Context
|
2015-12-11
| ||
| 13:59 | Merge recent changes from trunk. Also remove unused variables to permit compiling with -Werror. check-in: 57b700ba user: drh tags: onepass-delete-or | |
|
2015-12-09
| ||
| 17:45 | Add extra test cases to delete4.test. check-in: 571b64b9 user: dan tags: onepass-delete-or | |
| 16:08 | Fix a problem with the DROP TABLE command on this branch. check-in: c80bbf14 user: dan tags: onepass-delete-or | |
Changes
Changes to test/delete4.test.
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 |
CREATE INDEX t5c ON t5(c);
}
} {
do_test 5.$tn.0 {
execsql { DROP TABLE IF EXISTS t5 }
execsql $tbl
for {set i 1} {$i <= 100} {incr i} {
set a [expr $i*2]
set b [expr ($i*7 % 100)]
set c [expr 100-$i]
execsql { INSERT INTO t5 VALUES($i, $a, $b, $c) }
}
} {}
foreach {tn2 sql} {
1 { DELETE FROM t5 WHERE a=4 OR b=10 OR c=17 }
2 { DELETE FROM t5 WHERE (a=4 OR b=22) AND c=98 }
} {
execsql BEGIN
execsql $sql
do_execsql_test 5.$tn.$tn2.1 { PRAGMA integrity_check } ok
if {$tn==0} {
set res($tn2) [db eval { SELECT count(*), md5sum(i, a, b, c) FROM t5 }]
}
|
< > > > > |
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 |
CREATE INDEX t5c ON t5(c);
}
} {
do_test 5.$tn.0 {
execsql { DROP TABLE IF EXISTS t5 }
execsql $tbl
for {set i 1} {$i <= 100} {incr i} {
set a [expr $i*2]
set b [expr ($i*7 % 100)]
set c [expr 100-$i]
execsql { INSERT INTO t5 VALUES($i, $a, $b, $c) }
}
} {}
foreach {tn2 sql} {
1 { DELETE FROM t5 WHERE a=4 OR b=10 OR c=17 }
2 { DELETE FROM t5 WHERE (a=4 OR b=22) AND c=98 }
3 { DELETE FROM t5 WHERE (b=49 AND c=93) OR a=14 }
4 { DELETE FROM t5 WHERE (b=70 AND c=90) OR a=150 }
5 { DELETE FROM t5 WHERE (a BETWEEN 2 AND 20) OR (b BETWEEN 1 AND 10) }
6 { DELETE FROM t5 WHERE a IN (2, 4, 6, 8) OR b IN (63, 70, 77) }
} {
execsql BEGIN
execsql $sql
do_execsql_test 5.$tn.$tn2.1 { PRAGMA integrity_check } ok
if {$tn==0} {
set res($tn2) [db eval { SELECT count(*), md5sum(i, a, b, c) FROM t5 }]
}
|