Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a bug in where8.test causing a tcl exception. (CVS 6082) |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
495b569a3921042c36667a415c135320 |
| User & Date: | danielk1977 2008-12-30 15:51:41.000 |
Context
|
2008-12-30
| ||
| 16:13 | Add further pseudo-randomly generated test cases to where8.test. (CVS 6083) (check-in: e01f6ef9d9 user: danielk1977 tags: trunk) | |
| 15:51 | Fix a bug in where8.test causing a tcl exception. (CVS 6082) (check-in: 495b569a39 user: danielk1977 tags: trunk) | |
| 15:26 | Add a few more tests to where8.test. (CVS 6081) (check-in: ac28aa8b61 user: danielk1977 tags: trunk) | |
Changes
Changes to test/where8.test.
| ︙ | ︙ | |||
8 9 10 11 12 13 14 | # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The focus # is testing of where.c. More specifically, the focus is the optimization # of WHERE clauses that feature the OR operator. # | | | 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The focus # is testing of where.c. More specifically, the focus is the optimization # of WHERE clauses that feature the OR operator. # # $Id: where8.test,v 1.4 2008/12/30 15:51:41 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Test organization: # # where8-1.*: Tests to demonstrate simple cases work with a single table |
| ︙ | ︙ | |||
400 401 402 403 404 405 406 407 408 409 410 411 412 413 |
INSERT INTO t4 VALUES(271.2019091, 'viewed', 3282306647);
INSERT INTO t4 VALUES('hills', 'all', 'peak');
COMMIT;
}
} {}
catch {unset results}
set A 2
foreach idxsql {
{
/* No indexes */
} {
CREATE INDEX i5 ON t3(a);
} {
| > > > | 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 |
INSERT INTO t4 VALUES(271.2019091, 'viewed', 3282306647);
INSERT INTO t4 VALUES('hills', 'all', 'peak');
COMMIT;
}
} {}
catch {unset results}
catch {unset A}
catch {unset B}
set A 2
foreach idxsql {
{
/* No indexes */
} {
CREATE INDEX i5 ON t3(a);
} {
|
| ︙ | ︙ | |||
468 469 470 471 472 473 474 475 476 477 |
list
} {}
do_test where8-4.$A.$B.2 { lsort $R } [lsort $results($B)]
}
incr A
}
finish_test
| > > > > | 471 472 473 474 475 476 477 478 479 480 481 482 483 484 |
list
} {}
do_test where8-4.$A.$B.2 { lsort $R } [lsort $results($B)]
}
incr A
}
catch {unset results}
catch {unset A}
catch {unset B}
finish_test
|