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

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

Issue 2751253002: [sql] Import SQLite 3.17.0. (Closed)
Patch Set: also clang on Linux i386 Created 3 years, 9 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/temptable3.test ('k') | third_party/sqlite/src/test/tester.tcl » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
1 # 2009 February 27 1 # 2009 February 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 218 matching lines...) Expand 10 before | Expand all | Expand 10 after
229 CREATE TEMP TRIGGER tr1 BEFORE INSERT ON t1 BEGIN SELECT 1,2,3; END; 229 CREATE TEMP TRIGGER tr1 BEFORE INSERT ON t1 BEGIN SELECT 1,2,3; END;
230 } 230 }
231 231
232 do_test 5.1 { 232 do_test 5.1 {
233 sqlite3 db2 test.db 233 sqlite3 db2 test.db
234 execsql { DROP TABLE t1 } db2 234 execsql { DROP TABLE t1 } db2
235 } {} 235 } {}
236 236
237 do_execsql_test 5.2 { 237 do_execsql_test 5.2 {
238 SELECT * FROM sqlite_master; 238 SELECT * FROM sqlite_master;
239 SELECT * FROM sqlite_temp_master; 239 SELECT * FROM temp.sqlite_master;
240 } { 240 } {
241 trigger tr1 t1 0 241 trigger tr1 t1 0
242 {CREATE TRIGGER tr1 BEFORE INSERT ON t1 BEGIN SELECT 1,2,3; END} 242 {CREATE TRIGGER tr1 BEFORE INSERT ON t1 BEGIN SELECT 1,2,3; END}
243 } 243 }
244 db2 close 244 db2 close
245 245
246 #------------------------------------------------------------------------- 246 #-------------------------------------------------------------------------
247 # Check that if a second connection creates a table in an attached database 247 # Check that if a second connection creates a table in an attached database
248 # with the same name as a table in the main database that has a temp 248 # with the same name as a table in the main database that has a temp
249 # trigger attached to it nothing goes awry. 249 # trigger attached to it nothing goes awry.
(...skipping 20 matching lines...) Expand all
270 } { 270 } {
271 table t1 t1 {CREATE TABLE t1(a, b, c)} 271 table t1 t1 {CREATE TABLE t1(a, b, c)}
272 } 272 }
273 273
274 do_catchsql_test 6.3 { 274 do_catchsql_test 6.3 {
275 INSERT INTO main.t1 VALUES(1); 275 INSERT INTO main.t1 VALUES(1);
276 } {1 error} 276 } {1 error}
277 db2 close 277 db2 close
278 278
279 finish_test 279 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/temptable3.test ('k') | third_party/sqlite/src/test/tester.tcl » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698