[issue19450] Bug in sqlite in Windows binaries

Roundup Robot added the comment: New changeset fa68df1d5e65 by Steve Dower in branch '2.7': Issue #19450: Update Windows builds to use SQLite 3.8.11.0. https://hg.python.org/cpython/rev/fa68df1d5e65 -- ___ Python tracker

[issue19450] Bug in sqlite in Windows binaries

Steve Dower added the comment: Done. The test_sqlite tests were fine, but that's all I checked. -- resolution: -> fixed status: open -> closed ___ Python tracker

[issue19450] Bug in sqlite in Windows binaries

Benjamin Peterson added the comment: Let's make Windows use the same version as the Mac installer. -- assignee: benjamin.peterson -> steve.dower ___ Python tracker

[issue19450] Bug in sqlite in Windows binaries

Changes by Mark Lawrence : -- nosy: -BreamoreBoy ___ Python tracker ___ ___

[issue19450] Bug in sqlite in Windows binaries

Steve Dower added the comment: Assigning to Benjamin to make the call for 2.7. Either close or assign it back if you want the update. -- assignee: steve.dower -> benjamin.peterson versions: -Python 3.5, Python 3.6 ___ Python tracker

[issue19450] Bug in sqlite in Windows binaries

Marc Schlaich added the comment: This wasn't decided yet for 2.7 so I'm reopening it until a decision is made. I'm still +1 for an update to 3.8.3.1 on Windows so that this is on par with the version on OSX and the version in Python 3. -- resolution: fixed -> status: closed -> open

[issue19450] Bug in sqlite in Windows binaries

Changes by Steve Dower steve.do...@microsoft.com: -- resolution: - fixed stage: - resolved status: open - closed ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450 ___

[issue19450] Bug in sqlite in Windows binaries

Roundup Robot added the comment: New changeset 33dbcde76b3f by Ned Deily in branch '3.4': Issue #19450: Update OS X installer builds to use SQLite 3.8.11. https://hg.python.org/cpython/rev/33dbcde76b3f New changeset ebe72984c1b9 by Ned Deily in branch '3.5': Issue #19450: merge from 3.4

[issue19450] Bug in sqlite in Windows binaries

Steve Dower added the comment: Updating to 3.8.11.0 now. -- ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450 ___ ___ Python-bugs-list mailing

[issue19450] Bug in sqlite in Windows binaries

Marc Schlaich added the comment: I'm still +1 for an update in 2.7 as there are a lot of important bug fixes and a new SQLite version is 100% backwards compatible for my medium to big size (SQLAlchemy) SQLite applications. -- ___ Python tracker

[issue19450] Bug in sqlite in Windows binaries

Roundup Robot added the comment: New changeset 1003746ee7a0 by Steve Dower in branch '3.4': Issue #19450: Update Windows builds to use SQLite 3.8.11.0 https://hg.python.org/cpython/rev/1003746ee7a0 New changeset 4b37e81fcc54 by Steve Dower in branch '3.5': Issue #19450: Update Windows builds to

[issue19450] Bug in sqlite in Windows binaries

Steve Dower added the comment: Looks like Python 2.7 is still on SQLite 3.6.21, so the RM (Benjamin) will have to make a call on whether we take the upgrade. -- ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450

[issue19450] Bug in sqlite in Windows binaries

Brett Cannon added the comment: Apparently we are shipping an old version in 3.5b4 (3.8.3.1 and the latest release is 3.11), so this should probably be upgraded before rc. -- nosy: +brett.cannon versions: +Python 3.5 ___ Python tracker

[issue19450] Bug in sqlite in Windows binaries

Steve Dower added the comment: I agree, and I know that backwards compatibility is a very high priority especially now that SQLite is shipping as part of Windows 10. While we *could* take a dependency on this binary (winsqlite3.dll, for those who have it), I don't think it's actually any

[issue19450] Bug in sqlite in Windows binaries

Zachary Ware added the comment: I'm ambivalent on whether to do it, but Marc is right that it's just a version update in Tools/buildbot/external-common.bat and PCbuild/pyproject.vsprops. -- assignee: - steve.dower ___ Python tracker

[issue19450] Bug in sqlite in Windows binaries

