You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by zy...@apache.org on 2023/06/08 17:43:09 UTC
[doris] branch master updated: [typo](fix)Fixed documentation for some string functions (#20598)
This is an automated email from the ASF dual-hosted git repository.
zykkk pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 6afb09e7ba [typo](fix)Fixed documentation for some string functions (#20598)
6afb09e7ba is described below
commit 6afb09e7ba6ac6aad1cc8df0ca00c60ed628f547
Author: bingquanzhao <bi...@icloud.com>
AuthorDate: Fri Jun 9 01:43:01 2023 +0800
[typo](fix)Fixed documentation for some string functions (#20598)
---
.../sql-functions/string-functions/field.md | 25 +++++++++++++++++-
.../sql-functions/string-functions/ucase.md | 2 +-
.../sql-functions/string-functions/field.md | 30 +++++++++++++++++++---
.../sql-functions/string-functions/ucase.md | 2 +-
4 files changed, 53 insertions(+), 6 deletions(-)
diff --git a/docs/en/docs/sql-manual/sql-functions/string-functions/field.md b/docs/en/docs/sql-manual/sql-functions/string-functions/field.md
index 8cb88c75b9..a907df5383 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/field.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/field.md
@@ -55,7 +55,6 @@ mysql> select k1,k7 from baseall where k1 in (1,2,3) order by field(k1,2,1,3);
| 1 | wangjing04 |
| 3 | yuanyuan06 |
+------+------------+
-3 rows in set (0.02 sec)
mysql> select class_name from class_test order by field(class_name,'Suzi','Ben','Henry');
+------------+
@@ -69,6 +68,30 @@ mysql> select class_name from class_test order by field(class_name,'Suzi','Ben',
| Henry |
+------------+
+mysql> select class_name from class_test order by field(class_name,'Suzi','Ben','Henry') desc;
++------------+
+| class_name |
++------------+
+| Henry |
+| Henry |
+| Ben |
+| Ben |
+| Suzi |
+| Suzi |
++------------+
+
+mysql> select class_name from class_test order by field(class_name,'Suzi','Ben','Henry') nulls first;
++------------+
+| class_name |
++------------+
+| null |
+| Suzi |
+| Suzi |
+| Ben |
+| Ben |
+| Henry |
+| Henry |
++------------+
```
### keywords
field
diff --git a/docs/en/docs/sql-manual/sql-functions/string-functions/ucase.md b/docs/en/docs/sql-manual/sql-functions/string-functions/ucase.md
index dc1975e52a..5ffa7c996f 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/ucase.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/ucase.md
@@ -28,7 +28,7 @@ under the License.
### description
#### Syntax
-`INT ucase(VARCHAR str)`
+`VARCHAR ucase(VARCHAR str)`
Convert all strings in parameters to uppercase. Another alias for this function is [upper](./upper.md).
diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/field.md b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/field.md
index 40c8a42b6f..6bb1ad5e1d 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/field.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/field.md
@@ -38,8 +38,8 @@ field
`field(Expr e, param1, param2, param3,.....)`
在order by子句中,可以使用自定义排序,可以将expr中的数据按照指定的param1,2,3顺序排列。
-不在param参数中的数据不会参与排序,将会放在最前面,可以使用asc,desc控制整体顺序。
-如果有NULL值,可以使用nulls first,nulls last控制null的顺序
+不在param参数中的数据不会参与排序,将会放在最前面,可以使用asc,desc控制整体顺序。
+如果有NULL值,可以使用nulls first,nulls last控制null的顺序
### example
@@ -54,7 +54,6 @@ mysql> select k1,k7 from baseall where k1 in (1,2,3) order by field(k1,2,1,3);
| 1 | wangjing04 |
| 3 | yuanyuan06 |
+------+------------+
-3 rows in set (0.02 sec)
mysql> select class_name from class_test order by field(class_name,'Suzi','Ben','Henry');
+------------+
@@ -67,6 +66,31 @@ mysql> select class_name from class_test order by field(class_name,'Suzi','Ben',
| Henry |
| Henry |
+------------+
+
+mysql> select class_name from class_test order by field(class_name,'Suzi','Ben','Henry') desc;
++------------+
+| class_name |
++------------+
+| Henry |
+| Henry |
+| Ben |
+| Ben |
+| Suzi |
+| Suzi |
++------------+
+
+mysql> select class_name from class_test order by field(class_name,'Suzi','Ben','Henry') nulls first;
++------------+
+| class_name |
++------------+
+| null |
+| Suzi |
+| Suzi |
+| Ben |
+| Ben |
+| Henry |
+| Henry |
++------------+
```
### keywords
field
diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ucase.md b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ucase.md
index f6888541b8..ccef94797b 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ucase.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ucase.md
@@ -28,7 +28,7 @@ under the License.
### description
#### Syntax
-`INT ucase(VARCHAR str)`
+`VARCHAR ucase(VARCHAR str)`
将参数中所有的字符串都转换成大写,此函数的另一个别名为[upper](./upper.md)。
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org