third_party/sqlite/src/test/whereC.test - Issue 1610963002: Import SQLite 3.10.2.

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/whereC.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

« no previous file with comments | « third_party/sqlite/src/test/where8.test ('k') | third_party/sqlite/src/test/whereD.test » ('j') | no next file with comments »

OLD	NEW
1 # 2011 November 16	1 # 2011 November 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 41 matching lines...) Expand 10 before \| Expand all \| Expand 10 after Loading...
52 5 "SELECT i FROM t1 WHERE a=1 AND b='2' AND i<5" {3 4}	52 5 "SELECT i FROM t1 WHERE a=1 AND b='2' AND i<5" {3 4}

53 6 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i<12" {10 11}	53 6 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i<12" {10 11}

54 7 "SELECT i FROM t1 WHERE a IN(1, 2) AND b=2 AND i<11" {3 4 5 10}	54 7 "SELECT i FROM t1 WHERE a IN(1, 2) AND b=2 AND i<11" {3 4 5 10}

55 8 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i BETWEEN 10 AND 12" {10 11 12}	55 8 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i BETWEEN 10 AND 12" {10 11 12}

56 9 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i BETWEEN 11 AND 12" {11 12}	56 9 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i BETWEEN 11 AND 12" {11 12}

57 10 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i BETWEEN 10 AND 11" {10 11}	57 10 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i BETWEEN 10 AND 11" {10 11}

58 11 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i BETWEEN 12 AND 10" {}	58 11 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i BETWEEN 12 AND 10" {}

59 12 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i<NULL" {}	59 12 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i<NULL" {}

60 13 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i>=NULL" {}	60 13 "SELECT i FROM t1 WHERE a=2 AND b=2 AND i>=NULL" {}

61 14 "SELECT i FROM t1 WHERE a=1 AND b='2' AND i<4.5" {3 4}	61 14 "SELECT i FROM t1 WHERE a=1 AND b='2' AND i<4.5" {3 4}

	62 15 "SELECT i FROM t1 WHERE rowid IS '12'" {12}

62 } {	63 } {

63 do_execsql_test 1.$tn.1 $sql $res	64 do_execsql_test 1.$tn.1 $sql $res

64 do_execsql_test 1.$tn.2 "$sql ORDER BY i ASC" [lsort -integer -inc $res]	65 do_execsql_test 1.$tn.2 "$sql ORDER BY i ASC" [lsort -integer -inc $res]

65 do_execsql_test 1.$tn.3 "$sql ORDER BY i DESC" [lsort -integer -dec $res]	66 do_execsql_test 1.$tn.3 "$sql ORDER BY i DESC" [lsort -integer -dec $res]

66 }	67 }

67	68

68	69

69 finish_test	70 finish_test

OLD	NEW