René's URL Explorer Experiment


Title: bpo-44859: Raise more accurate exceptions in `sqlite3` by erlend-aasland · Pull Request #27695 · python/cpython · GitHub

Open Graph Title: bpo-44859: Raise more accurate exceptions in `sqlite3` by erlend-aasland · Pull Request #27695 · python/cpython

X Title: bpo-44859: Raise more accurate exceptions in `sqlite3` by erlend-aasland · Pull Request #27695 · python/cpython

Description: Improve exception compliancy with PEP 249 Raise InterfaceError instead of ProgrammingError for SQLITE_MISUSE. If SQLITE_MISUSE is raised, it is a sqlite3 module bug. Users of the sqlite3 module are not responsible of using the SQLite C API correctly. Don't overwrite BufferError with ValueError when conversion to BLOB fails. Raise ProgrammingError instead of Warning if user tries to execute() more than one SQL statement. Raise ProgrammingError instead of ValueError if an SQL query contains null characters. Make sure _pysqlite_set_result raises an exception if it returns -1. Fixes #89022

Open Graph Description: Improve exception compliancy with PEP 249 Raise InterfaceError instead of ProgrammingError for SQLITE_MISUSE. If SQLITE_MISUSE is raised, it is a sqlite3 module bug. Users of the sqlite3 module ar...

X Description: Improve exception compliancy with PEP 249 Raise InterfaceError instead of ProgrammingError for SQLITE_MISUSE. If SQLITE_MISUSE is raised, it is a sqlite3 module bug. Users of the sqlite3 module ar...

