OLD | NEW |
1 # 2008 Sep 1 | 1 # 2008 Sep 1 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
11 # | 11 # |
12 # $Id: rtree6.test,v 1.1 2008/09/01 12:47:00 danielk1977 Exp $ | |
13 # | 12 # |
14 | 13 |
15 if {![info exists testdir]} { | 14 if {![info exists testdir]} { |
16 set testdir [file join [file dirname $argv0] .. .. test] | 15 set testdir [file join [file dirname [info script]] .. .. test] |
17 } | 16 } |
18 source $testdir/tester.tcl | 17 source $testdir/tester.tcl |
19 | 18 |
20 ifcapable !rtree { | 19 ifcapable !rtree { |
21 finish_test | 20 finish_test |
22 return | 21 return |
23 } | 22 } |
24 | 23 |
25 # Operator Byte Value | 24 # Operator Byte Value |
26 # ---------------------- | 25 # ---------------------- |
(...skipping 55 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
82 do_test rtree6.2.2 { | 81 do_test rtree6.2.2 { |
83 query_plan {SELECT * FROM t1,t2 WHERE k=ii AND x1<10} | 82 query_plan {SELECT * FROM t1,t2 WHERE k=ii AND x1<10} |
84 } [list \ | 83 } [list \ |
85 {TABLE t1 VIRTUAL TABLE INDEX 2:Ca} \ | 84 {TABLE t1 VIRTUAL TABLE INDEX 2:Ca} \ |
86 {TABLE t2 USING PRIMARY KEY} \ | 85 {TABLE t2 USING PRIMARY KEY} \ |
87 ] | 86 ] |
88 | 87 |
89 do_test rtree6.2.3 { | 88 do_test rtree6.2.3 { |
90 query_plan {SELECT * FROM t1,t2 WHERE k=ii} | 89 query_plan {SELECT * FROM t1,t2 WHERE k=ii} |
91 } [list \ | 90 } [list \ |
92 {TABLE t2} \ | 91 {TABLE t1 VIRTUAL TABLE INDEX 2:} \ |
93 {TABLE t1 VIRTUAL TABLE INDEX 1:} \ | 92 {TABLE t2 USING PRIMARY KEY} \ |
94 ] | 93 ] |
95 | 94 |
96 do_test rtree6.2.4 { | 95 do_test rtree6.2.4 { |
97 query_plan {SELECT * FROM t1,t2 WHERE v=10 and x1<10 and x2>10} | 96 query_plan {SELECT * FROM t1,t2 WHERE v=10 and x1<10 and x2>10} |
98 } [list \ | 97 } [list \ |
99 {TABLE t1 VIRTUAL TABLE INDEX 2:CaEb} \ | 98 {TABLE t1 VIRTUAL TABLE INDEX 2:CaEb} \ |
100 {TABLE t2} \ | 99 {TABLE t2} \ |
101 ] | 100 ] |
102 | 101 |
103 do_test rtree6.2.5 { | 102 do_test rtree6.2.5 { |
104 query_plan {SELECT * FROM t1,t2 WHERE k=ii AND x1<v} | 103 query_plan {SELECT * FROM t1,t2 WHERE k=ii AND x1<v} |
105 } [list \ | 104 } [list \ |
106 {TABLE t2} \ | 105 {TABLE t1 VIRTUAL TABLE INDEX 2:} \ |
107 {TABLE t1 VIRTUAL TABLE INDEX 1:} \ | 106 {TABLE t2 USING PRIMARY KEY} \ |
108 ] | 107 ] |
109 | 108 |
110 finish_test | 109 finish_test |
111 | |
OLD | NEW |