matrixorigin / matrixorigin/matrixone

MySQL function not implemented: STATEMENT_DIGEST_TEXT

Open
#23,025 1 comment 0 reactions 1 assignee Claimed by @Lundomn View on GitHub
ai-easy deferred kind/compatibility priority/p0
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.