Update SQL client docs to show how to clear errors at the prompt

[rmloveland]

Richard Loveland (rmloveland) commented:

The SQL client can get into certain error states where the prompt looks like:

root@localhost:26257/? ERROR> 

The "solution" to clear the error from a user's point of view and return the client to a "normal" state is to issue a ROLLBACK.

We should update our SQL client docs to mention this, since some users may not know how to clear the error (it does not go away when you hit return AFAICT).

Related issues:

• cli: promote the 5-character error codes in the error outputs #6211
• Enable SQL Savepoints #5953 (Discovered while working on SAVEPOINT docs)

Jira Issue: DOC-455

[github-actions]

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB docs!

[github-actions]

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB docs!