Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix an issue with the fsdir() table-valued function not resetting correctly after each pass of a join. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
7ce4e71c1b7251be9e922b21dfeba1f9 |
| User & Date: | drh 2018-03-15 15:09:45 |
Context
|
2018-03-15
| ||
| 17:46 | Fix a typo in a comment used to generate documentation. No code changes. (check-in: f1784aff user: drh tags: trunk) | |
| 15:09 | Fix an issue with the fsdir() table-valued function not resetting correctly after each pass of a join. (check-in: 7ce4e71c user: drh tags: trunk) | |
| 05:25 | Draft fix for an fsdir() issue reported via the mailing list. (Closed-Leaf check-in: 48641010 user: mistachkin tags: fsDirFix) | |
|
2018-03-14
| ||
| 15:25 | Add the SQLITE_DBSTATUS_CACHE_SPILL option to sqlite3_db_status(). (check-in: 48a06eb0 user: drh tags: trunk) | |
Changes
Changes to ext/misc/fileio.c.
| ︙ | ︙ | |||
492 493 494 495 496 497 498 499 500 501 502 503 504 505 | } sqlite3_free(pCur->zPath); sqlite3_free(pCur->aLvl); pCur->aLvl = 0; pCur->zPath = 0; pCur->zBase = 0; pCur->nBase = 0; pCur->iLvl = -1; pCur->iRowid = 1; } /* ** Destructor for an fsdir_cursor. */ | > | 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 | } sqlite3_free(pCur->zPath); sqlite3_free(pCur->aLvl); pCur->aLvl = 0; pCur->zPath = 0; pCur->zBase = 0; pCur->nBase = 0; pCur->nLvl = 0; pCur->iLvl = -1; pCur->iRowid = 1; } /* ** Destructor for an fsdir_cursor. */ |
| ︙ | ︙ |
Changes to test/zipfile.test.
| ︙ | ︙ | |||
510 511 512 513 514 515 516 517 518 519 520 521 522 523 |
ORDER BY name
}
} [list {*}{
test_unzip/a.txt 946684800
test_unzip/b.txt 1000000000
test_unzip/c.txt 1111111000
}]
do_execsql_test 6.1 {
SELECT name, mtime, data FROM zipfile('test1.zip')
} {
a.txt 946684800 abc
b.txt 1000000000 abc
c.txt 1111111000 abc
| > > > > > > > > | 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 |
ORDER BY name
}
} [list {*}{
test_unzip/a.txt 946684800
test_unzip/b.txt 1000000000
test_unzip/c.txt 1111111000
}]
# fsdir() issue reported on the mailing list on 2018-03-14 by Jack Thaw.
do_test 6.0b {
db eval {
SELECT sum(name LIKE '%/a.txt')
FROM (VALUES(1),(2),(3)) CROSS JOIN fsdir('test_unzip')
}
} {3}
do_execsql_test 6.1 {
SELECT name, mtime, data FROM zipfile('test1.zip')
} {
a.txt 946684800 abc
b.txt 1000000000 abc
c.txt 1111111000 abc
|
| ︙ | ︙ |