sqlite3 context manager does not close in-memory database

[pnsaevik]

Bug report

Bug description:

import sqlite3

with sqlite3.connect(':memory:') as conn:
    pass

Run code with "python -Werror myscript.py" to reproduce

The following does not raise a warning:

import sqlite3

conn = sqlite3.connect(':memory:')
conn.close()

The bug is not present in python 3.12 since no warnings are raised on unclosed sqlite databases before 3.13

CPython versions tested on:

3.13

Operating systems tested on:

Windows

[erlend-aasland]

The sqlite3 context manager is not a closing context manager. See the docs for details:

• https://docs.python.org/3/library/sqlite3.html#how-to-use-the-connection-context-manager

[pnsaevik]

I had no idea, thanks. I've gotten too used to closing context managers I guess.