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

Side by Side Diff: third_party/sqlite/src/test/attach3.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/attach.test ('k') | third_party/sqlite/src/test/auth.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 # 2003 July 1 1 # 2003 July 1
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 189 matching lines...) Expand 10 before | Expand all | Expand 10 after
200 200
201 ifcapable tempdb { 201 ifcapable tempdb {
202 # Try to trick SQLite into dropping the wrong temp trigger. 202 # Try to trick SQLite into dropping the wrong temp trigger.
203 do_test attach3-9.0 { 203 do_test attach3-9.0 {
204 execsql { 204 execsql {
205 CREATE TABLE main.t4(a, b, c); 205 CREATE TABLE main.t4(a, b, c);
206 CREATE TABLE aux.t4(a, b, c); 206 CREATE TABLE aux.t4(a, b, c);
207 CREATE TEMP TRIGGER tst_trigger BEFORE INSERT ON aux.t4 BEGIN 207 CREATE TEMP TRIGGER tst_trigger BEFORE INSERT ON aux.t4 BEGIN
208 SELECT 'hello world'; 208 SELECT 'hello world';
209 END; 209 END;
210 SELECT count(*) FROM sqlite_temp_master; 210 SELECT count(*) FROM temp.sqlite_master;
211 } 211 }
212 } {1} 212 } {1}
213 do_test attach3-9.1 { 213 do_test attach3-9.1 {
214 execsql { 214 execsql {
215 DROP TABLE main.t4; 215 DROP TABLE main.t4;
216 SELECT count(*) FROM sqlite_temp_master; 216 SELECT count(*) FROM sqlite_temp_master;
217 } 217 }
218 } {1} 218 } {1}
219 do_test attach3-9.2 { 219 do_test attach3-9.2 {
220 execsql { 220 execsql {
221 DROP TABLE aux.t4; 221 DROP TABLE aux.t4;
222 SELECT count(*) FROM sqlite_temp_master; 222 SELECT count(*) FROM temp.sqlite_master;
223 } 223 }
224 } {0} 224 } {0}
225 } 225 }
226 } ;# endif trigger 226 } ;# endif trigger
227 227
228 # Make sure the aux.sqlite_master table is read-only 228 # Make sure the aux.sqlite_master table is read-only
229 do_test attach3-10.0 { 229 do_test attach3-10.0 {
230 catchsql { 230 catchsql {
231 INSERT INTO aux.sqlite_master VALUES(1, 2, 3, 4, 5); 231 INSERT INTO aux.sqlite_master VALUES(1, 2, 3, 4, 5);
232 } 232 }
(...skipping 111 matching lines...) Expand 10 before | Expand all | Expand 10 after
344 do_test attach3-12.14 { 344 do_test attach3-12.14 {
345 execsql { 345 execsql {
346 DETACH ''; 346 DETACH '';
347 } 347 }
348 db_list 348 db_list
349 } {main temp} 349 } {main temp}
350 350
351 } ;# ifcapable pragma 351 } ;# ifcapable pragma
352 352
353 finish_test 353 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/attach.test ('k') | third_party/sqlite/src/test/auth.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698