You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/09/10 06:22:32 UTC
[GitHub] [incubator-doris] qidaye opened a new issue #6604: [Bug] `replace` function incorrect
qidaye opened a new issue #6604:
URL: https://github.com/apache/incubator-doris/issues/6604
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
trunk version , commit_id = `2c58724c84021ae5c9fdd5ba304808b1e79191d4`
### What's Wrong?
The `replace` function cannot replace corecctly when the old substring is at the beginning of the original string.
```sql
MySQL [(none)]> select replace('http://www.baidu.com:9090','http', 'ftp');
+-----------------------------------------------------+
| replace('http://www.baidu.com:9090', 'http', 'ftp') |
+-----------------------------------------------------+
| http://www.baidu.com:9090 |
+-----------------------------------------------------+
1 row in set (0.034 sec)
```
### What You Expected?
The correct result is :
```sql
mysql> select replace('http://www.baidu.com:9090','http', 'ftp');
+-----------------------------------------------------+
| replace('http://www.baidu.com:9090', 'http', 'ftp') |
+-----------------------------------------------------+
| ftp://www.baidu.com:9090 |
+-----------------------------------------------------+
1 row in set (0.02 sec)
```
### How to Reproduce?
```sql
MySQL [(none)]> select replace('http://www.baidu.com:9090','http', 'ftp');
+-----------------------------------------------------+
| replace('http://www.baidu.com:9090', 'http', 'ftp') |
+-----------------------------------------------------+
| http://www.baidu.com:9090 |
+-----------------------------------------------------+
1 row in set (0.034 sec)
```
### Anything Else?
_No response_
### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] yangzhg closed issue #6604: [Bug] `replace` function incorrect
Posted by GitBox <gi...@apache.org>.
yangzhg closed issue #6604:
URL: https://github.com/apache/incubator-doris/issues/6604
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] CraftLCL commented on issue #6604: [Bug] `replace` function incorrect
Posted by GitBox <gi...@apache.org>.
CraftLCL commented on issue #6604:
URL: https://github.com/apache/incubator-doris/issues/6604#issuecomment-916757584
try use regexp_replace select regexp_replace('http://www.baidu.com:9090','http', 'ftp') .
The replace function is not mentioned in the documentation.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] qidaye commented on issue #6604: [Bug] `replace` function incorrect
Posted by GitBox <gi...@apache.org>.
qidaye commented on issue #6604:
URL: https://github.com/apache/incubator-doris/issues/6604#issuecomment-917793052
> try use regexp_replace select regexp_replace('http://www.baidu.com:9090','http', 'ftp') .
They are different functions.
> The replace function is not mentioned in the documentation.
The docmentation of `replace` function already exists. But it is not showing in the side bar of doc website.
I'll fix it.
Besides, you also can see the help contents by command `help replcace`.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org