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/descidx3.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
OLDNEW
1 # 2006 January 02 1 # 2006 January 02
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 114 matching lines...) Expand 10 before | Expand all | Expand 10 after
125 execsql { 125 execsql {
126 SELECT i FROM t1 WHERE b>-9999 AND b<x'ffffffff' 126 SELECT i FROM t1 WHERE b>-9999 AND b<x'ffffffff'
127 } 127 }
128 } {9 7 6 8 3 4 2 5} 128 } {9 7 6 8 3 4 2 5}
129 129
130 ifcapable subquery { 130 ifcapable subquery {
131 # If the subquery capability is not compiled in to the binary, then 131 # If the subquery capability is not compiled in to the binary, then
132 # the IN(...) operator is not available. Hence these tests cannot be 132 # the IN(...) operator is not available. Hence these tests cannot be
133 # run. 133 # run.
134 do_test descidx3-4.1 { 134 do_test descidx3-4.1 {
135 execsql { 135 lsort [execsql {
136 UPDATE t1 SET a=2 WHERE i<6; 136 UPDATE t1 SET a=2 WHERE i<6;
137 SELECT i FROM t1 WHERE a IN (1,2) AND b>0 AND b<'zzz'; 137 SELECT i FROM t1 WHERE a IN (1,2) AND b>0 AND b<'zzz';
138 } 138 }]
139 } {8 6 2 4 3} 139 } {2 3 4 6 8}
140 do_test descidx3-4.2 { 140 do_test descidx3-4.2 {
141 execsql { 141 execsql {
142 UPDATE t1 SET a=1; 142 UPDATE t1 SET a=1;
143 SELECT i FROM t1 WHERE a IN (1,2) AND b>0 AND b<'zzz'; 143 SELECT i FROM t1 WHERE a IN (1,2) AND b>0 AND b<'zzz';
144 } 144 }
145 } {2 4 3 8 6} 145 } {2 4 3 8 6}
146 do_test descidx3-4.3 { 146 do_test descidx3-4.3 {
147 execsql { 147 execsql {
148 UPDATE t1 SET b=2; 148 UPDATE t1 SET b=2;
149 SELECT i FROM t1 WHERE a IN (1,2) AND b>0 AND b<'zzz'; 149 SELECT i FROM t1 WHERE a IN (1,2) AND b>0 AND b<'zzz';
150 } 150 }
151 } {9 7 6 8 3 4 2 5 1} 151 } {9 7 6 8 3 4 2 5 1}
152 } 152 }
153 153
154 finish_test 154 finish_test
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698