1122717 - (SQLite3.8.8.1) Upgrade to SQLite 3.8.8.1

Status: RESOLVED FIXED

(Toolkit :: Storage, defect)

Description

[Ryan VanderMeulen [:RyanVM]]

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



    SQLite version 3.8.8 is a regularly schedule maintenance release of SQLite.

    There are no dramatic new features or performance enhancements in this release, merely incremental improvements. Most of the performance gain in this release comes from refactoring the B-Tree rebalancing logic to avoid unnecessary memcpy() operations. New features include the PRAGMA data_version statement and the ability to accept a VALUES clause with no arbitrary limit on the number of rows. Several obscure bugs have been fixed, including some multithreading races and a work-around for a compiler bug on some Macs.

    See the change log for a longer list of enhancements and bug fixes.

Comment 1

[Ryan VanderMeulen [:RyanVM]]

Try run to see what if anything it does for our Windows test crashes:
https://treeherder.mozilla.org/#/jobs?repo=try&revision=73ce05ab3ae0

Comment 2

[Ryan VanderMeulen [:RyanVM]]

(In reply to Ryan VanderMeulen [:RyanVM UTC-5] from comment #1)

Doesn't appear to help with the Windows bc2 crashes :(

Full Try run for the sake of rubberstamping a landing anyway:
https://treeherder.mozilla.org/#/jobs?repo=try&revision=ebf1339b7b46

Comment 3

[Ryan VanderMeulen [:RyanVM]]

Attachment: Upgrade to SQLite 3.8.8

Comment 4

[Marco Bonardo [:mak]]

even if it doesn't contain a bug that affects us, 3.8.8.1 should be out today-ish, let's just take that.

Comment 5

[Ryan VanderMeulen [:RyanVM]]

http://sqlite.org/releaselog/3_8_8_1.html

Within hours of releasing version 3.8.8, a bug was reported against the 10-month-old 3.8.4 release. As that bug exists in all subsequent releases, the decision was made to issue a small patch to the 3.8.8 before it came into widespread use.

SQLite Release 3.8.8.1 On 2015-01-20 (3.8.8.1)
* Fix a bug in the sorting logic, present since version 3.8.4, that can cause output to appear in the wrong order on queries that contains an ORDER BY clause, a LIMIT clause, and that have approximately 60 or more columns in the result set. Ticket f97c4637102a3ae72b79.

Comment 6

[Ryan VanderMeulen [:RyanVM]]

Attachment: Upgrade to SQLite 3.8.8.1

Comment 7

[Ryan VanderMeulen [:RyanVM]]

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

Comment 8

[Ryan VanderMeulen [:RyanVM]]

https://hg.mozilla.org/integration/mozilla-inbound/rev/b115b01adfb2

Comment 9

[Ryan VanderMeulen [:RyanVM]]

https://hg.mozilla.org/mozilla-central/rev/b115b01adfb2