third_party/sqlite/src/test/tpch01.test - Issue 901033002: Import SQLite 3.8.7.4.

Side by Side Diff

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Keyboard Shortcuts

	File
u :	up to issue
j / k :	jump to file after / before current file
J / K :	jump to next file with a comment after / before current file
	Side-by-side diff
i :	toggle intra-line diffs
e :	expand all comments
c :	collapse all comments
s :	toggle showing all comments
n / p :	next / previous diff chunk or comment
N / P :	next / previous comment
<Up> / <Down> :	next / previous line

	Issue
u :	up to list of issues
j / k :	jump to patch after / before current patch
o / <Enter> :	open current patch in side-by-side view
i :	open current patch in unified diff view

	Issue List
j / k :	jump to issue after / before current issue
o / <Enter> :	open current issue

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

Issue 901033002: Import SQLite 3.8.7.4. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master

Patch Set: Chromium changes to support SQLite 3.8.7.4. Created 5 years, 10 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

« third_party/sqlite/src/src/os_unix.c ('K') | « third_party/sqlite/src/test/tkt3929.test ('k') | third_party/sqlite/src/test/trace.test » ('j') | no next file with comments »

OLD	NEW
1 # 2013-09-05	1 # 2013-09-05

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 172 matching lines...) Expand 10 before \| Expand all \| Expand 10 after Loading...
183 c_custkey = o_custkey and l_orderkey = o_orderkey	183 c_custkey = o_custkey and l_orderkey = o_orderkey

184 and o_orderdate >= '1994-08-01' and o_orderdate < date('1994-08-01', '+3 month')	184 and o_orderdate >= '1994-08-01' and o_orderdate < date('1994-08-01', '+3 month')

185 and l_returnflag = 'R' and c_nationkey = n_nationkey	185 and l_returnflag = 'R' and c_nationkey = n_nationkey

186 group by	186 group by

187 c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_c omment	187 c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_c omment

188 order by	188 order by

189 revenue desc;	189 revenue desc;

190 } {0 0 1 {SEARCH TABLE orders USING INDEX odi (O_ORDERDATE>? AND O_ORDERDATE<?)} 0 1 0 {SEARCH TABLE customer USING INDEX cpki (C_CUSTKEY=?)} 0 2 3 {SEARCH TABL E nation USING INDEX npki (N_NATIONKEY=?)} 0 3 2 {SEARCH TABLE lineitem USING IN DEX lpki (L_ORDERKEY=?)} 0 0 0 {USE TEMP B-TREE FOR GROUP BY} 0 0 0 {USE TEMP B- TREE FOR ORDER BY}}	190 } {0 0 1 {SEARCH TABLE orders USING INDEX odi (O_ORDERDATE>? AND O_ORDERDATE<?)} 0 1 0 {SEARCH TABLE customer USING INDEX cpki (C_CUSTKEY=?)} 0 2 3 {SEARCH TABL E nation USING INDEX npki (N_NATIONKEY=?)} 0 3 2 {SEARCH TABLE lineitem USING IN DEX lpki (L_ORDERKEY=?)} 0 0 0 {USE TEMP B-TREE FOR GROUP BY} 0 0 0 {USE TEMP B- TREE FOR ORDER BY}}

191	191

192 finish_test	192 finish_test

OLD	NEW