Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update misc7.test to account for EQP changes. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
917af565ac0c71c14fcba56632e687ed |
| User & Date: | dan 2010-12-02 06:08:53 |
Context
|
2010-12-02
| ||
| 11:24 | Fix a (harmless) valgrind warning in the rtree extension. check-in: a94b9a39 user: dan tags: trunk | |
| 06:08 | Update misc7.test to account for EQP changes. check-in: 917af565 user: dan tags: trunk | |
|
2010-12-01
| ||
| 23:42 | Changed multiplex shim's xFilesize to return an error on mismatched chunk size. Added test of same. check-in: 6818c6e4 user: shaneh tags: trunk | |
Changes
configure became executable.
install-sh became executable.
Changes to test/misc7.test.
255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 |
db close
file delete -force test.db
file delete -force test.db-journal
sqlite3 db test.db
ifcapable explain {
do_test misc7-14.1 {
execsql {
CREATE TABLE abc(a PRIMARY KEY, b, c);
}
execsql {
EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 WHERE rowid = 1;
}
} {0 0 {TABLE abc AS t2 USING PRIMARY KEY}}
do_test misc7-14.2 {
execsql {
EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 WHERE a = 1;
}
} {0 0 {TABLE abc AS t2 WITH INDEX sqlite_autoindex_abc_1}}
do_test misc7-14.3 {
execsql {
EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 ORDER BY a;
}
} {0 0 {TABLE abc AS t2 WITH INDEX sqlite_autoindex_abc_1 ORDER BY}}
}
db close
file delete -force test.db
file delete -force test.db-journal
sqlite3 db test.db
|
| < | < < | > > | < | < | > > | < | < | > > | < |
255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 |
db close
file delete -force test.db
file delete -force test.db-journal
sqlite3 db test.db
ifcapable explain {
do_execsql_test misc7-14.1 {
CREATE TABLE abc(a PRIMARY KEY, b, c);
EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 WHERE rowid = 1;
} {
0 0 0 {SEARCH TABLE abc AS t2 USING INTEGER PRIMARY KEY (rowid=?) (~1 rows)}
}
do_execsql_test misc7-14.2 {
EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 WHERE a = 1;
} {0 0 0
{SEARCH TABLE abc AS t2 USING INDEX sqlite_autoindex_abc_1 (a=?) (~1 rows)}
}
do_execsql_test misc7-14.3 {
EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 ORDER BY a;
} {0 0 0
{SCAN TABLE abc AS t2 USING INDEX sqlite_autoindex_abc_1 (~1000000 rows)}
}
}
db close
file delete -force test.db
file delete -force test.db-journal
sqlite3 db test.db
|