matrixorigin / matrixorigin/matrixone

MySQL function not implemented: SOUNDS LIKE

Open
#23,010 1 comment 0 reactions 1 assignee Claimed by @gouhongshen View on GitHub
ai-easy 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**: `SOUNDS LIKE`
**Category**: operators

## MySQL Function Description
MySQL SOUNDS LIKE operator:
Sounds like operator

## Expected Behavior
Expected behavior:
According to MySQL documentation, the operator should return correct results.

## Current Behavior in MatrixOne
This function is not implemented in MatrixOne.

**Error Message**: `(1064, 'SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 26 near " `

## Test Case
```sql
SELECT 'Hello' SOUNDS LIKE 'Hallo' AS result1
```

## MySQL Documentation
- [MySQL Official Documentation](https://dev.mysql.com/doc/refman/8.4/en/string-functions.html#operator_sounds-like)

## Request
Please implement the `SOUNDS LIKE` 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.