Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(125)

Unified Diff: third_party/sqlite/ext/rtree/rtree6.test

Issue 3108030: Move bundled copy of sqlite one level deeper to better separate it... (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src/
Patch Set: Created 10 years, 4 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
« no previous file with comments | « third_party/sqlite/ext/rtree/rtree5.test ('k') | third_party/sqlite/ext/rtree/rtree_perf.tcl » ('j') | no next file with comments »
Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
Index: third_party/sqlite/ext/rtree/rtree6.test
===================================================================
--- third_party/sqlite/ext/rtree/rtree6.test (revision 56608)
+++ third_party/sqlite/ext/rtree/rtree6.test (working copy)
@@ -1,111 +0,0 @@
-# 2008 Sep 1
-#
-# The author disclaims copyright to this source code. In place of
-# a legal notice, here is a blessing:
-#
-# May you do good and not evil.
-# May you find forgiveness for yourself and forgive others.
-# May you share freely, never taking more than you give.
-#
-#***********************************************************************
-#
-# $Id: rtree6.test,v 1.1 2008/09/01 12:47:00 danielk1977 Exp $
-#
-
-if {![info exists testdir]} {
- set testdir [file join [file dirname $argv0] .. .. test]
-}
-source $testdir/tester.tcl
-
-ifcapable !rtree {
- finish_test
- return
-}
-
-# Operator Byte Value
-# ----------------------
-# = 0x41 ('A')
-# <= 0x42 ('B')
-# < 0x43 ('C')
-# >= 0x44 ('D')
-# > 0x45 ('E')
-# ----------------------
-
-proc rtree_strategy {sql} {
- set ret [list]
- db eval "explain $sql" a {
- if {$a(opcode) eq "VFilter"} {
- lappend ret $a(p4)
- }
- }
- set ret
-}
-
-proc query_plan {sql} {
- set ret [list]
- db eval "explain query plan $sql" a {
- lappend ret $a(detail)
- }
- set ret
-}
-
-do_test rtree6-1.1 {
- execsql {
- CREATE TABLE t2(k INTEGER PRIMARY KEY, v);
- CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2, y1, y2);
- }
-} {}
-
-do_test rtree6-1.2 {
- rtree_strategy {SELECT * FROM t1 WHERE x1>10}
-} {Ea}
-
-do_test rtree6-1.3 {
- rtree_strategy {SELECT * FROM t1 WHERE x1<10}
-} {Ca}
-
-do_test rtree6-1.4 {
- rtree_strategy {SELECT * FROM t1,t2 WHERE k=ii AND x1<10}
-} {Ca}
-
-do_test rtree6-1.5 {
- rtree_strategy {SELECT * FROM t1,t2 WHERE k=+ii AND x1<10}
-} {Ca}
-
-do_test rtree6.2.1 {
- query_plan {SELECT * FROM t1,t2 WHERE k=+ii AND x1<10}
-} [list \
- {TABLE t1 VIRTUAL TABLE INDEX 2:Ca} \
- {TABLE t2 USING PRIMARY KEY} \
-]
-
-do_test rtree6.2.2 {
- query_plan {SELECT * FROM t1,t2 WHERE k=ii AND x1<10}
-} [list \
- {TABLE t1 VIRTUAL TABLE INDEX 2:Ca} \
- {TABLE t2 USING PRIMARY KEY} \
-]
-
-do_test rtree6.2.3 {
- query_plan {SELECT * FROM t1,t2 WHERE k=ii}
-} [list \
- {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
-
« no previous file with comments | « third_party/sqlite/ext/rtree/rtree5.test ('k') | third_party/sqlite/ext/rtree/rtree_perf.tcl » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698