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

Side by Side Diff: third_party/sqlite/src/test/misc4.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/misc1.test ('k') | third_party/sqlite/src/test/misc5.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 # 2004 Jun 27 1 # 2004 Jun 27
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 190 matching lines...) Expand 10 before | Expand all | Expand 10 after
201 INSERT INTO abc VALUES(1); 201 INSERT INTO abc VALUES(1);
202 CREATE TABLE def(d, e, f, PRIMARY KEY(d, e)); 202 CREATE TABLE def(d, e, f, PRIMARY KEY(d, e));
203 } 203 }
204 } {} 204 } {}
205 do_test misc4-6.2 { 205 do_test misc4-6.2 {
206 execsql { 206 execsql {
207 SELECT a FROM abc LEFT JOIN def ON (abc.a=def.d); 207 SELECT a FROM abc LEFT JOIN def ON (abc.a=def.d);
208 } 208 }
209 } {1} 209 } {1}
210 210
211 # 2015-05-15. Error message formatting problem.
212 #
213 db close
214 sqlite3 db :memory:
215 do_catchsql_test misc4-7.1 {
216 CREATE TABLE t7(x);
217 PRAGMA writable_schema=ON;
218 UPDATE sqlite_master SET sql='CREATE TABLE [M%s%s%s%s%s%s%s%s%s%s%s%s%s';
219 VACUUM;
220 } {1 {unrecognized token: "[M%s%s%s%s%s%s%s%s%s%s%s%s%s"}}
221
222 # 2015-05-18. Use of ephermeral Mem content after the cursor that holds
223 # the canonical content has moved on.
224 #
225 do_execsql_test misc4-7.2 {
226 CREATE TABLE t0(a,b);
227 INSERT INTO t0 VALUES(1,0),(2,0);
228 UPDATE t0 SET b=9 WHERE a AND (SELECT a FROM t0 WHERE a);
229 SELECT * FROM t0 ORDER BY +a;
230 } {1 9 2 9}
231
211 finish_test 232 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/misc1.test ('k') | third_party/sqlite/src/test/misc5.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698