matrixorigin / matrixorigin/matrixone
MySQL function not implemented: STATEMENT_DIGEST_TEXT
- Dominant language
- Go
- Stars
- 1.9k
- Forks
- 311
- Avg merge
- 1d 3h
- Merged PRs (30d)
- 768
Description
## Function Information
**Function Name**: `STATEMENT_DIGEST_TEXT`
**Category**: encryption
## MySQL Function Description
MySQL STATEMENT_DIGEST_TEXT function:
STATEMENT_DIGEST_TEXT(statement) - Returns the normalized statement digest as a string.
## Expected Behavior
Expected behavior:
According to MySQL documentation, the function should return correct results.
## Current Behavior in MatrixOne
This function is not implemented in MatrixOne.
**Error Message**: `(20105, "not supported: function or operator 'statement_digest_text'")`
## Test Case
```sql
SELECT STATEMENT_DIGEST_TEXT('SELECT 1') AS result1
```
## MySQL Documentation
- [MySQL Official Documentation](https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html#function_statement-digest-text)
## Request
Please implement the `STATEMENT_DIGEST_TEXT` function to improve MySQL compatibility.
Contributor guide
Assessment
This issue has not been assessed yet.