1091076 - (SQLite3.8.7.1) Upgrade to SQLite 3.8.7.1

Status: RESOLVED FIXED

(Toolkit :: Storage, defect)

Description

[Marco Bonardo [:mak] (Away Apr 25 - May 5)]

+++ This bug was initially created as a clone of Bug #1084437 +++

2014-10-30 - Release 3.8.7.1

Version 3.8.7.1 of SQLite is recommended for all new development. Upgrading from all other versions of SQLite is recommended.

In PRAGMA journal_mode=TRUNCATE mode, call fsync() immediately after truncating the journal file to ensure that the transaction is durable across a power loss.

Fix an assertion fault that can occur when updating the NULL value of a field at the end of a table that was added using ALTER TABLE ADD COLUMN.

Do not attempt to use the strchrnul() function from the standard C library unless the HAVE_STRCHRNULL compile-time option is set.

Fix a couple of problems associated with running an UPDATE or DELETE on a VIEW with a rowid in the WHERE clause. 

See also bug 1084437

Comment 1

[Ryan VanderMeulen [:RyanVM]]

Attachment: Upgrade to SQLite 3.8.7.1 - Mozilla changes

https://treeherder.mozilla.org/ui/#/jobs?repo=try&revision=ea20366eeeec

Comment 2

[Marco Bonardo [:mak] (Away Apr 25 - May 5)]

Comment on attachment 8514970 [details] [diff] [review]
Upgrade to SQLite 3.8.7.1 - Mozilla changes

Review of attachment 8514970 [details] [diff] [review]:
-----------------------------------------------------------------

thank you.

Comment 3

[Ryan VanderMeulen [:RyanVM]]

https://hg.mozilla.org/integration/mozilla-inbound/rev/910d4f759d20
https://hg.mozilla.org/integration/mozilla-inbound/rev/c3dc65809f11

Comment 4

[Wes Kocher (:KWierso) (Not reading bugmail; email directly if needed)]

https://hg.mozilla.org/mozilla-central/rev/910d4f759d20
https://hg.mozilla.org/mozilla-central/rev/c3dc65809f11

Comment 5

[Arthur K. (he/him)]

3.8.7.2 has now been released.

Comment 6

[Ryan VanderMeulen [:RyanVM]]

See the deps of this bug.