Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Updated misc. test scripts for Windows testing with gcc/cygwin; (CVS 6541) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
1e2c71596e3f7a69afc5b745c20b2e4e |
| User & Date: | shane 2009-04-23 18:42:05 |
Context
|
2009-04-23
| ||
| 19:08 | os_win.c, winOpen(), changed to handle the SQLITE_OPEN_EXCLUSIVE flag and sharing modes in the same manner as os_unix.c. Ticket #3821. (CVS 6542) check-in: 18fef3fc user: shane tags: trunk | |
| 18:42 | Updated misc. test scripts for Windows testing with gcc/cygwin; (CVS 6541) check-in: 1e2c7159 user: shane tags: trunk | |
| 18:41 | Remove some incorrect async tests; (CVS 6540) check-in: 03af25b3 user: shane tags: trunk | |
Changes
Changes to test/rowhash.test.
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
..
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
# May you share freely, never taking more than you give. # #*********************************************************************** # # This file implements regression tests for SQLite library. The # focus of this file is the code in rowhash.c. # # $Id: rowhash.test,v 1.2 2009/04/21 17:13:38 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl do_test rowhash-1.1 { execsql { CREATE TABLE t1(id INTEGER PRIMARY KEY, a, b, c); ................................................................................ }] } [lsort -integer $lKey] } do_keyset_test rowhash-2.1 {1 2 3} do_keyset_test rowhash-2.2 {0 1 2 3} do_keyset_test rowhash-2.3 {62 125 188} expr srand(1) for {set i 4} {$i < 10} {incr i} { for {set j 0} {$j < 5000} {incr j} { lappend L [expr int(rand()*10000000000)] } do_keyset_test rowhash-2.$i $L } finish_test |
|
>
|
|
|
|
|
|
>
|
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
..
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
# May you share freely, never taking more than you give. # #*********************************************************************** # # This file implements regression tests for SQLite library. The # focus of this file is the code in rowhash.c. # # $Id: rowhash.test,v 1.3 2009/04/23 18:42:05 shane Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl do_test rowhash-1.1 { execsql { CREATE TABLE t1(id INTEGER PRIMARY KEY, a, b, c); ................................................................................ }] } [lsort -integer $lKey] } do_keyset_test rowhash-2.1 {1 2 3} do_keyset_test rowhash-2.2 {0 1 2 3} do_keyset_test rowhash-2.3 {62 125 188} if {[working_64bit_int]} { expr srand(1) for {set i 4} {$i < 10} {incr i} { for {set j 0} {$j < 5000} {incr j} { lappend L [expr int(rand()*10000000000)] } do_keyset_test rowhash-2.$i $L } } finish_test |
Changes to test/savepoint4.test.
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
# # May you do good and not evil. # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # # $Id: savepoint4.test,v 1.4 2009/02/10 14:45:13 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl proc signature {} { return [db eval {SELECT count(*), md5sum(x) FROM t1}] } set ITERATIONS 25 ;# Number of iterations for savepoint4-1 set ITERATIONS2 13 ;# Number of iterations for savepoint4-2 |
| > > > > |
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
# # May you do good and not evil. # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # # $Id: savepoint4.test,v 1.5 2009/04/23 18:42:05 shane Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl ifcapable !crashtest { finish_test return } proc signature {} { return [db eval {SELECT count(*), md5sum(x) FROM t1}] } set ITERATIONS 25 ;# Number of iterations for savepoint4-1 set ITERATIONS2 13 ;# Number of iterations for savepoint4-2 |
Changes to test/vtabD.test.
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
..
58
59
60
61
62
63
64
65
66
67
68
69
70
|
# May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The # focus of this file is creating and dropping virtual tables. # # $Id: vtabD.test,v 1.1 2009/04/21 09:02:47 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl ifcapable !vtab||!schema_pragmas { finish_test ; return } # Register the echo module ................................................................................ execsql { SELECT * FROM tv1 WHERE a < 90000 OR b = 8100000000 } } [execsql { SELECT * FROM t1 WHERE a < 90000 UNION ALL SELECT * FROM t1 WHERE b = 8100000000 AND NOT (a < 90000) }] do_test vtabD-1.8 { execsql { SELECT * FROM tv1 WHERE a = 90001 OR b = 810000 } } {90001 8100180001 900 810000} finish_test |
|
>
>
|
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
..
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
# May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The # focus of this file is creating and dropping virtual tables. # # $Id: vtabD.test,v 1.2 2009/04/23 18:42:05 shane Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl ifcapable !vtab||!schema_pragmas { finish_test ; return } # Register the echo module ................................................................................ execsql { SELECT * FROM tv1 WHERE a < 90000 OR b = 8100000000 } } [execsql { SELECT * FROM t1 WHERE a < 90000 UNION ALL SELECT * FROM t1 WHERE b = 8100000000 AND NOT (a < 90000) }] if {[working_64bit_int]} { do_test vtabD-1.8 { execsql { SELECT * FROM tv1 WHERE a = 90001 OR b = 810000 } } {90001 8100180001 900 810000} } finish_test |