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

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

Issue 5626002: Update sqlite to 3.7.3. (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src/third_party/sqlite/src
Patch Set: Remove misc change. Created 10 years 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 | Annotate | Revision Log
« no previous file with comments | « third_party/sqlite/src/test/where6.test ('k') | third_party/sqlite/src/test/where8.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 # 2008 December 23 1 # 2008 December 23
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 72 matching lines...) Expand 10 before | Expand all | Expand 10 after
83 count_steps { 83 count_steps {
84 SELECT a FROM t1 WHERE (b=3 OR c>=10) 84 SELECT a FROM t1 WHERE (b=3 OR c>=10)
85 } 85 }
86 } {2 4 5 scan 0 sort 0} 86 } {2 4 5 scan 0 sort 0}
87 do_test where7-1.9 { 87 do_test where7-1.9 {
88 count_steps { 88 count_steps {
89 SELECT a FROM t1 WHERE (b=3 OR c>=10 OR c=4) 89 SELECT a FROM t1 WHERE (b=3 OR c>=10 OR c=4)
90 } 90 }
91 } {2 4 5 scan 0 sort 0} 91 } {2 4 5 scan 0 sort 0}
92 do_test where7-1.10 { 92 do_test where7-1.10 {
93 breakpoint
94 count_steps { 93 count_steps {
95 SELECT a FROM t1 WHERE (b=3 OR c>=10 OR c=4 OR b>10) 94 SELECT a FROM t1 WHERE (b=3 OR c>=10 OR c=4 OR b>10)
96 } 95 }
97 } {2 4 5 scan 0 sort 0} 96 } {2 4 5 scan 0 sort 0}
98 breakpoint
99 do_test where7-1.11 { 97 do_test where7-1.11 {
100 count_steps { 98 count_steps {
101 SELECT a FROM t1 WHERE (d=5 AND b=3) OR c==100 ORDER BY a; 99 SELECT a FROM t1 WHERE (d=5 AND b=3) OR c==100 ORDER BY a;
102 } 100 }
103 } {2 5 scan 0 sort 1} 101 } {2 5 scan 0 sort 1}
104 do_test where7-1.12 { 102 do_test where7-1.12 {
105 count_steps { 103 count_steps {
106 SELECT a FROM t1 WHERE (b BETWEEN 2 AND 4) OR c=100 ORDER BY a 104 SELECT a FROM t1 WHERE (b BETWEEN 2 AND 4) OR c=100 ORDER BY a
107 } 105 }
108 } {1 2 3 5 scan 0 sort 1} 106 } {1 2 3 5 scan 0 sort 1}
109 do_test where7-1.13.1 { 107 do_test where7-1.13 {
110 count_steps {
111 SELECT a FROM t1 WHERE (b BETWEEN 0 AND 2) OR (c BETWEEN 9 AND 999)
112 ORDER BY a DESC
113 }
114 } {5 4 1 scan 4 sort 0}
115 do_test where7-1.13.2 {
116 count_steps { 108 count_steps {
117 SELECT a FROM t1 WHERE (b BETWEEN 0 AND 2) OR (c BETWEEN 9 AND 999) 109 SELECT a FROM t1 WHERE (b BETWEEN 0 AND 2) OR (c BETWEEN 9 AND 999)
118 ORDER BY +a DESC 110 ORDER BY +a DESC
119 } 111 }
120 } {5 4 1 scan 0 sort 1} 112 } {5 4 1 scan 0 sort 1}
121 113
122 do_test where7-1.14 { 114 do_test where7-1.14 {
123 count_steps { 115 count_steps {
124 SELECT a FROM t1 WHERE (d=8 OR c=6 OR b=4) AND +a>0 116 SELECT a FROM t1 WHERE (d=8 OR c=6 OR b=4) AND +a>0
125 } 117 }
(...skipping 23177 matching lines...) Expand 10 before | Expand all | Expand 10 after
23303 OR a=23 23295 OR a=23
23304 OR (f GLOB '?defg*' AND f GLOB 'cdef*') 23296 OR (f GLOB '?defg*' AND f GLOB 'cdef*')
23305 OR d<0.0 23297 OR d<0.0
23306 OR (d>=22.0 AND d<23.0 AND d NOT NULL) 23298 OR (d>=22.0 AND d<23.0 AND d NOT NULL)
23307 OR a=91 23299 OR a=91
23308 } 23300 }
23309 } {2 22 23 28 54 80 91 scan 0 sort 0} 23301 } {2 22 23 28 54 80 91 scan 0 sort 0}
23310 finish_test 23302 finish_test
23311 23303
23312 finish_test 23304 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/where6.test ('k') | third_party/sqlite/src/test/where8.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698