Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update an r-tree test to account for changes in the query planner. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | e5ce66d40bd68dc014071f7830112fa3b1d72948 |
| User & Date: | dan 2009-09-10 18:26:06 |
Context
|
2009-09-10
| ||
| 19:09 | Cleanup of warnings on MSVC build. check-in: 5588cc96 user: shane tags: trunk | |
| 18:26 | Update an r-tree test to account for changes in the query planner. check-in: e5ce66d4 user: dan tags: trunk | |
| 18:17 | Define SQLITE_TEST when compiling mem5.c for testfixture. check-in: 6b16f3c9 user: dan tags: trunk | |
Changes
Changes to ext/rtree/rtree6.test.
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 |
{TABLE t2} \
{TABLE t1 VIRTUAL TABLE INDEX 1:} \
]
do_test rtree6.2.4 {
query_plan {SELECT * FROM t1,t2 WHERE v=10 and x1<10 and x2>10}
} [list \
{TABLE t2} \
{TABLE t1 VIRTUAL TABLE INDEX 2:CaEb} \
]
do_test rtree6.2.5 {
query_plan {SELECT * FROM t1,t2 WHERE k=ii AND x1<v}
} [list \
{TABLE t2} \
{TABLE t1 VIRTUAL TABLE INDEX 1:} \
]
finish_test
|
< > |
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 |
{TABLE t2} \
{TABLE t1 VIRTUAL TABLE INDEX 1:} \
]
do_test rtree6.2.4 {
query_plan {SELECT * FROM t1,t2 WHERE v=10 and x1<10 and x2>10}
} [list \
{TABLE t1 VIRTUAL TABLE INDEX 2:CaEb} \
{TABLE t2} \
]
do_test rtree6.2.5 {
query_plan {SELECT * FROM t1,t2 WHERE k=ii AND x1<v}
} [list \
{TABLE t2} \
{TABLE t1 VIRTUAL TABLE INDEX 1:} \
]
finish_test
|