Upgrade to SQLite v3.32 in Windows and macOS builds

[erlend-aasland]

BPO	40741
Nosy	@pfmoore, @ronaldoussoren, @tjguk, @ned-deily, @zware, @zooba, @miss-islington, @erlend-aasland
PRs	bpo-40741: Update Windows installer to use SQLite 3.32.2 #20520 bpo-40741: Update macOS installer to use SQLite 3.32.2. #20705 [3.9] bpo-40741: Update macOS installer to use SQLite 3.32.2. (GH-20705) #20706 [3.8] bpo-40741: Update macOS installer to use SQLite 3.32.2. (GH-20705) #20707 [3.7] bpo-40741: Update macOS installer to use SQLite 3.32.2. (GH-20705) #20708 bpo-40741: Update macOS installer to use SQLite 3.32.3 #20979 [3.9] bpo-40741: Update macOS installer to use SQLite 3.32.3 (GH-20979) #21554 [3.8] bpo-40741: Update macOS installer to use SQLite 3.32.3 (GH-20979) #21555 bpo-40741: Update Windows build to include SQLite 3.32.3 #21570 [3.9] bpo-40741: Update Windows build to include SQLite 3.32.3 (GH-21570) #21571 [3.8] bpo-40741: Update Windows build to include SQLite 3.32.3 (GH-21570) #21572

^{Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.}

Show more details

GitHub fields:

assignee = None
closed_at = <Date 2020-07-20.23:20:13.471>
created_at = <Date 2020-05-23.10:32:38.032>
labels = ['OS-mac', '3.10', '3.8', '3.9', 'OS-windows']
title = 'Upgrade to SQLite v3.32 in Windows and macOS builds'
updated_at = <Date 2020-07-21.00:10:35.735>
user = 'https://github.com/erlend-aasland'

bugs.python.org fields:

activity = <Date 2020-07-21.00:10:35.735>
actor = 'miss-islington'
assignee = 'none'
closed = True
closed_date = <Date 2020-07-20.23:20:13.471>
closer = 'steve.dower'
components = ['macOS', 'Windows']
creation = <Date 2020-05-23.10:32:38.032>
creator = 'erlendaasland'
dependencies = []
files = []
hgrepos = []
issue_num = 40741
keywords = ['patch']
message_count = 21.0
messages = ['369711', '369915', '370056', '370075', '370332', '370333', '370851', '370949', '370950', '370951', '370952', '371876', '373017', '373985', '373987', '373988', '374032', '374033', '374035', '374038', '374039']
nosy_count = 9.0
nosy_names = ['paul.moore', 'ronaldoussoren', 'tim.golden', 'ned.deily', 'zach.ware', 'steve.dower', 'Big Stone', 'miss-islington', 'erlendaasland']
pr_nums = ['20520', '20705', '20706', '20707', '20708', '20979', '21554', '21555', '21570', '21571', '21572']
priority = 'normal'
resolution = 'fixed'
stage = 'resolved'
status = 'closed'
superseder = None
type = None
url = 'https://bugs.python.org/issue40741'
versions = ['Python 3.8', 'Python 3.9', 'Python 3.10']

[erlend-aasland]

SQLite 3.32.0 is out: https://www.sqlite.org/releaselog/3_32_0.html

I'll preparing a PR for cpython-source-deps and cpython.

[erlend-aasland]

Patch release is out now: https://www.sqlite.org/releaselog/3_32_1.html

[ned-deily]

Note: bpo-40784 documents a test failure introduced by running with v3.32+.

[erlend-aasland]

Ready with PR as soon as #64647 is merged and cpython-source-deps (python/cpython-source-deps#19) is merged and tagged.

[zooba]

I've checked and merged the cpython-source-deps update. (For everyone's info, I downloaded the sources myself and checked hashes/etc. as per normal, even though I eventually merged the PR and tagged it manually.)

[erlend-aasland]

Thanks, Steve!

[erlend-aasland]

SQLite 3.32.2 is out: https://www.sqlite.org/releaselog/3_32_2.html

From the changelog:
Fix a long-standing bug in the byte-code engine that can cause a COMMIT command report as success when in fact it failed to commit. Ticket 810dc8038872e212

I've created a PR for cpython-source-deps.

[ned-deily]

New changeset 37eed5a by Ned Deily in branch 'master':
bpo-40741: Update macOS installer to use SQLite 3.32.2. (GH-20705)
37eed5a

[miss-islington]

New changeset d1c449a by Miss Islington (bot) in branch '3.7':
bpo-40741: Update macOS installer to use SQLite 3.32.2. (GH-20705)
d1c449a

[miss-islington]

New changeset 1e72fb2 by Miss Islington (bot) in branch '3.9':
bpo-40741: Update macOS installer to use SQLite 3.32.2. (GH-20705)
1e72fb2

[miss-islington]

New changeset 264e4fd by Miss Islington (bot) in branch '3.8':
bpo-40741: Update macOS installer to use SQLite 3.32.2. (GH-20705)
264e4fd

[erlend-aasland]

FYI, 3.32.3 is out now: https://sqlite.org/releaselog/3_32_3.html
I'll update the PR and push a new PR for source deps right away.

[BigStone]

hello,

Python-3.8.4rc1 and Python-3.9.0b4 are still with SQLite-3.31.1.

Is it expected ?

[ned-deily]

New changeset 7cf1cb3 by Erlend Egeberg Aasland in branch 'master':
bpo-40741: Update macOS installer to use SQLite 3.32.3 (GH-20979)
7cf1cb3

[miss-islington]

New changeset 2fbb0d8 by Miss Islington (bot) in branch '3.9':
bpo-40741: Update macOS installer to use SQLite 3.32.3 (GH-20979)
2fbb0d8

[miss-islington]

New changeset 892fc8d by Miss Islington (bot) in branch '3.8':
bpo-40741: Update macOS installer to use SQLite 3.32.3 (GH-20979)
892fc8d

[zooba]

Python-3.8.4rc1 and Python-3.9.0b4 are still with SQLite-3.31.1.

Someone still had to send a PR to update the main build. It's not automatic, otherwise you wouldn't be able to reproduce older builds.

I'll do it now. It'll be in 3.8.6 and 3.9.0b6.

[zooba]

New changeset 84761c3 by Steve Dower in branch 'master':
bpo-40741: Update Windows build to include SQLite 3.32.3 (GH-21570)
84761c3

[zooba]

Closing this one now.

Let's use a new issue next time there's a need to update SQLite.

[miss-islington]

New changeset f599f9e by Miss Islington (bot) in branch '3.8':
bpo-40741: Update Windows build to include SQLite 3.32.3 (GH-21570)
f599f9e

[miss-islington]

New changeset d6ba8c8 by Miss Islington (bot) in branch '3.9':
bpo-40741: Update Windows build to include SQLite 3.32.3 (GH-21570)
d6ba8c8