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

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

Issue 901033002: Import SQLite 3.8.7.4. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master
Patch Set: Chromium changes to support SQLite 3.8.7.4. Created 5 years, 10 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
OLDNEW
1 # 2001 September 15 1 # 2001 September 15
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 283 matching lines...) Expand 10 before | Expand all | Expand 10 after
294 db complete "create \200trigger;" 294 db complete "create \200trigger;"
295 } {1} 295 } {1}
296 } 296 }
297 297
298 298
299 # Try to open a database with a corrupt database file. 299 # Try to open a database with a corrupt database file.
300 # 300 #
301 if {[permutation] == ""} { 301 if {[permutation] == ""} {
302 do_test main-2.0 { 302 do_test main-2.0 {
303 catch {db close} 303 catch {db close}
304 file delete -force test.db 304 forcedelete test.db
305 set fd [open test.db w] 305 set fd [open test.db w]
306 puts $fd hi! 306 puts $fd hi!
307 close $fd 307 close $fd
308 set v [catch {sqlite3 db test.db} msg] 308 set v [catch {sqlite3 db test.db} msg]
309 if {$v} {lappend v $msg} {lappend v {}} 309 if {$v} {lappend v $msg} {lappend v {}}
310 } {0 {}} 310 } {0 {}}
311 } 311 }
312 312
313 # Here are some tests for tokenize.c. 313 # Here are some tests for tokenize.c.
314 # 314 #
315 do_test main-3.1 { 315 do_test main-3.1 {
316 catch {db close} 316 catch {db close}
317 foreach f [glob -nocomplain testdb/*] {file delete -force $f} 317 foreach f [glob -nocomplain testdb/*] {forcedelete $f}
318 file delete -force testdb 318 forcedelete testdb
319 sqlite3 db testdb 319 sqlite3 db testdb
320 set v [catch {execsql {SELECT * from T1 where x!!5}} msg] 320 set v [catch {execsql {SELECT * from T1 where x!!5}} msg]
321 lappend v $msg 321 lappend v $msg
322 } {1 {unrecognized token: "!!"}} 322 } {1 {unrecognized token: "!!"}}
323 do_test main-3.2 { 323 do_test main-3.2 {
324 catch {db close} 324 catch {db close}
325 foreach f [glob -nocomplain testdb/*] {file delete -force $f} 325 foreach f [glob -nocomplain testdb/*] {forcedelete $f}
326 file delete -force testdb 326 forcedelete testdb
327 sqlite3 db testdb 327 sqlite3 db testdb
328 set v [catch {execsql {SELECT * from T1 where ^x}} msg] 328 set v [catch {execsql {SELECT * from T1 where ^x}} msg]
329 lappend v $msg 329 lappend v $msg
330 } {1 {unrecognized token: "^"}} 330 } {1 {unrecognized token: "^"}}
331 do_test main-3.2.2 { 331 do_test main-3.2.2 {
332 catchsql {select 'abc} 332 catchsql {select 'abc}
333 } {1 {unrecognized token: "'abc"}} 333 } {1 {unrecognized token: "'abc"}}
334 do_test main-3.2.3 { 334 do_test main-3.2.3 {
335 catchsql {select "abc} 335 catchsql {select "abc}
336 } {1 {unrecognized token: ""abc"}} 336 } {1 {unrecognized token: ""abc"}}
(...skipping 98 matching lines...) Expand 10 before | Expand all | Expand 10 after
435 do_test main-3.2.29 { 435 do_test main-3.2.29 {
436 catchsql {select 123/} 436 catchsql {select 123/}
437 } {1 {near "/": syntax error}} 437 } {1 {near "/": syntax error}}
438 do_test main-3.2.30 { 438 do_test main-3.2.30 {
439 catchsql {select 123--5} 439 catchsql {select 123--5}
440 } {0 123} 440 } {0 123}
441 441
442 442
443 do_test main-3.3 { 443 do_test main-3.3 {
444 catch {db close} 444 catch {db close}
445 foreach f [glob -nocomplain testdb/*] {file delete -force $f} 445 foreach f [glob -nocomplain testdb/*] {forcedelete $f}
446 file delete -force testdb 446 forcedelete testdb
447 sqlite3 db testdb 447 sqlite3 db testdb
448 execsql { 448 execsql {
449 create table T1(X REAL); /* C-style comments allowed */ 449 create table T1(X REAL); /* C-style comments allowed */
450 insert into T1 values(0.5); 450 insert into T1 values(0.5);
451 insert into T1 values(0.5e2); 451 insert into T1 values(0.5e2);
452 insert into T1 values(0.5e-002); 452 insert into T1 values(0.5e-002);
453 insert into T1 values(5e-002); 453 insert into T1 values(5e-002);
454 insert into T1 values(-5.0e-2); 454 insert into T1 values(-5.0e-2);
455 insert into T1 values(-5.1e-2); 455 insert into T1 values(-5.1e-2);
456 insert into T1 values(0.5e2); 456 insert into T1 values(0.5e2);
(...skipping 52 matching lines...) Expand 10 before | Expand all | Expand 10 after
509 list $rc $msg 509 list $rc $msg
510 } {1 {no such vfs: crash}} 510 } {1 {no such vfs: crash}}
511 do_test main-4.3 { 511 do_test main-4.3 {
512 set rc [catch {sqlite3 db test.db -vfs async} msg] 512 set rc [catch {sqlite3 db test.db -vfs async} msg]
513 list $rc $msg 513 list $rc $msg
514 } {1 {no such vfs: async}} 514 } {1 {no such vfs: async}}
515 } 515 }
516 } 516 }
517 517
518 finish_test 518 finish_test
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698