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 |