id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
32445	LiveServerThreadTest.test_closes_connections() doesn't pass with non-in-memory SQLite	Chris Jerdonek	Chris Jerdonek	"I noticed that `LiveServerThreadTest.test_closes_connections()` doesn't seem to pass when using non-in-memory SQLite. It's only configured to be skipped [https://github.com/django/django/blob/3fa1ed53be370f4b1a94d78b56ff30d23b131623/django/db/backends/sqlite3/features.py#L75-L81 for in-memory SQLite]. It doesn't pass because the test has the [https://github.com/django/django/blob/3fa1ed53be370f4b1a94d78b56ff30d23b131623/tests/servers/test_liveserverthread.py#L24 following line]:

{{{#!python
self.assertFalse(conn.is_usable())
}}}

But SQLite's `is_usable()` has a hard-coded return value of `True`:
https://github.com/django/django/blob/3fa1ed53be370f4b1a94d78b56ff30d23b131623/django/db/backends/sqlite3/base.py#L387-L388

I guess this means that Django's CI doesn't check non-in-memory SQLite. If it's true that Django doesn't check this case, I'm not sure if that means it doesn't need to be fixed.
"	Cleanup/optimization	closed	Testing framework	3.1	Normal	fixed	SQLite,is_usable,LiveServerThread		Ready for checkin	1	0	0	0	0	0