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

Side by Side Diff: third_party/sqlite/src/ext/rtree/rtree6.test

Issue 1610963002: Import SQLite 3.10.2. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master
Patch Set: Created 4 years, 11 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 unified diff | Download patch
OLDNEW
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 #***********************************************************************
(...skipping 84 matching lines...) Expand 10 before | Expand all | Expand 10 after
95 do_eqp_test rtree6.2.4.1 { 95 do_eqp_test rtree6.2.4.1 {
96 SELECT * FROM t1,t2 WHERE v=+ii and x1<10 and x2>10 96 SELECT * FROM t1,t2 WHERE v=+ii and x1<10 and x2>10
97 } { 97 } {
98 0 0 0 {SCAN TABLE t1 VIRTUAL TABLE INDEX 2:C0E1} 98 0 0 0 {SCAN TABLE t1 VIRTUAL TABLE INDEX 2:C0E1}
99 0 1 1 {SEARCH TABLE t2 USING AUTOMATIC COVERING INDEX (v=?)} 99 0 1 1 {SEARCH TABLE t2 USING AUTOMATIC COVERING INDEX (v=?)}
100 } 100 }
101 do_eqp_test rtree6.2.4.2 { 101 do_eqp_test rtree6.2.4.2 {
102 SELECT * FROM t1,t2 WHERE v=10 and x1<10 and x2>10 102 SELECT * FROM t1,t2 WHERE v=10 and x1<10 and x2>10
103 } { 103 } {
104 0 0 0 {SCAN TABLE t1 VIRTUAL TABLE INDEX 2:C0E1} 104 0 0 0 {SCAN TABLE t1 VIRTUAL TABLE INDEX 2:C0E1}
105 0 1 1 {SEARCH TABLE t2 USING AUTOMATIC COVERING INDEX (v=?)} 105 0 1 1 {SEARCH TABLE t2 USING AUTOMATIC PARTIAL COVERING INDEX (v=?)}
106 } 106 }
107 107
108 do_eqp_test rtree6.2.5 { 108 do_eqp_test rtree6.2.5 {
109 SELECT * FROM t1,t2 WHERE k=ii AND x1<v 109 SELECT * FROM t1,t2 WHERE k=ii AND x1<v
110 } { 110 } {
111 0 0 0 {SCAN TABLE t1 VIRTUAL TABLE INDEX 2:} 111 0 0 0 {SCAN TABLE t1 VIRTUAL TABLE INDEX 2:}
112 0 1 1 {SEARCH TABLE t2 USING INTEGER PRIMARY KEY (rowid=?)} 112 0 1 1 {SEARCH TABLE t2 USING INTEGER PRIMARY KEY (rowid=?)}
113 } 113 }
114 114
115 do_execsql_test rtree6-3.1 { 115 do_execsql_test rtree6-3.1 {
(...skipping 37 matching lines...) Expand 10 before | Expand all | Expand 10 after
153 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 153 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
154 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 154 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
155 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 155 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
156 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 156 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
157 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 157 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
158 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>1.1 158 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>1.1
159 } {} 159 } {}
160 160
161 161
162 finish_test 162 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/ext/rtree/rtree1.test ('k') | third_party/sqlite/src/ext/rtree/rtree9.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698