Provide constants for SQL error codes
Open
Nobody has claimed this yet.
enhancement
- Dominant language
- JavaScript
- Stars
- 322
- Forks
- 99
- PR merge metrics
- No merged PRs in 30d
Description
SQL errors returned by HANA contain a code, e.g.
{ [Error: invalid table name: Could not find table/view CURRENTVERSION in schema SYS_XS_SBSS: line 1 col 27 (at pos 26)]
message: 'invalid table name: Could not find table/view CURRENTVERSION in schema SYS_XS_SBSS: line 1 col 27 (at pos 26)',
code: 259,
sqlState: 'HY000',
level: 1,
position: 26 }
Sometimes it is necessary to check the error code programmatically. Then it would be useful to have meaningful constants for those numeric codes, e.g.
const ERR_SQL_INV_TABLE = 259;
SQL Error Codes are documented in SAP HANA SQL Reference.
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 the SAP HANA SQL Error Codes reference linked in the issue, then inspect the repository for how database errors and exported constants are organized. Clarify which codes and naming scheme are in scope; done means the selected SQL error codes are exposed as meaningful constants and can be used programmatically.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript, node.js
- Domain
- database
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100