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

Side by Side Diff: third_party/sqlite/src/test/autoindex2.test

Issue 2751253002: [sql] Import SQLite 3.17.0. (Closed)
Patch Set: also clang on Linux i386 Created 3 years, 9 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
« no previous file with comments | « third_party/sqlite/src/test/autoinc.test ('k') | third_party/sqlite/src/test/autovacuum.test » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
1 # 2014-06-17 1 # 2014-06-17
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 200 matching lines...) Expand 10 before | Expand all | Expand 10 after
211 t1, 211 t1,
212 t2, 212 t2,
213 t3 213 t3
214 WHERE 214 WHERE
215 t1.ptime > 1393520400 215 t1.ptime > 1393520400
216 AND param3<>9001 216 AND param3<>9001
217 AND t3.flg7 = 1 217 AND t3.flg7 = 1
218 AND t1.did = t2.did 218 AND t1.did = t2.did
219 AND t2.uid = t3.uid 219 AND t2.uid = t3.uid
220 ORDER BY t1.ptime desc LIMIT 500; 220 ORDER BY t1.ptime desc LIMIT 500;
221 } {0 0 0 {SEARCH TABLE t1 USING INDEX t1x1 (ptime>?)} 0 1 1 {SEARCH TABLE t2 USI NG INDEX t2x0 (did=?)} 0 2 2 {SEARCH TABLE t3 USING INDEX t3x0 (uid=?)}} 221 } {~/AUTO/}
222 # 222 #
223 # ^^^--- Before being fixed, the above was using an automatic covering 223 # ^^^--- Before being fixed, the above was using an automatic covering
224 # on t3 and reordering the tables so that t3 was in the outer loop and 224 # on t3 and reordering the tables so that t3 was in the outer loop and
225 # implementing the ORDER BY clause using a B-Tree. 225 # implementing the ORDER BY clause using a B-Tree.
226 #
227 # This test is sanitized data received from a user. The original unsanitized
228 # data and STAT4 data is found in the th3private test repository. See one of
229 # the th3private check-ins on 2016-02-25. The test is much more accurate when
230 # STAT4 data is used.
226 231
227 finish_test 232 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/autoinc.test ('k') | third_party/sqlite/src/test/autovacuum.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698