third_party/sqlite/sqlite-src-3070603/test/e_select.test - Issue 826543003: [sql] Import reference version of SQLite 3.7.6.3.

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/sqlite-src-3070603/test/e_select.test

Issue 826543003: [sql] Import reference version of SQLite 3.7.6.3. (Closed) Base URL: http://chromium.googlesource.com/chromium/src.git@master

Patch Set: gitignore forgot some files for me. Created 5 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

OLD	NEW
1 # 2010 July 16	1 # 2010 July 16

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 2142 matching lines...) Expand 10 before \| Expand all \| Expand 10 after Loading...
2153	2153

2154 8 { SELECT b FROM f1 ORDER BY a LIMIT 20, 10 } {u v w x y z}	2154 8 { SELECT b FROM f1 ORDER BY a LIMIT 20, 10 } {u v w x y z}

2155 9 { SELECT a FROM f1 ORDER BY a DESC LIMIT 18+4, 100 } {4 3 2 1}	2155 9 { SELECT a FROM f1 ORDER BY a DESC LIMIT 18+4, 100 } {4 3 2 1}

2156	2156

2157 10 { SELECT b FROM f1 ORDER BY a LIMIT -1, 5 } {a b c d e}	2157 10 { SELECT b FROM f1 ORDER BY a LIMIT -1, 5 } {a b c d e}

2158 11 { SELECT b FROM f1 ORDER BY a LIMIT -500, 5 } {a b c d e}	2158 11 { SELECT b FROM f1 ORDER BY a LIMIT -500, 5 } {a b c d e}

2159 12 { SELECT b FROM f1 ORDER BY a LIMIT 0, 5 } {a b c d e}	2159 12 { SELECT b FROM f1 ORDER BY a LIMIT 0, 5 } {a b c d e}

2160 }	2160 }

2161	2161

2162 finish_test	2162 finish_test

OLD	NEW