Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix two test script problems revealed by permutations.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
60cf7e44871ca8d2136ddad02188f0b9 |
| User & Date: | dan 2013-07-05 19:16:58 |
Context
|
2013-07-06
| ||
| 17:57 | Drop any existing mapping of the database file when exiting the pager "error state", as it may at this point be too large for the database file. Do not invoke file-control MMAP_SIZE if the database file handle does not support xFetch and xUnfetch (on the grounds that xUnfetch(0) calls to invalidate the mapping cannot be made). check-in: 0ae7e75b user: dan tags: trunk | |
|
2013-07-05
| ||
| 19:16 | Fix two test script problems revealed by permutations.test. check-in: 60cf7e44 user: dan tags: trunk | |
| 16:54 | Replace an erroneous SQLITE_OMIT_VIRTUAL_TABLE in vdbeaux.c with SQLITE_OMIT_WAL. Also fix some test script problems. check-in: ff8c3f78 user: dan tags: trunk | |
Changes
Changes to test/autoindex1.test.
20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
#
ifcapable {!autoindex} {
finish_test
return
}
# Setup for logging
sqlite3_shutdown
test_sqlite3_log [list lappend ::log]
set ::log [list]
sqlite3 db test.db
# With automatic index turned off, we do a full scan of the T2 table
|
> |
20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
#
ifcapable {!autoindex} {
finish_test
return
}
# Setup for logging
db close
sqlite3_shutdown
test_sqlite3_log [list lappend ::log]
set ::log [list]
sqlite3 db test.db
# With automatic index turned off, we do a full scan of the T2 table
|
Changes to test/where2.test.
302
303
304
305
306
307
308
309
310
311
312
313
314
315
...
469
470
471
472
473
474
475
476
477
478
479
480
481
482
|
do_test where2-6.6 {
queryplan {
SELECT b.* FROM t1 a, t1 b
WHERE a.w=1 AND (b.z=10 OR a.y=b.z OR b.z=10)
ORDER BY +b.w
}
} [list 1 0 4 4 2 1 9 10 sort a i1w b $::idx]
# Ticket #2249. Make sure the OR optimization is not attempted if
# comparisons between columns of different affinities are needed.
#
do_test where2-6.7 {
execsql {
CREATE TABLE t2249a(a TEXT UNIQUE);
................................................................................
} {1 2 3 2 3 sort}
do_test where2-7.4 {
cksort {
create unique index i9y on t9(y);
select * from t8, t9 where a=1 and y=3 order by b, x
}
} {1 2 3 2 3 nosort}
# Ticket #1807. Using IN constrains on multiple columns of
# a multi-column index.
#
ifcapable subquery {
do_test where2-8.1 {
execsql {
|
>
>
>
>
|
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
...
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
|
do_test where2-6.6 {
queryplan {
SELECT b.* FROM t1 a, t1 b
WHERE a.w=1 AND (b.z=10 OR a.y=b.z OR b.z=10)
ORDER BY +b.w
}
} [list 1 0 4 4 2 1 9 10 sort a i1w b $::idx]
if {[permutation] != "no_optimization"} {
# Ticket #2249. Make sure the OR optimization is not attempted if
# comparisons between columns of different affinities are needed.
#
do_test where2-6.7 {
execsql {
CREATE TABLE t2249a(a TEXT UNIQUE);
................................................................................
} {1 2 3 2 3 sort}
do_test where2-7.4 {
cksort {
create unique index i9y on t9(y);
select * from t8, t9 where a=1 and y=3 order by b, x
}
} {1 2 3 2 3 nosort}
} ;# if {[permutation] != "no_optimization"}
# Ticket #1807. Using IN constrains on multiple columns of
# a multi-column index.
#
ifcapable subquery {
do_test where2-8.1 {
execsql {
|