Marc Schlaich added the comment: I've now run various and partially complex applications including SQLAlchemy against SQLite 3.8.1 for months without having any issues. Right now I have run extensive database test suites against the current SQLite release 3.8.6 without any issues, too. So I

[issue19450] Bug in sqlite in Windows binaries

Antoine Pitrou added the comment: Steve is responsible for the Windows builds, but he always answered to your request above. -- nosy: +pitrou ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450

[issue19450] Bug in sqlite in Windows binaries

Mark Lawrence added the comment: A work around is already given in msg201796 and is reinforced by this https://mail.python.org/pipermail/python-list/2014-October/679369.html -- nosy: +zach.ware ___ Python tracker rep...@bugs.python.org

[issue19450] Bug in sqlite in Windows binaries

Marc Schlaich added the comment: Yes, but this is no practical solution. Telling *all* my clients to update the sqlite3.dll after *every* Python update is just not feasible and will just not work out in practice. What would be the required steps to update the *.dll in the build? Just update

[issue19450] Bug in sqlite in Windows binaries

Antoine Pitrou added the comment: The main risk is if SQLite 3.8 changes some behaviours compared to older versions. This is why we generally choose to only apply bugfix releases of external libraries in our owbn bugfix branches. The question is whether this issue can be worked around without

[issue19450] Bug in sqlite in Windows binaries

Marc Schlaich added the comment: Well, OSX release ships with 3.8.3.1, too: https://hg.python.org/cpython/file/2.7/Mac/BuildScript/build-installer.py#l290 -- ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450

[issue19450] Bug in sqlite in Windows binaries

Antoine Pitrou added the comment: As I said, I think it's really Steve's choice here (as long as he is doing the Windows release builds). -- ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450

[issue19450] Bug in sqlite in Windows binaries

Steve Dower added the comment: I don't know enough about the SQLite API to determine whether we can safely upgrade from 3.6.21 in Python 2.7, but since this doesn't appear to be a security issue I don't see any solid justification for doing it anyway. If someone else does it, I'll build it,

[issue19450] Bug in sqlite in Windows binaries

Ned Deily added the comment: IMO, what third-party libraries are included with the Windows and OS X binary installers, what versions of them, and when to update them are questions without firm established policy answers, say in a PEP. In many ways, for the installers we are performing the

[issue19450] Bug in sqlite in Windows binaries

Changes by Steve Dower steve.do...@microsoft.com: -- nosy: +benjamin.peterson ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450 ___ ___

[issue19450] Bug in sqlite in Windows binaries

Martin v. Löwis added the comment: I don't maintain Python 2.7 anymore, so removing myself. -- ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450 ___

[issue19450] Bug in sqlite in Windows binaries

Changes by Martin v. Löwis mar...@v.loewis.de: -- nosy: -loewis ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450 ___ ___ Python-bugs-list

[issue19450] Bug in sqlite in Windows binaries

Changes by Berker Peksag berker.pek...@gmail.com: -- nosy: +steve.dower ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450 ___ ___

[issue19450] Bug in sqlite in Windows binaries

Mark Lawrence added the comment: FYI 3.4.0 Windows was shipped with SQLite 3.8.3.1 see #20465. -- nosy: +BreamoreBoy ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450 ___

[issue19450] Bug in sqlite in Windows binaries

Martin v. Löwis added the comment: It's certainly possible to update SQLite without rebuilding Python. Just replace sqlite3.dll with a newer version. -- ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450

[issue19450] Bug in sqlite in Windows binaries

Marc Schlaich added the comment: Ah that's great. The issue is resolved with SQLite 3.8.1. However, would be great if a newer SQLite version comes already bundled with Python. -- ___ Python tracker rep...@bugs.python.org

[issue19450] Bug in sqlite in Windows binaries

New submission from Marc Schlaich: My System: $ python Python 2.7.5 (default, May 15 2013, 22:43:36) [MSC v.1500 32 bit (Intel)] on win32 Type help, copyright, credits or license for more information. import sqlite3 sqlite3.version '2.6.0' sqlite3.sqlite_version '3.6.21' Test Script:

[issue19450] Bug in sqlite in Windows binaries

Changes by Ned Deily n...@acm.org: -- components: +Build, Windows -Extension Modules nosy: +loewis ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue19450 ___