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

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

Issue 949043002: Add //third_party/sqlite to dirs_to_snapshot, remove net_sql.patch (Closed) Base URL: git@github.com:domokit/mojo.git@master
Patch Set: Created 5 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/alter2.test ('k') | third_party/sqlite/src/test/alter4.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 # 2005 February 19 1 # 2005 February 19
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 178 matching lines...) Expand 10 before | Expand all | Expand 10 after
189 ifcapable schema_version { 189 ifcapable schema_version {
190 do_test alter3-3.4 { 190 do_test alter3-3.4 {
191 execsql { 191 execsql {
192 PRAGMA schema_version; 192 PRAGMA schema_version;
193 } 193 }
194 } {11} 194 } {11}
195 } 195 }
196 196
197 do_test alter3-4.1 { 197 do_test alter3-4.1 {
198 db close 198 db close
199 file delete -force test.db 199 forcedelete test.db
200 set ::DB [sqlite3 db test.db] 200 set ::DB [sqlite3 db test.db]
201 execsql { 201 execsql {
202 PRAGMA legacy_file_format=ON; 202 PRAGMA legacy_file_format=ON;
203 CREATE TABLE t1(a, b); 203 CREATE TABLE t1(a, b);
204 INSERT INTO t1 VALUES(1, 100); 204 INSERT INTO t1 VALUES(1, 100);
205 INSERT INTO t1 VALUES(2, 300); 205 INSERT INTO t1 VALUES(2, 300);
206 SELECT * FROM t1; 206 SELECT * FROM t1;
207 } 207 }
208 } {1 100 2 300} 208 } {1 100 2 300}
209 do_test alter3-4.1 { 209 do_test alter3-4.1 {
(...skipping 20 matching lines...) Expand all
230 } {21} 230 } {21}
231 } 231 }
232 do_test alter3-4.99 { 232 do_test alter3-4.99 {
233 execsql { 233 execsql {
234 DROP TABLE t1; 234 DROP TABLE t1;
235 } 235 }
236 } {} 236 } {}
237 237
238 ifcapable attach { 238 ifcapable attach {
239 do_test alter3-5.1 { 239 do_test alter3-5.1 {
240 file delete -force test2.db 240 forcedelete test2.db
241 file delete -force test2.db-journal 241 forcedelete test2.db-journal
242 execsql { 242 execsql {
243 CREATE TABLE t1(a, b); 243 CREATE TABLE t1(a, b);
244 INSERT INTO t1 VALUES(1, 'one'); 244 INSERT INTO t1 VALUES(1, 'one');
245 INSERT INTO t1 VALUES(2, 'two'); 245 INSERT INTO t1 VALUES(2, 'two');
246 ATTACH 'test2.db' AS aux; 246 ATTACH 'test2.db' AS aux;
247 CREATE TABLE aux.t1 AS SELECT * FROM t1; 247 CREATE TABLE aux.t1 AS SELECT * FROM t1;
248 PRAGMA aux.schema_version = 30; 248 PRAGMA aux.schema_version = 30;
249 SELECT sql FROM aux.sqlite_master; 249 SELECT sql FROM aux.sqlite_master;
250 } 250 }
251 } {{CREATE TABLE t1(a,b)}} 251 } {{CREATE TABLE t1(a,b)}}
(...skipping 136 matching lines...) Expand 10 before | Expand all | Expand 10 after
388 set ::sql "CREATE TABLE t4([join $cols {, }])" 388 set ::sql "CREATE TABLE t4([join $cols {, }])"
389 list 389 list
390 } {} 390 } {}
391 do_test alter3-8.2 { 391 do_test alter3-8.2 {
392 execsql { 392 execsql {
393 SELECT sql FROM sqlite_master WHERE name = 't4'; 393 SELECT sql FROM sqlite_master WHERE name = 't4';
394 } 394 }
395 } [list $::sql] 395 } [list $::sql]
396 396
397 finish_test 397 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/alter2.test ('k') | third_party/sqlite/src/test/alter4.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698