Built-in function SOUNDEX not supported

[jackysp]

Please answer these questions before submitting your issue. Thanks!

1. What did you do?

create table t1 (id integer, a varchar(100) character set utf8 collate utf8_unicode_ci); 
insert into t1 values (1, 'Test');    
select * from t1 where soundex(a) = soundex('Test');

2. What did you expect to see?

+------+------+
| id   | a    |
+------+------+
|    1 | Test |
+------+------+
1 row in set (0.01 sec)

3. What did you see instead?

ERROR 1105 (HY000): line 0 column 31 near "a) = soundex('Test')" (total length 51)

4. What version of TiDB are you using (tidb-server -V)?

[morgo]

This function is not an immediate priority, but it could be useful for claiming 100% compatibility with MySQL string functions. Open for contributors :-)

[ghost]

Against master:

DROP TABLE IF EXISTS t1;
create table t1 (id integer, a varchar(100) character set utf8 collate utf8_unicode_ci); 
insert into t1 values (1, 'Test');    
select * from t1 where soundex(a) = soundex('Test');

..

mysql> select * from t1 where soundex(a) = soundex('Test');
ERROR 1305 (42000): FUNCTION test.soundex does not exist
mysql> SELECT tidb_version()\G
*************************** 1. row ***************************
tidb_version(): Release Version: v4.0.0-beta.2-852-g1e7454c81
Edition: Community
Git Commit Hash: 1e7454c81d1f4fae464e835d1a4023a911cfa87b
Git Branch: master
UTC Build Time: 2020-07-28 01:36:23
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
1 row in set (0.00 sec)

[clark1013]

/assign

[Alkaagr81]

Its not on priority but added for documentation. sounds like is an alias for soundex()

Select WEEKOFYEAR(LEAD(('5183-10-18 06:15:35.076079')SOUNDS LIKE(0x9E335D89),68)OVER());

In TIDB

mysql> Select WEEKOFYEAR(LEAD(('5183-10-18 06:15:35.076079')SOUNDS LIKE(0x9E335D89),68)OVER());
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 59 near "SOUNDS LIKE(0x9E335D89),68)OVER())" 

In Mysql

mysql> Select WEEKOFYEAR(LEAD(('5183-10-18 06:15:35.076079')SOUNDS LIKE(0x9E335D89),68)OVER());
+----------------------------------------------------------------------------------+
| WEEKOFYEAR(LEAD(('5183-10-18 06:15:35.076079')SOUNDS LIKE(0x9E335D89),68)OVER()) |
+----------------------------------------------------------------------------------+
|                                                                             NULL |
+----------------------------------------------------------------------------------+
1 row in set (0.00 sec)