Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Disable the select1-15 tests when locking_mode is EXCLUSIVE. Ticket #3771. (CVS 6484) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
88cefbb4a12ab7037f025141ddbe041e |
| User & Date: | drh 2009-04-10 15:38:43 |
Context
|
2009-04-10
| ||
| 15:42 | Fix MSVC compiler warning in vdbeaux.c. (CVS 6485) check-in: d619465e user: shane tags: trunk | |
| 15:38 | Disable the select1-15 tests when locking_mode is EXCLUSIVE. Ticket #3771. (CVS 6484) check-in: 88cefbb4 user: drh tags: trunk | |
| 15:02 | Changes to jrnlmode.test to account for in-memory temp databases. (CVS 6483) check-in: c31d4359 user: danielk1977 tags: trunk | |
Changes
Changes to test/select1.test.
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
....
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
|
# 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 testing the SELECT statement. # # $Id: select1.test,v 1.66 2009/04/02 17:23:33 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Try to select on a non-existant table. # do_test select1-1.1 { ................................................................................ } {} do_test select1-14.2 { execsql { SELECT 10 IN (SELECT rowid FROM sqlite_master); } } {0} # Check that ticket #3771 has been fixed. # do_test select1-15.1 { execsql { CREATE TABLE t1(a); CREATE INDEX i1 ON t1(a); INSERT INTO t1 VALUES(1); INSERT INTO t1 VALUES(2); INSERT INTO t1 VALUES(3); } } {} do_test select1-15.2 { sqlite3 db2 test.db execsql { DROP INDEX i1 } db2 db2 close } {} do_test select1-15.3 { execsql { SELECT 2 IN (SELECT a FROM t1) } } {1} finish_test |
|
>
|
>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
>
|
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
....
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
|
# 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 testing the SELECT statement. # # $Id: select1.test,v 1.67 2009/04/10 15:38:43 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Try to select on a non-existant table. # do_test select1-1.1 { ................................................................................ } {} do_test select1-14.2 { execsql { SELECT 10 IN (SELECT rowid FROM sqlite_master); } } {0} if {[db one {PRAGMA locking_mode}]=="normal"} { # Check that ticket #3771 has been fixed. This test does not # work with locking_mode=EXCLUSIVE so disable in that case. # do_test select1-15.1 { execsql { CREATE TABLE t1(a); CREATE INDEX i1 ON t1(a); INSERT INTO t1 VALUES(1); INSERT INTO t1 VALUES(2); INSERT INTO t1 VALUES(3); } } {} do_test select1-15.2 { sqlite3 db2 test.db execsql { DROP INDEX i1 } db2 db2 close } {} do_test select1-15.3 { execsql { SELECT 2 IN (SELECT a FROM t1) } } {1} } finish_test |