Opengraph URL: https://github.com/python/cpython/pull/27695

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:63f2f11b-8dfb-e0d6-e6cb-43e49d6c93b7
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idCFE2:32375B:512095:6CFAB3:6969B1A3
html-safe-nonceec95b008e28cbce2cc934af85ae021005e0678f2192cccbed5d1daf7727add6a
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDRkUyOjMyMzc1Qjo1MTIwOTU6NkNGQUIzOjY5NjlCMUEzIiwidmlzaXRvcl9pZCI6IjIwMDg5MjEyNjU5OTU4ODcwMTEiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmacaf94673832071f6fa036468f2fca404b2bcfedf9e699d06137ba000b9486371e
hovercard-subject-tagpull_request:706885478
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/python/cpython/pull/27695/files
twitter:imagehttps://avatars.githubusercontent.com/u/13780613?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/13780613?s=400&v=4
og:image:altImprove exception compliancy with PEP 249 Raise InterfaceError instead of ProgrammingError for SQLITE_MISUSE. If SQLITE_MISUSE is raised, it is a sqlite3 module bug. Users of the sqlite3 module ar...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Noneb23b8fcc855cd29bb04d6c94aafa62d336bf44eefa8229444eecc968cad03aee
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/python/cpython git https://github.com/python/cpython.git
octolytics-dimension-user_id1525981
octolytics-dimension-user_loginpython
octolytics-dimension-repository_id81598961
octolytics-dimension-repository_nwopython/cpython
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id81598961
octolytics-dimension-repository_network_root_nwopython/cpython
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release0672399d88424758731ec07fe24509e23bb17fb5
ui-targetcanary-1
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/python/cpython/pull/27695/files#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fcpython%2Fpull%2F27695%2Ffiles
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fcpython%2Fpull%2F27695%2Ffiles
Sign up https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=python%2Fcpython
Reloadhttps://github.com/python/cpython/pull/27695/files
Reloadhttps://github.com/python/cpython/pull/27695/files
Reloadhttps://github.com/python/cpython/pull/27695/files
python https://github.com/python
cpythonhttps://github.com/python/cpython
Please reload this pagehttps://github.com/python/cpython/pull/27695/files
Notifications https://github.com/login?return_to=%2Fpython%2Fcpython
Fork 33.9k https://github.com/login?return_to=%2Fpython%2Fcpython
Star 71.1k https://github.com/login?return_to=%2Fpython%2Fcpython
Code https://github.com/python/cpython
Issues 5k+ https://github.com/python/cpython/issues
Pull requests 2.1k https://github.com/python/cpython/pulls
Actions https://github.com/python/cpython/actions
Projects 31 https://github.com/python/cpython/projects
Security Uh oh! There was an error while loading. Please reload this page. https://github.com/python/cpython/security
Please reload this pagehttps://github.com/python/cpython/pull/27695/files
Insights https://github.com/python/cpython/pulse
Code https://github.com/python/cpython
Issues https://github.com/python/cpython/issues
Pull requests https://github.com/python/cpython/pulls
Actions https://github.com/python/cpython/actions
Projects https://github.com/python/cpython/projects
Security https://github.com/python/cpython/security
Insights https://github.com/python/cpython/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fpython%2Fcpython%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fpython%2Fcpython%2Fissues%2Fnew%2Fchoose
JelleZijlstrahttps://github.com/JelleZijlstra
python:mainhttps://github.com/python/cpython/tree/main
erlend-aasland:sqlite-errorshttps://github.com/erlend-aasland/cpython/tree/sqlite-errors
Conversation 18 https://github.com/python/cpython/pull/27695
Commits 16 https://github.com/python/cpython/pull/27695/commits
Checks 0 https://github.com/python/cpython/pull/27695/checks
Files changed https://github.com/python/cpython/pull/27695/files
Please reload this pagehttps://github.com/python/cpython/pull/27695/files
bpo-44859: Raise more accurate exceptions in sqlite3 https://github.com/python/cpython/pull/27695/files#top
Show all changes 16 commits https://github.com/python/cpython/pull/27695/files
0c8a88d bpo-44859: Raise InterfaceError iso. ProgrammingError for SQLITE_MISUSE Aug 9, 2021 https://github.com/python/cpython/pull/27695/commits/0c8a88d4e30b4bb0423ab98715ab43520d5231f1
aa755d2 Don't overwrite BufferErrors when converting to BLOB Aug 9, 2021 https://github.com/python/cpython/pull/27695/commits/aa755d23e3516e842ab99de08db36af4b267a168
e51d6c1 Raise ProgrammingError if user tries to execute() more than one state… Aug 9, 2021 https://github.com/python/cpython/pull/27695/commits/e51d6c14f144aaf05f0d9a8dc743ea49411db430
452ce40 Raise DataError if query contains null chars Aug 9, 2021 https://github.com/python/cpython/pull/27695/commits/452ce400a124fb6b5c7f1e52b94c534f179fc672
f9a5dc6 Add NEWS Aug 9, 2021 https://github.com/python/cpython/pull/27695/commits/f9a5dc61c1b86790c712302b97e4d7257448e0a0
b08d507 Merge branch 'main' into sqlite-errors Aug 30, 2021 https://github.com/python/cpython/pull/27695/commits/b08d50783652c9b5a4df4f7f64b7377822b78326
ddcab47 Merge branch 'main' into sqlite-errors Sep 14, 2021 https://github.com/python/cpython/pull/27695/commits/ddcab47cd255d6c99f41d8dea8788d108b8dfc0b
6d5361c Merge branch 'main' into sqlite-errors Sep 20, 2021 https://github.com/python/cpython/pull/27695/commits/6d5361c927e2848a0e9425879fc5b7059e4d5fa7
f2300bd _pysqlite_set_result() MUST set an exception if it returns -1 Sep 20, 2021 https://github.com/python/cpython/pull/27695/commits/f2300bdc541e480580a63e061af872181d97d78e
84af2b9 Merge branch 'main' into sqlite-errors Nov 1, 2021 https://github.com/python/cpython/pull/27695/commits/84af2b978c73469ca824bef345445cb8afe8fb62
d06b769 Merge branch 'main' into sqlite-errors Nov 10, 2021 https://github.com/python/cpython/pull/27695/commits/d06b7694b6f93615807a36ec158057a4579b65d4
8eb783e Merge branch 'main' into sqlite-errors Feb 26, 2022 https://github.com/python/cpython/pull/27695/commits/8eb783ecb1a29ea73374eb853709c0e2dbff96cd
d3186be Adapt GH-27642 tests Feb 26, 2022 https://github.com/python/cpython/pull/27695/commits/d3186be74fe98e7361ef7b0b228cce4b5369078b
b4a95bd Address review: add tests for PyObject_GetBuffer failures Feb 26, 2022 https://github.com/python/cpython/pull/27695/commits/b4a95bdb096d379bc1698778a1506537224ea660
3792cf0 Address reviews Mar 8, 2022 https://github.com/python/cpython/pull/27695/commits/3792cf0deb82d3aee60d9e2d691cf8539fd37e62
99c9040 Merge branch 'main' into sqlite-errors Mar 8, 2022 https://github.com/python/cpython/pull/27695/commits/99c9040235dafd714bbed78b624758f9696df0f1
Clear filters https://github.com/python/cpython/pull/27695/files
Please reload this pagehttps://github.com/python/cpython/pull/27695/files
Please reload this pagehttps://github.com/python/cpython/pull/27695/files
test_dbapi.py https://github.com/python/cpython/pull/27695/files#diff-8e2e6a9df72f1a10e817fcf22c760aebeabd549d12d1f6d4a921085462288e4b
test_regression.py https://github.com/python/cpython/pull/27695/files#diff-6af71e073b0de1bcd0234a65865bbd666b78a45b07cca473ff3a74002614ddbf
test_userfunctions.py https://github.com/python/cpython/pull/27695/files#diff-80e889411fc7bc8a3ef80de97a83b6f55f8ecade545aaaaa4fc109029e261fe0
2021-08-10-00-05-53.bpo-44859.9e9_3V.rst https://github.com/python/cpython/pull/27695/files#diff-9e885b2a1f95e1894873f9ba2ac651268f645c8c5ef4e1c82b2262ef7ad4c20d
connection.c https://github.com/python/cpython/pull/27695/files#diff-f405d0da477c184cd4afb94ce52dfd7fcd4980500a3a5ffe753d0e8cd57638a2
statement.c https://github.com/python/cpython/pull/27695/files#diff-517a9c73ccad12dd55f0beb930416fee87cade1b2abbb84a73ed8e39cc696c39
https://github.com/python/cpython/blob/main/.github/CODEOWNERS#L579
Lib/test/test_sqlite3/test_dbapi.pyhttps://github.com/python/cpython/pull/27695/files#diff-8e2e6a9df72f1a10e817fcf22c760aebeabd549d12d1f6d4a921085462288e4b
View file https://github.com/erlend-aasland/cpython/blob/99c9040235dafd714bbed78b624758f9696df0f1/Lib/test/test_sqlite3/test_dbapi.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/27695/{{ revealButtonHref }}
https://github.com/python/cpython/pull/27695/files#diff-8e2e6a9df72f1a10e817fcf22c760aebeabd549d12d1f6d4a921085462288e4b
https://github.com/python/cpython/pull/27695/files#diff-8e2e6a9df72f1a10e817fcf22c760aebeabd549d12d1f6d4a921085462288e4b
https://github.com/python/cpython/blob/main/.github/CODEOWNERS#L579
Lib/test/test_sqlite3/test_regression.pyhttps://github.com/python/cpython/pull/27695/files#diff-6af71e073b0de1bcd0234a65865bbd666b78a45b07cca473ff3a74002614ddbf
View file https://github.com/erlend-aasland/cpython/blob/99c9040235dafd714bbed78b624758f9696df0f1/Lib/test/test_sqlite3/test_regression.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/27695/{{ revealButtonHref }}
https://github.com/python/cpython/pull/27695/files#diff-6af71e073b0de1bcd0234a65865bbd666b78a45b07cca473ff3a74002614ddbf
https://github.com/python/cpython/pull/27695/files#diff-6af71e073b0de1bcd0234a65865bbd666b78a45b07cca473ff3a74002614ddbf
https://github.com/python/cpython/blob/main/.github/CODEOWNERS#L579
Lib/test/test_sqlite3/test_userfunctions.pyhttps://github.com/python/cpython/pull/27695/files#diff-80e889411fc7bc8a3ef80de97a83b6f55f8ecade545aaaaa4fc109029e261fe0
View file https://github.com/erlend-aasland/cpython/blob/99c9040235dafd714bbed78b624758f9696df0f1/Lib/test/test_sqlite3/test_userfunctions.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/27695/{{ revealButtonHref }}
https://github.com/python/cpython/pull/27695/files#diff-80e889411fc7bc8a3ef80de97a83b6f55f8ecade545aaaaa4fc109029e261fe0
https://github.com/python/cpython/pull/27695/files#diff-80e889411fc7bc8a3ef80de97a83b6f55f8ecade545aaaaa4fc109029e261fe0
https://github.com/python/cpython/pull/27695/files#diff-80e889411fc7bc8a3ef80de97a83b6f55f8ecade545aaaaa4fc109029e261fe0
https://github.com/python/cpython/pull/27695/files#diff-80e889411fc7bc8a3ef80de97a83b6f55f8ecade545aaaaa4fc109029e261fe0
https://github.com/python/cpython/pull/27695/files#diff-80e889411fc7bc8a3ef80de97a83b6f55f8ecade545aaaaa4fc109029e261fe0
https://github.com/python/cpython/pull/27695/files#diff-80e889411fc7bc8a3ef80de97a83b6f55f8ecade545aaaaa4fc109029e261fe0
Misc/NEWS.d/next/Library/2021-08-10-00-05-53.bpo-44859.9e9_3V.rsthttps://github.com/python/cpython/pull/27695/files#diff-9e885b2a1f95e1894873f9ba2ac651268f645c8c5ef4e1c82b2262ef7ad4c20d
View file https://github.com/erlend-aasland/cpython/blob/99c9040235dafd714bbed78b624758f9696df0f1/Misc/NEWS.d/next/Library/2021-08-10-00-05-53.bpo-44859.9e9_3V.rst
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/27695/{{ revealButtonHref }}
Please reload this pagehttps://github.com/python/cpython/pull/27695/files
https://github.com/python/cpython/blob/main/.github/CODEOWNERS#L580
Modules/_sqlite/connection.chttps://github.com/python/cpython/pull/27695/files#diff-f405d0da477c184cd4afb94ce52dfd7fcd4980500a3a5ffe753d0e8cd57638a2
View file https://github.com/erlend-aasland/cpython/blob/99c9040235dafd714bbed78b624758f9696df0f1/Modules/_sqlite/connection.c
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/27695/{{ revealButtonHref }}
https://github.com/python/cpython/pull/27695/files#diff-f405d0da477c184cd4afb94ce52dfd7fcd4980500a3a5ffe753d0e8cd57638a2
Please reload this pagehttps://github.com/python/cpython/pull/27695/files
https://github.com/python/cpython/pull/27695/files#diff-f405d0da477c184cd4afb94ce52dfd7fcd4980500a3a5ffe753d0e8cd57638a2
https://github.com/python/cpython/pull/27695/files#diff-f405d0da477c184cd4afb94ce52dfd7fcd4980500a3a5ffe753d0e8cd57638a2
https://github.com/python/cpython/blob/main/.github/CODEOWNERS#L580
Modules/_sqlite/statement.chttps://github.com/python/cpython/pull/27695/files#diff-517a9c73ccad12dd55f0beb930416fee87cade1b2abbb84a73ed8e39cc696c39
View file https://github.com/erlend-aasland/cpython/blob/99c9040235dafd714bbed78b624758f9696df0f1/Modules/_sqlite/statement.c
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/27695/{{ revealButtonHref }}
https://github.com/python/cpython/pull/27695/files#diff-517a9c73ccad12dd55f0beb930416fee87cade1b2abbb84a73ed8e39cc696c39
https://github.com/python/cpython/pull/27695/files#diff-517a9c73ccad12dd55f0beb930416fee87cade1b2abbb84a73ed8e39cc696c39
https://github.com/python/cpython/pull/27695/files#diff-517a9c73ccad12dd55f0beb930416fee87cade1b2abbb84a73ed8e39cc696c39
https://github.com/python/cpython/pull/27695/files#diff-517a9c73ccad12dd55f0beb930416fee87cade1b2abbb84a73ed8e39cc696c39
https://github.com/python/cpython/pull/27695/files#diff-517a9c73ccad12dd55f0beb930416fee87cade1b2abbb84a73ed8e39cc696c39
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.