Add docs for SQLSTATE
Open
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 617
- Forks
- 724
- Avg merge
- 2d 10h
- Merged PRs (30d)
- 223
Description
mysql> SELECT abc;
ERROR 1054 (42S22): Unknown column 'abc' in 'field list'
Here 42S22 is in the 42000 class that means "syntax error or access rule violation".
See also https://github.com/pingcap/tidb/blob/master/pkg/parser/mysql/state.go
Suggestion:
- Have a list of SQLSTATE categories
- Have a list of SQLSTATE codes used in TiDB
- Link on https://docs.pingcap.com/tidb/stable/error-codes and elsewhere where appropriate
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with pkg/parser/mysql/state.go to identify the SQLSTATE codes used in TiDB, then review the error-codes documentation page and related links. Document the SQLSTATE categories and TiDB-used codes, and link the new material from the error-codes page and other appropriate locations.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, documentation
- Issue type
- Documentation
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100