[
https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16808387#comment-16808387
]
Chunwei Lei edited comment on CALCITE-2965 at 4/3/19 5:51 AM:
--------------------------------------------------------------
[~julianhyde], I found that actually not all of these functions are Oracle
functions as follows.
* MySql[1]:soundex/space/repeat
* PostgreSQL[2][3]:soundex/difference/repeat
* Oracle[4]: soundex
* SQL Server[5]:soundex/space/replicate(similar to repeat)
It looks like we can treat soundex as standard function. What do you think
about it?
[1] https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
[2] https://www.postgre[5]sql.org/docs/9.1/fuzzystrmatch.html
[3] https://www.postgresql.org/docs/9.1/functions-string.html
[4] https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions155.htm
[5]
https://docs.microsoft.com/en-us/sql/t-sql/functions/string-functions-transact-sql?view=sql-server-2017
was (Author: chunwei lei):
[~julianhyde], I found that actually not all of these functions are Oracle
functions as follows.
* MySql[1]:soundex/space/repeat
* PostgreSQL[2][3]:soundex/difference/repeat
* Oracle[4]: soundex
* SQL Server[5]:soundex/space/replicate(similar to repeat)
It looks like we can treat soundex as standard function. What do you think
about it?
[1]https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
[2]https://www.postgresql.org/docs/9.1/fuzzystrmatch.html
[3]https://www.postgresql.org/docs/9.1/functions-string.html
[4]https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions155.htm
[5]https://docs.microsoft.com/en-us/sql/t-sql/functions/string-functions-transact-sql?view=sql-server-2017
> Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE
> --------------------------------------------------------------
>
> Key: CALCITE-2965
> URL: https://issues.apache.org/jira/browse/CALCITE-2965
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.19.0
> Reporter: Chunwei Lei
> Assignee: Chunwei Lei
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.20.0
>
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> Some string functions including REPEAT, SPACE, SOUNDEX, DIFFERENCE are not
> implemented now. It would be great if these functions can be implemented.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
