/ Check-in [5e4e65ea]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix the trigger4 test so that it runs on windows. (CVS 3559)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 5e4e65ea15c51e75e9f003fbfde3fe87e22b889b
User & Date: drh 2007-01-04 22:13:02
Context
2007-01-04
22:13
Fix the user_version and schema_version pragmas so that they set a result column name. Ticket #2143. (CVS 3560) check-in: f81c4227 user: drh tags: trunk
22:13
Fix the trigger4 test so that it runs on windows. (CVS 3559) check-in: 5e4e65ea user: drh tags: trunk
18:01
Put a missing double-quote into the changes.html page. (CVS 3558) check-in: 277f8faa user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to test/trigger4.test.

190
191
192
193
194
195
196
197
198
199
200
    catchsql {update vw set b=b+1000 where a>101 and a<2000}
} {0 {}}
do_test trigger4-7.2 {
    execsql {select a, b from vw where a<=102 or a>=227 order by a}
} {101 1001 102 2002 227 2127 228 2128}

integrity_check trigger4-99.9

file delete -force trigtest.db trigtest.db-journal

finish_test







|



190
191
192
193
194
195
196
197
198
199
200
    catchsql {update vw set b=b+1000 where a>101 and a<2000}
} {0 {}}
do_test trigger4-7.2 {
    execsql {select a, b from vw where a<=102 or a>=227 order by a}
} {101 1001 102 2002 227 2127 228 2128}

integrity_check trigger4-99.9
db close
file delete -force trigtest.db trigtest.db-journal

finish_test