Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Make sure a variable is cleared before use in the where8.test script. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
b34365296d65310bb015901d18ed463e |
| User & Date: | drh 2009-12-02 02:49:49 |
Context
|
2009-12-02
| ||
| 14:44 | Clear the Pager.dbModified flag when unlocking the database. Assert that it is clear when locking the database. check-in: d17ec16b user: dan tags: trunk | |
| 02:49 | Make sure a variable is cleared before use in the where8.test script. check-in: b3436529 user: drh tags: trunk | |
|
2009-12-01
| ||
| 22:09 | Add testcase() macros to make sure boundary cases in BEFORE UPDATE triggers are well tested. check-in: 27175caa user: drh tags: trunk | |
Changes
Changes to test/where8.test.
638 639 640 641 642 643 644 645 646 647 648 649 650 651 |
196 { SELECT * FROM t3, t4 WHERE 0938446095 > b OR g <= a OR h > b }
197 { SELECT * FROM t3, t4 WHERE g = 2643383279 AND f = g }
198 { SELECT * FROM t3, t4 WHERE g < 8979323846 }
199 { SELECT * FROM t3, t4 WHERE 'are' <= b }
} {
do_test where8-4.$A.$B.1 {
set R [execsql $sql]
if {![info exists results($B)]} {
set results($B) $R
}
list
} {}
|
> |
638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 |
196 { SELECT * FROM t3, t4 WHERE 0938446095 > b OR g <= a OR h > b }
197 { SELECT * FROM t3, t4 WHERE g = 2643383279 AND f = g }
198 { SELECT * FROM t3, t4 WHERE g < 8979323846 }
199 { SELECT * FROM t3, t4 WHERE 'are' <= b }
} {
do_test where8-4.$A.$B.1 {
unset -nocomplain R
set R [execsql $sql]
if {![info exists results($B)]} {
set results($B) $R
}
list
} {}
|