Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix another test to account for SUM() returning integer rather than float. (CVS 2672) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
bc723235e65eb4da7d2e4b18653f1173 |
| User & Date: | drh 2005-09-08 12:37:29 |
Context
|
2005-09-08
| ||
| 12:38 | While doing a transaction comment, use fdatasync() instead of fsync() in cases there the file size is unchanged. (CVS 2673) check-in: 3c555a87 user: drh tags: trunk | |
| 12:37 | Fix another test to account for SUM() returning integer rather than float. (CVS 2672) check-in: bc723235 user: drh tags: trunk | |
| 11:04 | Fix typos in documentation. Ticket #1239. (CVS 2671) check-in: 73fbb8d9 user: drh tags: trunk | |
Changes
Changes to test/crash.test.
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
...
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
|
# module "crashtest" compiled with the special "os_test.c" backend is used. # The os_test.c simulates the kind of file corruption that can occur # when writes are happening at the moment of power loss. # # The special crash-test module with its os_test.c backend only works # on Unix. # # $Id: crash.test,v 1.17 2005/01/20 05:24:33 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # set repeats 100 set repeats 10 ................................................................................ execsql { BEGIN } for {set n 0} {$n < 1000} {incr n} { execsql "INSERT INTO abc VALUES($n, [expr 2*$n], [expr 3*$n])" } execsql { COMMIT } set ::sig [signature] execsql { SELECT sum(a), sum(b), sum(c) from abc } } {499500.0 999000.0 1498500.0} do_test crash-2.2 { expr ([file size test.db] / 1024)>16 } {1} do_test crash-2.3 { crashsql 2 test.db-journal { DELETE FROM abc WHERE a < 800; } |
|
|
|
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
...
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
|
# module "crashtest" compiled with the special "os_test.c" backend is used. # The os_test.c simulates the kind of file corruption that can occur # when writes are happening at the moment of power loss. # # The special crash-test module with its os_test.c backend only works # on Unix. # # $Id: crash.test,v 1.18 2005/09/08 12:37:29 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # set repeats 100 set repeats 10 ................................................................................ execsql { BEGIN } for {set n 0} {$n < 1000} {incr n} { execsql "INSERT INTO abc VALUES($n, [expr 2*$n], [expr 3*$n])" } execsql { COMMIT } set ::sig [signature] execsql { SELECT sum(a), sum(b), sum(c) from abc } } {499500 999000 1498500} do_test crash-2.2 { expr ([file size test.db] / 1024)>16 } {1} do_test crash-2.3 { crashsql 2 test.db-journal { DELETE FROM abc WHERE a < 800; } |