This is an automated email from the ASF dual-hosted git repository.
luzhijing pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 4fec7ff866 [fix](json) add details description of get_json_xxx
functions (#723)
4fec7ff866 is described below
commit 4fec7ff86671d8c37f583630a823911813318556
Author: zclllyybb <[email protected]>
AuthorDate: Tue Jun 11 11:55:42 2024 +0800
[fix](json) add details description of get_json_xxx functions (#723)
just like `json_extract_xxx` to describe there corner case better.
---
docs/sql-manual/sql-functions/json-functions/get-json-bigint.md | 4 ++++
docs/sql-manual/sql-functions/json-functions/get-json-double.md | 4 ++++
docs/sql-manual/sql-functions/json-functions/get-json-int.md | 4 ++++
docs/sql-manual/sql-functions/json-functions/get-json-string.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-bigint.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-double.md | 4 ++++
.../current/sql-manual/sql-functions/json-functions/get-json-int.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-string.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get_json_bigint.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get_json_double.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get_json_int.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get_json_string.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-bigint.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-double.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-int.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-string.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-bigint.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-double.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-int.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-string.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get_json_bigint.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get_json_double.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get_json_int.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get_json_string.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-bigint.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-double.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-int.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-string.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-bigint.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-double.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-int.md | 4 ++++
.../sql-manual/sql-functions/json-functions/get-json-string.md | 4 ++++
32 files changed, 128 insertions(+)
diff --git a/docs/sql-manual/sql-functions/json-functions/get-json-bigint.md
b/docs/sql-manual/sql-functions/json-functions/get-json-bigint.md
index 7eda9c4f0e..d5e3d4aa50 100644
--- a/docs/sql-manual/sql-functions/json-functions/get-json-bigint.md
+++ b/docs/sql-manual/sql-functions/json-functions/get-json-bigint.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git a/docs/sql-manual/sql-functions/json-functions/get-json-double.md
b/docs/sql-manual/sql-functions/json-functions/get-json-double.md
index 95ab94bb4d..ba7a21a595 100644
--- a/docs/sql-manual/sql-functions/json-functions/get-json-double.md
+++ b/docs/sql-manual/sql-functions/json-functions/get-json-double.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git a/docs/sql-manual/sql-functions/json-functions/get-json-int.md
b/docs/sql-manual/sql-functions/json-functions/get-json-int.md
index 069308e3c2..14d25132dc 100644
--- a/docs/sql-manual/sql-functions/json-functions/get-json-int.md
+++ b/docs/sql-manual/sql-functions/json-functions/get-json-int.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git a/docs/sql-manual/sql-functions/json-functions/get-json-string.md
b/docs/sql-manual/sql-functions/json-functions/get-json-string.md
index 16de495afc..519072edca 100644
--- a/docs/sql-manual/sql-functions/json-functions/get-json-string.md
+++ b/docs/sql-manual/sql-functions/json-functions/get-json-string.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-bigint.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-bigint.md
index 2fce7fead0..cb8687f0b3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-bigint.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-bigint.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-double.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-double.md
index bdc8b00c18..af73f5ac98 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-double.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-double.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-int.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-int.md
index 4fdc3fc73a..344f7b84cb 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-int.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-int.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-string.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-string.md
index 59a2c1e170..2e4863c225 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-string.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/json-functions/get-json-string.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_bigint.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_bigint.md
index cfad402fc5..1477009a1c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_bigint.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_bigint.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_double.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_double.md
index 22612b12f1..d40c86d060 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_double.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_double.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_int.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_int.md
index ecc29de09c..341fcc4914 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_int.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_int.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_string.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_string.md
index 58d4759155..18dcbb694a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_string.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_string.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-bigint.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-bigint.md
index 2fce7fead0..cb8687f0b3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-bigint.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-bigint.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-double.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-double.md
index bdc8b00c18..af73f5ac98 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-double.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-double.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-int.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-int.md
index 4fdc3fc73a..344f7b84cb 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-int.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-int.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-string.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-string.md
index 59a2c1e170..2e4863c225 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-string.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-string.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-bigint.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-bigint.md
index 2fce7fead0..cb8687f0b3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-bigint.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-bigint.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-double.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-double.md
index bdc8b00c18..af73f5ac98 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-double.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-double.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-int.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-int.md
index 4fdc3fc73a..344f7b84cb 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-int.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-int.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-string.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-string.md
index 59a2c1e170..2e4863c225 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-string.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-string.md
@@ -39,6 +39,10 @@ path 的内容不能包含 ", [ 和 ]。
另外，推荐使用jsonb类型和jsonb_extract_XXX函数实现同样的功能。
+特殊情况处理如下：
+- 如果 json_path 指定的字段在JSON中不存在，返回NULL
+- 如果 json_path
指定的字段在JSON中的实际类型和json_extract_t指定的类型不一致，如果能无损转换成指定类型返回指定类型t，如果不能则返回NULL
+
### example
1. 获取 key 为 "k1" 的 value
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_bigint.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_bigint.md
index 24be5a313d..a8f5e470a9 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_bigint.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_bigint.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_double.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_double.md
index 2b7a6dddcc..678479b0f3 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_double.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_double.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_int.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_int.md
index 4b5a63f93e..79e7cc642b 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_int.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_int.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_string.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_string.md
index 50ece140e6..66edbd8503 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_string.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/get_json_string.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-bigint.md
b/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-bigint.md
index 7eda9c4f0e..d5e3d4aa50 100644
---
a/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-bigint.md
+++
b/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-bigint.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-double.md
b/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-double.md
index 95ab94bb4d..ba7a21a595 100644
---
a/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-double.md
+++
b/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-double.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-int.md
b/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-int.md
index 069308e3c2..14d25132dc 100644
---
a/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-int.md
+++
b/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-int.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-string.md
b/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-string.md
index 16de495afc..519072edca 100644
---
a/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-string.md
+++
b/versioned_docs/version-2.0/sql-manual/sql-functions/json-functions/get-json-string.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-bigint.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-bigint.md
index 7eda9c4f0e..d5e3d4aa50 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-bigint.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-bigint.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-double.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-double.md
index 95ab94bb4d..ba7a21a595 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-double.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-double.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-int.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-int.md
index 069308e3c2..14d25132dc 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-int.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-int.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-string.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-string.md
index 16de495afc..519072edca 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-string.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/json-functions/get-json-string.md
@@ -39,6 +39,10 @@ If the json_string format is incorrect, or the json_path
format is incorrect, or
In addition, it is recommended to use the jsonb type and jsonb_extract_XXX
function performs the same function.
+Exception handling is as follows:
+- if the field specified by json_path does not exist, return NULL
+- if datatype of the field specified by json_path is not the same with type of
json_extract_t, return t if it can be cast to t else NULL
+
### example
1. Get the value of key as "k1"
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
