| 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 |