﻿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
30595	sqlsequencereset should inform that no sequences found.	Keryn Knight	Hasan Ramezani	"This just came up on IRC, because someone was expecting `sqlsequencereset` to provide resets for the auto-increment values for an SQLite table.

Running `python manage.py sqlsequencereset <myapp>` provides no output if there are no results returned by `connection.ops.sequence_reset_sql` (see [https://github.com/django/django/blob/26d16c07fdc4a297daca554afa6375c70d6d82a9/django/core/management/commands/sqlsequencereset.py#L23 here])
So the user has no idea if it failed, succeeded, or they got the invocation wrong (assuming they're not familiar enough with Django to know that invoking it wrong will raise a `CommandError`).

I'd suggest it should avoid ambiguity, so if `len(statements) == 0` it should raise `CommandError` and say there's nothing to do. Bonus points if it also sniffs the connection backend to know if there is anything it **could** do, and if there's not, report that `sqlsequencereset` isn't necessary/available for that backend."	Cleanup/optimization	closed	Core (Management commands)	dev	Normal	fixed			Accepted	1	0	0	0	1	0
