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

Side by Side Diff: third_party/sqlite/src/test/tkt3810.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/tkt3630.test ('k') | third_party/sqlite/src/test/tkt4018.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 # 2009 August 1 1 # 2009 August 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 44 matching lines...) Expand 10 before | Expand all | Expand 10 after
55 } 55 }
56 catchsql { 56 catchsql {
57 SELECT * FROM t3; 57 SELECT * FROM t3;
58 } 58 }
59 } {0 {}} 59 } {0 {}}
60 60
61 # Trigger still exists in the sqlite_temp_master table, but now it is 61 # Trigger still exists in the sqlite_temp_master table, but now it is
62 # an orphan. 62 # an orphan.
63 # 63 #
64 do_test tkt3810-4 { 64 do_test tkt3810-4 {
65 execsql {SELECT name FROM sqlite_temp_master ORDER BY name} 65 execsql {SELECT name FROM temp.sqlite_master ORDER BY name}
66 } {r1} 66 } {r1}
67 67
68 # Because it is an orphan, it cannot be dropped. 68 # Because it is an orphan, it cannot be dropped.
69 # 69 #
70 do_test tkt3810-5 { 70 do_test tkt3810-5 {
71 catchsql {DROP TRIGGER r1} 71 catchsql {DROP TRIGGER r1}
72 } {1 {no such trigger: r1}} 72 } {1 {no such trigger: r1}}
73 73
74 # Create a table t1 then drop the table in order to drop the orphaned 74 # Create a table t1 then drop the table in order to drop the orphaned
75 # trigger. 75 # trigger.
76 # 76 #
77 do_test tkt3810-6 { 77 do_test tkt3810-6 {
78 execsql {CREATE TABLE t1(x)} db2 78 execsql {CREATE TABLE t1(x)} db2
79 execsql {DROP TABLE t1} 79 execsql {DROP TABLE t1}
80 execsql { 80 execsql {
81 SELECT name FROM sqlite_temp_master; 81 SELECT name FROM sqlite_temp_master;
82 } 82 }
83 } {} 83 } {}
84 84
85 db2 close 85 db2 close
86 86
87 finish_test 87 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/tkt3630.test ('k') | third_party/sqlite/src/test/tkt4018.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698