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

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

Issue 6990047: Import SQLite 3.7.6.3. (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src
Patch Set: Created 9 years, 7 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 | Annotate | Revision Log
« no previous file with comments | « third_party/sqlite/src/test/vtab_alter.test ('k') | third_party/sqlite/src/test/wal.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 # 2007 April 16 1 # 2007 April 16
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 126 matching lines...) Expand 10 before | Expand all | Expand 10 after
137 register_echo_module [sqlite3_connection_pointer db] 137 register_echo_module [sqlite3_connection_pointer db]
138 execsql { 138 execsql {
139 SELECT * FROM t1 UNION ALL 139 SELECT * FROM t1 UNION ALL
140 SELECT * FROM t2 UNION ALL 140 SELECT * FROM t2 UNION ALL
141 SELECT * FROM t3 141 SELECT * FROM t3
142 } db 142 } db
143 } {1 2 3 4 5 6 1 2 3 4 5 6 1 2 3 4 5 6} 143 } {1 2 3 4 5 6 1 2 3 4 5 6 1 2 3 4 5 6}
144 144
145 # Try a rename or two. 145 # Try a rename or two.
146 # 146 #
147 do_test vtab_shared-1.13.1 { 147 ifcapable altertable {
148 execsql { ALTER TABLE t1 RENAME TO t4 } 148 do_test vtab_shared-1.13.1 {
149 execsql { SELECT * FROM t4 } db 149 execsql { ALTER TABLE t1 RENAME TO t4 }
150 } {1 2 3 4 5 6} 150 execsql { SELECT * FROM t4 } db
151 do_test vtab_shared-1.13.2 { 151 } {1 2 3 4 5 6}
152 execsql { SELECT * FROM t4 } db2 152 do_test vtab_shared-1.13.2 {
153 } {1 2 3 4 5 6} 153 execsql { SELECT * FROM t4 } db2
154 do_test vtab_shared-1.13.3 { 154 } {1 2 3 4 5 6}
155 execsql { ALTER TABLE t2 RENAME TO t5 } 155 do_test vtab_shared-1.13.3 {
156 execsql { SELECT * FROM t4 } db2 156 execsql { ALTER TABLE t2 RENAME TO t5 }
157 } {1 2 3 4 5 6} 157 execsql { SELECT * FROM t4 } db2
158 } {1 2 3 4 5 6}
159 }
158 160
159 # Try an UPDATE/INSERT/DELETE on a shared vtab as the first statement after a 161 # Try an UPDATE/INSERT/DELETE on a shared vtab as the first statement after a
160 # schema is loaded. 162 # schema is loaded.
161 do_test vtab_shared_1.14.1 { 163 do_test vtab_shared_1.14.1 {
162 db2 close 164 db2 close
163 sqlite3 db2 test.db 165 sqlite3 db2 test.db
164 register_echo_module [sqlite3_connection_pointer db2] 166 register_echo_module [sqlite3_connection_pointer db2]
165 execsql { SELECT * FROM t3 } 167 execsql { SELECT * FROM t3 }
166 } {1 2 3 4 5 6} 168 } {1 2 3 4 5 6}
167 do_test vtab_shared_1.14.2 { 169 do_test vtab_shared_1.14.2 {
(...skipping 52 matching lines...) Expand 10 before | Expand all | Expand 10 after
220 execsql { 222 execsql {
221 INSERT INTO t3 VALUES(4, 5, 6); 223 INSERT INTO t3 VALUES(4, 5, 6);
222 SELECT * FROM t3; 224 SELECT * FROM t3;
223 } 225 }
224 } {1 2 3 4 5 6} 226 } {1 2 3 4 5 6}
225 227
226 db close 228 db close
227 db2 close 229 db2 close
228 sqlite3_enable_shared_cache 0 230 sqlite3_enable_shared_cache 0
229 finish_test 231 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/vtab_alter.test ('k') | third_party/sqlite/src/test/wal.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698