Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | More minor test file fixes. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
352878fe1cbcf7b6803624544bba5a95 |
| User & Date: | dan 2019-09-26 20:57:53 |
Context
|
2019-09-27
| ||
| 15:01 | Fix sqlite3ExprCompare() so that it ignores differences in the Expr.iTable field for IN operators, as otherwise it can lead to false negatives, which is usually harmless, but can cause problems for an assert() in the window function logic. check-in: 6a204b192a user: drh tags: trunk | |
|
2019-09-26
| ||
| 20:57 | More minor test file fixes. check-in: 352878fe1c user: dan tags: trunk | |
| 20:05 | Allow DROP TABLE to work on tables name "sqlite_parameters" just as it does with tables named "sqlite_stat%". Fix for the ".parameter clear" command in the shell. check-in: e768179baa user: drh tags: trunk | |
Changes
Changes to test/corruptL.test.
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
...
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
|
| 448: 00 00 74 72 69 67 62 ff ff ff ff fc 00 00 07 05 ..trigb.........
| 464: 05 01 01 09 09 02 02 19 04 05 17 17 17 17 10 65 ...............e
| 480: 76 65 6e 65 69 67 68 74 65 40 18 00 00 00 00 01 veneighte@......
| 496: 02 03 07 04 01 01 01 03 04 02 05 04 09 01 ff fd ................
| end crash-6b48ba69806134.db
}]} {}
do_catchsql_test 4.1 {
PRAGMA writable_schema=ON; -- bypass improved sqlite_master consistency checking
INSERT INTO t3 SELECT * FROM t2;
} {1 {database disk image is malformed}}
#-------------------------------------------------------------------------
reset_db
do_test 5.0 {
sqlite3 db {}
db deserialize [decode_hexdb {
| size 192512 pagesize 4096 filename crash-9ae5502296c949.db
................................................................................
| 480: 00 00 ff ff ff 00 00 00 5f 00 fb 00 00 2d 00 00 ........_....-..
| 496: 00 00 00 1e 00 00 00 fe 00 00 64 00 00 ff fb 02 ..........d.....
| page 4 offset 1536
| 0: 0d 00 39 00 00 02 00 00 00 00 00 00 00 00 00 00 ..9.............
| end a.db
}]} {}
do_catchsql_test 8.1 {
PRAGMA writable_schema=ON; -- bypass improved sqlite_master consistency checking
INSERT INTO t3 SELECT * FROM t2;
} {1 {database disk image is malformed}}
#-------------------------------------------------------------------------
reset_db
do_test 9.0 {
sqlite3 db {}
db deserialize [decode_hexdb {
| size 8192 pagesize 4096 filename crash-ab10597e4e1c32.db
|
>
>
>
>
|
<
>
>
>
|
|
|
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
...
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
|
| 448: 00 00 74 72 69 67 62 ff ff ff ff fc 00 00 07 05 ..trigb.........
| 464: 05 01 01 09 09 02 02 19 04 05 17 17 17 17 10 65 ...............e
| 480: 76 65 6e 65 69 67 68 74 65 40 18 00 00 00 00 01 veneighte@......
| 496: 02 03 07 04 01 01 01 03 04 02 05 04 09 01 ff fd ................
| end crash-6b48ba69806134.db
}]} {}
set res {1 {database disk image is malformed}}
ifcapable oversize_cell_check {
set res {1 {no such table: t3}}
}
do_catchsql_test 4.1 {
PRAGMA writable_schema=ON; -- bypass improved sqlite_master consistency checking
INSERT INTO t3 SELECT * FROM t2;
} $res
#-------------------------------------------------------------------------
reset_db
do_test 5.0 {
sqlite3 db {}
db deserialize [decode_hexdb {
| size 192512 pagesize 4096 filename crash-9ae5502296c949.db
................................................................................
| 480: 00 00 ff ff ff 00 00 00 5f 00 fb 00 00 2d 00 00 ........_....-..
| 496: 00 00 00 1e 00 00 00 fe 00 00 64 00 00 ff fb 02 ..........d.....
| page 4 offset 1536
| 0: 0d 00 39 00 00 02 00 00 00 00 00 00 00 00 00 00 ..9.............
| end a.db
}]} {}
set res {1 {database disk image is malformed}}
ifcapable oversize_cell_check {
set res {1 {no such table: t3}}
}
do_catchsql_test 8.1 {
PRAGMA writable_schema=ON; -- bypass improved sqlite_master consistency checking
INSERT INTO t3 SELECT * FROM t2;
} $res
#-------------------------------------------------------------------------
reset_db
do_test 9.0 {
sqlite3 db {}
db deserialize [decode_hexdb {
| size 8192 pagesize 4096 filename crash-ab10597e4e1c32.db
|
Changes to test/releasetest_data.tcl.
574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 |
if {[string range $config end end]=="*"} {
set bNosynthetic 1
set config [string range $config 0 end-1]
}
puts "$config \"$target\""
if {$bNodebug==0 && $bNosynthetic==0} {
set iHas [string first SQLITE_DEBUG $::Configs($config)]
if {$iHas>=0} {
puts "$config-ndebug \"test\""
} else {
puts "$config-debug \"test\""
}
}
}
}
if {[llength $argv]==0} { usage }
set cmd [lindex $argv 0]
|
> > > > | | |
574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 |
if {[string range $config end end]=="*"} {
set bNosynthetic 1
set config [string range $config 0 end-1]
}
puts "$config \"$target\""
if {$bNodebug==0 && $bNosynthetic==0} {
set iHas [string first SQLITE_DEBUG $::Configs($config)]
set dtarget test
if {$target=="tcltest"} {
set dtarget tcltest
}
if {$iHas>=0} {
puts "$config-ndebug \"$dtarget\""
} else {
puts "$config-debug \"$dtarget\""
}
}
}
}
if {[llength $argv]==0} { usage }
set cmd [lindex $argv 0]
|