| OLD | NEW |
| 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 Loading... |
| 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 Loading... |
| 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 Loading... |
| 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 |
| OLD | NEW |