This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-doris.git
The following commit(s) were added to refs/heads/master by this push:
new 461b352 [fix](function) Change digital_masking function arg type to
BIGINT (#7888)
461b352 is described below
commit 461b352d3ee741ff8781d474c3907dabc26fe670
Author: qiye <jianliang5...@gmail.com>
AuthorDate: Tue Jan 25 22:28:05 2022 +0800
[fix](function) Change digital_masking function arg type to BIGINT (#7888)
Change digital_masking function arg type to BIGINT to fix the wrong result.
---
docs/en/sql-reference/sql-functions/digital-masking.md | 2 +-
docs/en/sql-reference/sql-statements/Data Definition/create-function.md | 2 +-
docs/en/sql-reference/sql-statements/Data Definition/show-functions.md | 2 +-
docs/zh-CN/sql-reference/sql-functions/digital-masking.md | 2 +-
.../sql-reference/sql-statements/Data Definition/create-function.md | 2 +-
.../sql-reference/sql-statements/Data Definition/show-functions.md | 2 +-
fe/fe-core/src/main/java/org/apache/doris/catalog/AliasFunction.java | 2 +-
.../src/test/java/org/apache/doris/catalog/CreateFunctionTest.java | 2 +-
8 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/docs/en/sql-reference/sql-functions/digital-masking.md
b/docs/en/sql-reference/sql-functions/digital-masking.md
index bd2b22b..f8ce744 100644
--- a/docs/en/sql-reference/sql-functions/digital-masking.md
+++ b/docs/en/sql-reference/sql-functions/digital-masking.md
@@ -36,7 +36,7 @@ digital_masking(digital_number)
Alias function, the original function is
`concat(left(id,3),'****',right(id,4))`.
-Desensitizes the input `digital_number` and returns the result after masking
desensitization.
+Desensitizes the input `digital_number` and returns the result after masking
desensitization. `digital_number` is `BIGINT` data type.
## example
diff --git a/docs/en/sql-reference/sql-statements/Data
Definition/create-function.md b/docs/en/sql-reference/sql-statements/Data
Definition/create-function.md
index fdd08ed..ca581dd 100644
--- a/docs/en/sql-reference/sql-statements/Data Definition/create-function.md
+++ b/docs/en/sql-reference/sql-statements/Data Definition/create-function.md
@@ -131,7 +131,7 @@ If the `function_name` contains the database name, the
custom function will be c
```
-- create a custom functional alias function
- CREATE ALIAS FUNCTION id_masking(INT) WITH PARAMETER(id)
+ CREATE ALIAS FUNCTION id_masking(BIGINT) WITH PARAMETER(id)
AS CONCAT(LEFT(id, 3), '****', RIGHT(id, 4));
-- create a custom cast alias function
diff --git a/docs/en/sql-reference/sql-statements/Data
Definition/show-functions.md b/docs/en/sql-reference/sql-statements/Data
Definition/show-functions.md
index b942046..59b5bcb 100644
--- a/docs/en/sql-reference/sql-statements/Data Definition/show-functions.md
+++ b/docs/en/sql-reference/sql-statements/Data Definition/show-functions.md
@@ -60,7 +60,7 @@ Intermediate Type: NULL
Intermediate Type: NULL
Properties:
{"object_file":"http://host:port/libudasample.so","finalize_fn":"_ZN9doris_udf13CountFinalizeEPNS_15FunctionContextERKNS_9BigIntValE","init_fn":"_ZN9doris_udf9CountInitEPNS_15FunctionContextEPNS_9BigIntValE","merge_fn":"_ZN9doris_udf10CountMergeEPNS_15FunctionContextERKNS_9BigIntValEPS2_","md5":"37d185f80f95569e2676da3d5b5b9d2f","update_fn":"_ZN9doris_udf11CountUpdateEPNS_15FunctionContextERKNS_6IntValEPNS_9BigIntValE"}
*************************** 3. row ***************************
- Signature: id_masking(INT)
+ Signature: id_masking(BIGINT)
Return Type: VARCHAR
Function Type: Alias
Intermediate Type: NULL
diff --git a/docs/zh-CN/sql-reference/sql-functions/digital-masking.md
b/docs/zh-CN/sql-reference/sql-functions/digital-masking.md
index 32ea5a3..f049a30 100644
--- a/docs/zh-CN/sql-reference/sql-functions/digital-masking.md
+++ b/docs/zh-CN/sql-reference/sql-functions/digital-masking.md
@@ -36,7 +36,7 @@ digital_masking(digital_number)
别名函数，原始函数为 `concat(left(id,3),'****',right(id,4))`。
-将输入的 `digital_number` 进行脱敏处理，返回遮盖脱敏后的结果。
+将输入的 `digital_number` 进行脱敏处理，返回遮盖脱敏后的结果。`digital_number` 为 `BIGINT` 数据类型。
## example
diff --git a/docs/zh-CN/sql-reference/sql-statements/Data
Definition/create-function.md b/docs/zh-CN/sql-reference/sql-statements/Data
Definition/create-function.md
index 98d9ce0..f6b2c7b 100644
--- a/docs/zh-CN/sql-reference/sql-statements/Data
Definition/create-function.md
+++ b/docs/zh-CN/sql-reference/sql-statements/Data
Definition/create-function.md
@@ -132,7 +132,7 @@ CREATE [AGGREGATE] [ALIAS] FUNCTION function_name
```
-- 创建自定义功能别名函数
- CREATE ALIAS FUNCTION id_masking(INT) WITH PARAMETER(id)
+ CREATE ALIAS FUNCTION id_masking(BIGINT) WITH PARAMETER(id)
AS CONCAT(LEFT(id, 3), '****', RIGHT(id, 4));
-- 创建自定义 CAST 别名函数
diff --git a/docs/zh-CN/sql-reference/sql-statements/Data
Definition/show-functions.md b/docs/zh-CN/sql-reference/sql-statements/Data
Definition/show-functions.md
index 1220de2..3710109 100644
--- a/docs/zh-CN/sql-reference/sql-statements/Data Definition/show-functions.md
+++ b/docs/zh-CN/sql-reference/sql-statements/Data Definition/show-functions.md
@@ -61,7 +61,7 @@ Intermediate Type: NULL
Intermediate Type: NULL
Properties:
{"object_file":"http://host:port/libudasample.so","finalize_fn":"_ZN9doris_udf13CountFinalizeEPNS_15FunctionContextERKNS_9BigIntValE","init_fn":"_ZN9doris_udf9CountInitEPNS_15FunctionContextEPNS_9BigIntValE","merge_fn":"_ZN9doris_udf10CountMergeEPNS_15FunctionContextERKNS_9BigIntValEPS2_","md5":"37d185f80f95569e2676da3d5b5b9d2f","update_fn":"_ZN9doris_udf11CountUpdateEPNS_15FunctionContextERKNS_6IntValEPNS_9BigIntValE"}
*************************** 3. row ***************************
- Signature: id_masking(INT)
+ Signature: id_masking(BIGINT)
Return Type: VARCHAR
Function Type: Alias
Intermediate Type: NULL
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/catalog/AliasFunction.java
b/fe/fe-core/src/main/java/org/apache/doris/catalog/AliasFunction.java
index 2e91f33..c212976 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/catalog/AliasFunction.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/catalog/AliasFunction.java
@@ -88,7 +88,7 @@ public class AliasFunction extends Function {
/**
* Please ensure that the condition checks in {@link #analyze} are
satisfied
*/
- functionSet.addBuiltin(createBuiltin(DIGITAL_MASKING,
Lists.newArrayList(Type.INT), Type.VARCHAR,
+ functionSet.addBuiltin(createBuiltin(DIGITAL_MASKING,
Lists.newArrayList(Type.BIGINT), Type.VARCHAR,
false, Lists.newArrayList("id"), getExpr(oriStmt), true));
} catch (AnalysisException e) {
LOG.error("Add builtin alias function error {}", e);
diff --git
a/fe/fe-core/src/test/java/org/apache/doris/catalog/CreateFunctionTest.java
b/fe/fe-core/src/test/java/org/apache/doris/catalog/CreateFunctionTest.java
index 17ad666..7da7f92 100644
--- a/fe/fe-core/src/test/java/org/apache/doris/catalog/CreateFunctionTest.java
+++ b/fe/fe-core/src/test/java/org/apache/doris/catalog/CreateFunctionTest.java
@@ -120,7 +120,7 @@ public class CreateFunctionTest {
Assert.assertTrue(constExprLists.get(0).get(0) instanceof
FunctionCallExpr);
// create alias function
- createFuncStr = "create alias function db1.id_masking(int) with
parameter(id) as concat(left(id,3),'****',right(id,4));";
+ createFuncStr = "create alias function db1.id_masking(bigint) with
parameter(id) as concat(left(id,3),'****',right(id,4));";
createFunctionStmt = (CreateFunctionStmt)
UtFrameUtils.parseAndAnalyzeStmt(createFuncStr, ctx);
Catalog.getCurrentCatalog().createFunction(createFunctionStmt);
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
