This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 2c888667ed3 [improvement](function) standardize some ip functions'
signatures #29614
2c888667ed3 is described below
commit 2c888667ed37074c8ea6498cda6149651ca1d055
Author: Chester <[email protected]>
AuthorDate: Sat Jan 6 16:16:38 2024 +0800
[improvement](function) standardize some ip functions' signatures #29614
The signatures of functions in these PRs should be more standard:
#27342,
#25510,
#20936,
including the following:
ipv4numtostring,
ipv4stringtonum,
ipv4stringtonumordefault,
ipv4stringtonumornull,
ipv6numtostring.
This PR will add necessary underscores between the words of each of them,
like changing ipv4numtostring to ipv4_num_to_string.
---
be/src/vec/functions/function_ip.cpp | 2 +-
be/src/vec/functions/function_ip.h | 10 +++---
.../ip-functions/ipv4-num-to-string.md | 40 +++++++++++-----------
.../ip-functions/ipv4-string-to-num-or-default.md | 38 ++++++++++----------
.../ip-functions/ipv4-string-to-num-or-null.md | 38 ++++++++++----------
.../ip-functions/ipv4-string-to-num.md | 22 ++++++------
.../ip-functions/ipv6-num-to-string.md | 10 +++---
.../ip-functions/ipv4-num-to-string.md | 40 +++++++++++-----------
.../ip-functions/ipv4-string-to-num-or-default.md | 38 ++++++++++----------
.../ip-functions/ipv4-string-to-num-or-null.md | 38 ++++++++++----------
.../ip-functions/ipv4-string-to-num.md | 22 ++++++------
.../ip-functions/ipv6-num-to-string.md | 10 +++---
.../doris/catalog/BuiltinScalarFunctions.java | 10 +++---
.../functions/scalar/Ipv4NumToString.java | 6 ++--
.../functions/scalar/Ipv4StringToNum.java | 6 ++--
.../functions/scalar/Ipv4StringToNumOrDefault.java | 6 ++--
.../functions/scalar/Ipv4StringToNumOrNull.java | 6 ++--
.../functions/scalar/Ipv6NumToString.java | 6 ++--
gensrc/script/doris_builtins_functions.py | 24 ++++++-------
.../suites/nereids_function_p0/ip_functions.groovy | 30 ++++++++--------
.../ip_functions/test_ip_functions.groovy | 28 +++++++--------
21 files changed, 215 insertions(+), 215 deletions(-)
diff --git a/be/src/vec/functions/function_ip.cpp
b/be/src/vec/functions/function_ip.cpp
index 6e59503dba3..ba96331cf7f 100644
--- a/be/src/vec/functions/function_ip.cpp
+++ b/be/src/vec/functions/function_ip.cpp
@@ -19,7 +19,7 @@
namespace doris::vectorized {
struct NameFunctionIPv4NumToString {
- static constexpr auto name = "ipv4numtostring";
+ static constexpr auto name = "ipv4_num_to_string";
};
void register_function_ip(SimpleFunctionFactory& factory) {
diff --git a/be/src/vec/functions/function_ip.h
b/be/src/vec/functions/function_ip.h
index 042f1023602..b5bbe6e5d97 100644
--- a/be/src/vec/functions/function_ip.h
+++ b/be/src/vec/functions/function_ip.h
@@ -82,7 +82,7 @@ private:
}
public:
- static constexpr auto name = "ipv4numtostring";
+ static constexpr auto name = "ipv4_num_to_string";
static FunctionPtr create() {
return std::make_shared<FunctionIPv4NumToString<mask_tail_octets,
Name>>();
}
@@ -196,10 +196,10 @@ template <IPStringToNumExceptionMode exception_mode>
class FunctionIPv4StringToNum : public IFunction {
public:
static constexpr auto name = exception_mode ==
IPStringToNumExceptionMode::Throw
- ? "ipv4stringtonum"
+ ? "ipv4_string_to_num"
: (exception_mode ==
IPStringToNumExceptionMode::Default
- ?
"ipv4stringtonumordefault"
- : "ipv4stringtonumornull");
+ ?
"ipv4_string_to_num_or_default"
+ :
"ipv4_string_to_num_or_null");
static FunctionPtr create() {
return std::make_shared<FunctionIPv4StringToNum<exception_mode>>();
@@ -293,7 +293,7 @@ void process_ipv6_column(const ColumnPtr& column, size_t
input_rows_count,
class FunctionIPv6NumToString : public IFunction {
public:
- static constexpr auto name = "ipv6numtostring";
+ static constexpr auto name = "ipv6_num_to_string";
static FunctionPtr create() { return
std::make_shared<FunctionIPv6NumToString>(); }
String get_name() const override { return name; }
diff --git
a/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-num-to-string.md
b/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-num-to-string.md
index df2aca4b99d..6e30c901a80 100644
--- a/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-num-to-string.md
+++ b/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-num-to-string.md
@@ -22,11 +22,11 @@ specific language governing permissions and limitations
under the License.
-->
-## IPv4NumToString
+## IPV4_NUM_TO_STRING
<version since="dev">
-IPv4NumToString
+IPV4_NUM_TO_STRING
</version>
@@ -34,7 +34,7 @@ IPv4NumToString
#### Syntax
-`VARCHAR IPv4NumToString(BIGINT ipv4_num)`
+`VARCHAR IPV4_NUM_TO_STRING(BIGINT ipv4_num)`
Takes a Int16、Int32、Int64 number. Interprets it as an IPv4 address in big
endian. Returns a string containing the corresponding IPv4 address in the
format A.B.C.d (dot-separated numbers in decimal form).
### notice
@@ -44,27 +44,27 @@ Takes a Int16、Int32、Int64 number. Interprets it as an IPv4
address in big en
### example
```
-mysql> select ipv4numtostring(3232235521);
-+-----------------------------+
-| ipv4numtostring(3232235521) |
-+-----------------------------+
-| 192.168.0.1 |
-+-----------------------------+
+mysql> select ipv4_num_to_string(3232235521);
++--------------------------------+
+| ipv4_num_to_string(3232235521) |
++--------------------------------+
+| 192.168.0.1 |
++--------------------------------+
1 row in set (0.01 sec)
-mysql> select num,ipv4numtostring(num) from ipv4_bi;
-+------------+------------------------+
-| num | ipv4numtostring(`num`) |
-+------------+------------------------+
-| -1 | NULL |
-| 0 | 0.0.0.0 |
-| 2130706433 | 127.0.0.1 |
-| 4294967295 | 255.255.255.255 |
-| 4294967296 | NULL |
-+------------+------------------------+
+mysql> select num,ipv4_num_to_string(num) from ipv4_bi;
++------------+---------------------------+
+| num | ipv4_num_to_string(`num`) |
++------------+---------------------------+
+| -1 | NULL |
+| 0 | 0.0.0.0 |
+| 2130706433 | 127.0.0.1 |
+| 4294967295 | 255.255.255.255 |
+| 4294967296 | NULL |
++------------+---------------------------+
7 rows in set (0.01 sec)
```
### keywords
-IPV4NUMTOSTRING, IP
+IPV4_NUM_TO_STRING, IP
diff --git
a/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-default.md
b/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-default.md
index 54f3c3954da..8400b1dc23b 100644
---
a/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-default.md
+++
b/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-default.md
@@ -22,11 +22,11 @@ specific language governing permissions and limitations
under the License.
-->
-## IPv4StringToNumOrDefault
+## IPV4_STRING_TO_NUM_OR_DEFAULT
<version since="dev">
-IPv4StringToNumOrDefault
+IPV4_STRING_TO_NUM_OR_DEFAULT
</version>
@@ -34,7 +34,7 @@ IPv4StringToNumOrDefault
#### Syntax
-`BIGINT IPv4StringToNumOrDefault(VARCHAR ipv4_string)`
+`BIGINT IPV4_STRING_TO_NUM_OR_DEFAULT(VARCHAR ipv4_string)`
Takes a string containing an IPv4 address in the format A.B.C.D (dot-separated
numbers in decimal form). Returns a BIGINT number representing the
corresponding IPv4 address in big endian.
@@ -44,26 +44,26 @@ Takes a string containing an IPv4 address in the format
A.B.C.D (dot-separated n
### example
```
-mysql> select ipv4stringtonumordefault('192.168.0.1');
-+-----------------------------------------+
-| ipv4stringtonumordefault('192.168.0.1') |
-+-----------------------------------------+
-| 3232235521 |
-+-----------------------------------------+
+mysql> select ipv4_string_to_num_or_default('192.168.0.1');
++----------------------------------------------+
+| ipv4_string_to_num_or_default('192.168.0.1') |
++----------------------------------------------+
+| 3232235521 |
++----------------------------------------------+
1 row in set (0.01 sec)
-mysql> select str, ipv4stringtonumordefault(str) from ipv4_str;
-+-----------------+-------------------------------+
-|str | ipv4stringtonumordefault(str) |
-+-----------------+-------------------------------+
-| 0.0.0.0 | 0 |
-| 127.0.0.1 | 2130706433 |
-| 255.255.255.255 | 4294967295 |
-| invalid | 0 |
-+-----------------+-------------------------------+
+mysql> select str, ipv4_string_to_num_or_default(str) from ipv4_str;
++-----------------+------------------------------------+
+|str | ipv4_string_to_num_or_default(str) |
++-----------------+------------------------------------+
+| 0.0.0.0 | 0 |
+| 127.0.0.1 | 2130706433 |
+| 255.255.255.255 | 4294967295 |
+| invalid | 0 |
++-----------------+------------------------------------+
4 rows in set (0.01 sec)
```
### keywords
-IPV4STRINGTONUMORDEFAULT, IP
\ No newline at end of file
+IPV4_STRING_TO_NUM_OR_DEFAULT, IP
\ No newline at end of file
diff --git
a/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-null.md
b/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-null.md
index 372e510d439..aa24a9523b4 100644
---
a/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-null.md
+++
b/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-null.md
@@ -22,11 +22,11 @@ specific language governing permissions and limitations
under the License.
-->
-## IPv4StringToNumOrNull
+## IPV4_STRING_TO_NUM_OR_NULL
<version since="dev">
-IPv4StringToNumOrNull
+IPV4_STRING_TO_NUM_OR_NULL
</version>
@@ -34,7 +34,7 @@ IPv4StringToNumOrNull
#### Syntax
-`BIGINT IPv4StringToNumOrNull(VARCHAR ipv4_string)`
+`BIGINT IPV4_STRING_TO_NUM_OR_NULL(VARCHAR ipv4_string)`
Takes a string containing an IPv4 address in the format A.B.C.D (dot-separated
numbers in decimal form). Returns a BIGINT number representing the
corresponding IPv4 address in big endian.
@@ -44,26 +44,26 @@ Takes a string containing an IPv4 address in the format
A.B.C.D (dot-separated n
### example
```
-mysql> select ipv4stringtonumornull('192.168.0.1');
-+--------------------------------------+
-| ipv4stringtonumornull('192.168.0.1') |
-+--------------------------------------+
-| 3232235521 |
-+--------------------------------------+
+mysql> select ipv4_string_to_num_or_null('192.168.0.1');
++-------------------------------------------+
+| ipv4_string_to_num_or_null('192.168.0.1') |
++-------------------------------------------+
+| 3232235521 |
++-------------------------------------------+
1 row in set (0.01 sec)
-mysql> select str, ipv4stringtonumornull(str) from ipv4_str;
-+-----------------+----------------------------+
-|str | ipv4stringtonumornull(str) |
-+-----------------+----------------------------+
-| 0.0.0.0 | 0 |
-| 127.0.0.1 | 2130706433 |
-| 255.255.255.255 | 4294967295 |
-| invalid | NULL |
-+-----------------+----------------------------+
+mysql> select str, ipv4_string_to_num_or_null(str) from ipv4_str;
++-----------------+---------------------------------+
+|str | ipv4_string_to_num_or_null(str) |
++-----------------+---------------------------------+
+| 0.0.0.0 | 0 |
+| 127.0.0.1 | 2130706433 |
+| 255.255.255.255 | 4294967295 |
+| invalid | NULL |
++-----------------+---------------------------------+
4 rows in set (0.01 sec)
```
### keywords
-IPV4STRINGTONUMORNULL, IP
\ No newline at end of file
+IPV4_STRING_TO_NUM_OR_NULL, IP
\ No newline at end of file
diff --git
a/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num.md
b/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num.md
index c6c42be9480..7c5154943eb 100644
--- a/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num.md
+++ b/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num.md
@@ -22,11 +22,11 @@ specific language governing permissions and limitations
under the License.
-->
-## IPv4StringToNum
+## IPV4_STRING_TO_NUM
<version since="dev">
-IPv4StringToNum
+IPV4_STRING_TO_NUM
</version>
@@ -34,7 +34,7 @@ IPv4StringToNum
#### Syntax
-`BIGINT IPv4StringToNum(VARCHAR ipv4_string)`
+`BIGINT IPV4_STRING_TO_NUM(VARCHAR ipv4_string)`
Takes a string containing an IPv4 address in the format A.B.C.D (dot-separated
numbers in decimal form). Returns a BIGINT number representing the
corresponding IPv4 address in big endian.
@@ -44,18 +44,18 @@ Takes a string containing an IPv4 address in the format
A.B.C.D (dot-separated n
### example
```
-mysql> select ipv4stringtonum('192.168.0.1');
-+--------------------------------+
-| ipv4stringtonum('192.168.0.1') |
-+--------------------------------+
-| 3232235521 |
-+--------------------------------+
+mysql> select ipv4_string_to_num('192.168.0.1');
++-----------------------------------+
+| ipv4_string_to_num('192.168.0.1') |
++-----------------------------------+
+| 3232235521 |
++-----------------------------------+
1 row in set (0.01 sec)
-mysql> select ipv4stringtonum('invalid');
+mysql> select ipv4_string_to_num('invalid');
ERROR 1105 (HY000): errCode = 2, detailMessage =
(172.17.0.2)[CANCELLED][INVALID_ARGUMENT][E33] Invalid IPv4 value
```
### keywords
-IPV4STRINGTONUM, IP
\ No newline at end of file
+IPV4_STRING_TO_NUM, IP
\ No newline at end of file
diff --git
a/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv6-num-to-string.md
b/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv6-num-to-string.md
index 96941771ecd..9e01a67cb1c 100644
--- a/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv6-num-to-string.md
+++ b/docs/en/docs/sql-manual/sql-functions/ip-functions/ipv6-num-to-string.md
@@ -22,11 +22,11 @@ specific language governing permissions and limitations
under the License.
-->
-## IPv6NumToString
+## IPV6_NUM_TO_STRING
<version since="dev">
-IPv6NumToString
+IPV6_NUM_TO_STRING
</version>
@@ -34,7 +34,7 @@ IPv6NumToString
#### Syntax
-`VARCHAR IPv6NumToString(VARCHAR ipv6_num)`
+`VARCHAR IPV6_NUM_TO_STRING(VARCHAR ipv6_num)`
Takes an IPv6 address in binary format of type String. Returns the string of
this address in text format.
The IPv4 address mapped by IPv6 starts with ::ffff:111.222.33.
@@ -42,7 +42,7 @@ The IPv4 address mapped by IPv6 starts with ::ffff:111.222.33.
### example
```
-mysql> select ipv6numtostring(unhex('2A0206B8000000000000000000000011')) as
addr;
+mysql> select ipv6_num_to_string(unhex('2A0206B8000000000000000000000011')) as
addr;
+--------------+
| addr |
+--------------+
@@ -53,4 +53,4 @@ mysql> select
ipv6numtostring(unhex('2A0206B8000000000000000000000011')) as addr
### keywords
-IPV6NUMTOSTRING, IP
+IPV6_NUM_TO_STRING, IP
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-num-to-string.md
b/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-num-to-string.md
index d238d5c28f2..8a32579e28d 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-num-to-string.md
+++
b/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-num-to-string.md
@@ -22,11 +22,11 @@ specific language governing permissions and limitations
under the License.
-->
-## IPv4NumToString
+## IPV4_NUM_TO_STRING
<version since="dev">
-IPv4NumToString
+IPV4_NUM_TO_STRING
</version>
@@ -34,7 +34,7 @@ IPv4NumToString
#### Syntax
-`VARCHAR IPv4NumToString(BIGINT ipv4_num)`
+`VARCHAR IPV4_NUM_TO_STRING(BIGINT ipv4_num)`
接受一个类型为Int16、Int32、Int64 且大端表示的 IPv4 的地址，返回相应 IPv4
的字符串表现形式，格式为A.B.C.D（以点分割的十进制数字）。
@@ -45,27 +45,27 @@ IPv4NumToString
### example
```
-mysql> select ipv4numtostring(3232235521);
-+-----------------------------+
-| ipv4numtostring(3232235521) |
-+-----------------------------+
-| 192.168.0.1 |
-+-----------------------------+
+mysql> select ipv4_num_to_string(3232235521);
++--------------------------------+
+| ipv4_num_to_string(3232235521) |
++--------------------------------+
+| 192.168.0.1 |
++--------------------------------+
1 row in set (0.01 sec)
-mysql> select num,ipv4numtostring(num) from ipv4_bi;
-+------------+------------------------+
-| num | ipv4numtostring(`num`) |
-+------------+------------------------+
-| -1 | NULL |
-| 0 | 0.0.0.0 |
-| 2130706433 | 127.0.0.1 |
-| 4294967295 | 255.255.255.255 |
-| 4294967296 | NULL |
-+------------+------------------------+
+mysql> select num,ipv4_num_to_string(num) from ipv4_bi;
++------------+---------------------------+
+| num | ipv4_num_to_string(`num`) |
++------------+---------------------------+
+| -1 | NULL |
+| 0 | 0.0.0.0 |
+| 2130706433 | 127.0.0.1 |
+| 4294967295 | 255.255.255.255 |
+| 4294967296 | NULL |
++------------+---------------------------+
7 rows in set (0.01 sec)
```
### keywords
-IPV4NUMTOSTRING, IP
+IPV4_NUM_TO_STRING, IP
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-default.md
b/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-default.md
index 9132535f50c..42fa8174639 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-default.md
+++
b/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-default.md
@@ -22,11 +22,11 @@ specific language governing permissions and limitations
under the License.
-->
-## IPv4StringToNumOrDefault
+## IPV4_STRING_TO_NUM_OR_DEFAULT
<version since="dev">
-IPv4StringToNumOrDefault
+IPV4_STRING_TO_NUM_OR_DEFAULT
</version>
@@ -34,7 +34,7 @@ IPv4StringToNumOrDefault
#### Syntax
-`BIGINT IPv4StringToNumOrDefault(VARCHAR ipv4_string)`
+`BIGINT IPV4_STRING_TO_NUM_OR_DEFAULT(VARCHAR ipv4_string)`
获取包含 IPv4 地址的字符串，格式为 A.B.C.D（点分隔的十进制数字）。返回一个 BIGINT 数字，表示相应的大端 IPv4 地址。
@@ -44,26 +44,26 @@ IPv4StringToNumOrDefault
### example
```
-mysql> select ipv4stringtonumordefault('192.168.0.1');
-+-----------------------------------------+
-| ipv4stringtonumordefault('192.168.0.1') |
-+-----------------------------------------+
-| 3232235521 |
-+-----------------------------------------+
+mysql> select ipv4_string_to_num_or_default('192.168.0.1');
++----------------------------------------------+
+| ipv4_string_to_num_or_default('192.168.0.1') |
++----------------------------------------------+
+| 3232235521 |
++----------------------------------------------+
1 row in set (0.01 sec)
-mysql> select str, ipv4stringtonumordefault(str) from ipv4_str;
-+-----------------+-------------------------------+
-|str | ipv4stringtonumordefault(str) |
-+-----------------+-------------------------------+
-| 0.0.0.0 | 0 |
-| 127.0.0.1 | 2130706433 |
-| 255.255.255.255 | 4294967295 |
-| invalid | 0 |
-+-----------------+-------------------------------+
+mysql> select str, ipv4_string_to_num_or_default(str) from ipv4_str;
++-----------------+------------------------------------+
+|str | ipv4_string_to_num_or_default(str) |
++-----------------+------------------------------------+
+| 0.0.0.0 | 0 |
+| 127.0.0.1 | 2130706433 |
+| 255.255.255.255 | 4294967295 |
+| invalid | 0 |
++-----------------+------------------------------------+
4 rows in set (0.01 sec)
```
### keywords
-IPV4STRINGTONUMORDEFAULT, IP
\ No newline at end of file
+IPV4_STRING_TO_NUM_OR_DEFAULT, IP
\ No newline at end of file
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-null.md
b/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-null.md
index 6d320c8fdbd..e7eddbcb351 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-null.md
+++
b/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num-or-null.md
@@ -22,11 +22,11 @@ specific language governing permissions and limitations
under the License.
-->
-## IPv4StringToNumOrNull
+## IPV4_STRING_TO_NUM_OR_NULL
<version since="dev">
-IPv4StringToNumOrNull
+IPV4_STRING_TO_NUM_OR_NULL
</version>
@@ -34,7 +34,7 @@ IPv4StringToNumOrNull
#### Syntax
-`BIGINT IPv4StringToNumOrNull(VARCHAR ipv4_string)`
+`BIGINT IPV4_STRING_TO_NUM_OR_NULL(VARCHAR ipv4_string)`
获取包含 IPv4 地址的字符串，格式为 A.B.C.D（点分隔的十进制数字）。返回一个 BIGINT 数字，表示相应的大端 IPv4 地址。
@@ -44,26 +44,26 @@ IPv4StringToNumOrNull
### example
```
-mysql> select ipv4stringtonumornull('192.168.0.1');
-+--------------------------------------+
-| ipv4stringtonumornull('192.168.0.1') |
-+--------------------------------------+
-| 3232235521 |
-+--------------------------------------+
+mysql> select ipv4_string_to_num_or_null('192.168.0.1');
++-------------------------------------------+
+| ipv4_string_to_num_or_null('192.168.0.1') |
++-------------------------------------------+
+| 3232235521 |
++-------------------------------------------+
1 row in set (0.01 sec)
-mysql> select str, ipv4stringtonumornull(str) from ipv4_str;
-+-----------------+----------------------------+
-|str | ipv4stringtonumornull(str) |
-+-----------------+----------------------------+
-| 0.0.0.0 | 0 |
-| 127.0.0.1 | 2130706433 |
-| 255.255.255.255 | 4294967295 |
-| invalid | NULL |
-+-----------------+----------------------------+
+mysql> select str, ipv4_string_to_num_or_null(str) from ipv4_str;
++-----------------+---------------------------------+
+|str | ipv4_string_to_num_or_null(str) |
++-----------------+---------------------------------+
+| 0.0.0.0 | 0 |
+| 127.0.0.1 | 2130706433 |
+| 255.255.255.255 | 4294967295 |
+| invalid | NULL |
++-----------------+---------------------------------+
4 rows in set (0.01 sec)
```
### keywords
-IPV4STRINGTONUMORNULL, IP
\ No newline at end of file
+IPV4_STRING_TO_NUM_OR_NULL, IP
\ No newline at end of file
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num.md
b/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num.md
index e97087bf010..c2d42c1e004 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num.md
+++
b/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv4-string-to-num.md
@@ -22,11 +22,11 @@ specific language governing permissions and limitations
under the License.
-->
-## IPv4StringToNum
+## IPV4_STRING_TO_NUM
<version since="dev">
-IPv4StringToNum
+IPV4_STRING_TO_NUM
</version>
@@ -34,7 +34,7 @@ IPv4StringToNum
#### Syntax
-`BIGINT IPv4StringToNum(VARCHAR ipv4_string)`
+`BIGINT IPV4_STRING_TO_NUM(VARCHAR ipv4_string)`
获取包含 IPv4 地址的字符串，格式为 A.B.C.D（点分隔的十进制数字）。返回一个 BIGINT 数字，表示相应的大端 IPv4 地址。
@@ -44,18 +44,18 @@ IPv4StringToNum
### example
```
-mysql> select ipv4stringtonum('192.168.0.1');
-+--------------------------------+
-| ipv4stringtonum('192.168.0.1') |
-+--------------------------------+
-| 3232235521 |
-+--------------------------------+
+mysql> select ipv4_string_to_num('192.168.0.1');
++-----------------------------------+
+| ipv4_string_to_num('192.168.0.1') |
++-----------------------------------+
+| 3232235521 |
++-----------------------------------+
1 row in set (0.01 sec)
-mysql> SELECT ipv4stringtonum('192.168');
+mysql> SELECT ipv4_string_to_num('192.168');
ERROR 1105 (HY000): errCode = 2, detailMessage =
(172.17.0.2)[CANCELLED][INVALID_ARGUMENT][E33] Invalid IPv4 value
```
### keywords
-IPV4STRINGTONUM, IP
\ No newline at end of file
+IPV4_STRING_TO_NUM, IP
\ No newline at end of file
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv6-num-to-string.md
b/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv6-num-to-string.md
index 44bb3a9da6a..8a1fdeba7fc 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv6-num-to-string.md
+++
b/docs/zh-CN/docs/sql-manual/sql-functions/ip-functions/ipv6-num-to-string.md
@@ -22,11 +22,11 @@ specific language governing permissions and limitations
under the License.
-->
-## IPv6NumToString
+## IPV6_NUM_TO_STRING
<version since="dev">
-IPv6NumToString
+IPV6_NUM_TO_STRING
</version>
@@ -34,7 +34,7 @@ IPv6NumToString
#### Syntax
-`VARCHAR IPv6NumToString(VARCHAR ipv6_num)`
+`VARCHAR IPV6_NUM_TO_STRING(VARCHAR ipv6_num)`
接受字符串类型的二进制格式的IPv6地址。以文本格式返回此地址的字符串。
IPv6映射的IPv4地址以::ffff:111.222.33。
@@ -42,7 +42,7 @@ IPv6映射的IPv4地址以::ffff:111.222.33。
### example
```
-mysql> select ipv6numtostring(unhex('2A0206B8000000000000000000000011')) as
addr;
+mysql> select ipv6_num_to_string(unhex('2A0206B8000000000000000000000011')) as
addr;
+--------------+
| addr |
+--------------+
@@ -53,4 +53,4 @@ mysql> select
ipv6numtostring(unhex('2A0206B8000000000000000000000011')) as addr
### keywords
-IPV6NUMTOSTRING, IP
+IPV6_NUM_TO_STRING, IP
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/catalog/BuiltinScalarFunctions.java
b/fe/fe-core/src/main/java/org/apache/doris/catalog/BuiltinScalarFunctions.java
index 2a2627d29af..2193f3631ee 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/catalog/BuiltinScalarFunctions.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/catalog/BuiltinScalarFunctions.java
@@ -591,11 +591,11 @@ public class BuiltinScalarFunctions implements
FunctionHelper {
scalar(Initcap.class, "initcap"),
scalar(InnerProduct.class, "inner_product"),
scalar(Instr.class, "instr"),
- scalar(Ipv4NumToString.class, "ipv4numtostring", "inet_ntoa"),
- scalar(Ipv4StringToNum.class, "ipv4stringtonum", "inet_aton"),
- scalar(Ipv4StringToNumOrDefault.class, "ipv4stringtonumordefault"),
- scalar(Ipv4StringToNumOrNull.class, "ipv4stringtonumornull"),
- scalar(Ipv6NumToString.class, "ipv6numtostring", "inet6_ntoa"),
+ scalar(Ipv4NumToString.class, "ipv4_num_to_string", "inet_ntoa"),
+ scalar(Ipv4StringToNum.class, "ipv4_string_to_num", "inet_aton"),
+ scalar(Ipv4StringToNumOrDefault.class,
"ipv4_string_to_num_or_default"),
+ scalar(Ipv4StringToNumOrNull.class, "ipv4_string_to_num_or_null"),
+ scalar(Ipv6NumToString.class, "ipv6_num_to_string", "inet6_ntoa"),
scalar(Ipv6StringToNum.class, "ipv6_string_to_num", "inet6_aton"),
scalar(Ipv6StringToNumOrDefault.class,
"ipv6_string_to_num_or_default"),
scalar(Ipv6StringToNumOrNull.class, "ipv6_string_to_num_or_null"),
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4NumToString.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4NumToString.java
index afca51cdc95..d5f267cf4c1 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4NumToString.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4NumToString.java
@@ -35,7 +35,7 @@ import com.google.common.collect.ImmutableList;
import java.util.List;
/**
- * scalar function Ipv4NumToString
+ * scalar function ipv4_num_to_string
*/
public class Ipv4NumToString extends ScalarFunction
implements BinaryExpression, ExplicitlyCastableSignature,
AlwaysNullable {
@@ -47,13 +47,13 @@ public class Ipv4NumToString extends ScalarFunction
FunctionSignature.ret(VarcharType.SYSTEM_DEFAULT).args(BigIntType.INSTANCE));
public Ipv4NumToString(Expression arg0) {
- super("ipv4numtostring", arg0);
+ super("ipv4_num_to_string", arg0);
}
@Override
public Ipv4NumToString withChildren(List<Expression> children) {
Preconditions.checkArgument(children.size() == 1,
- "ipv4numtostring accept 1 args, but got %s (%s)",
+ "ipv4_num_to_string accept 1 args, but got %s (%s)",
children.size(),
children);
return new Ipv4NumToString(children.get(0));
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4StringToNum.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4StringToNum.java
index 9540fea3073..6e59be9e6cd 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4StringToNum.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4StringToNum.java
@@ -33,7 +33,7 @@ import com.google.common.collect.ImmutableList;
import java.util.List;
/**
- * scalar function Ipv4StringToNum
+ * scalar function ipv4_string_to_num
*/
public class Ipv4StringToNum extends ScalarFunction
implements BinaryExpression, ExplicitlyCastableSignature,
AlwaysNotNullable {
@@ -43,13 +43,13 @@ public class Ipv4StringToNum extends ScalarFunction
FunctionSignature.ret(BigIntType.INSTANCE).args(StringType.INSTANCE));
public Ipv4StringToNum(Expression arg0) {
- super("ipv4stringtonum", arg0);
+ super("ipv4_string_to_num", arg0);
}
@Override
public Ipv4StringToNum withChildren(List<Expression> children) {
Preconditions.checkArgument(children.size() == 1,
- "ipv4stringtonum accept 1 args, but got %s (%s)",
+ "ipv4_string_to_num accept 1 args, but got %s (%s)",
children.size(),
children);
return new Ipv4StringToNum(children.get(0));
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4StringToNumOrDefault.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4StringToNumOrDefault.java
index 4f1f7988e84..214a19b2343 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4StringToNumOrDefault.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4StringToNumOrDefault.java
@@ -33,7 +33,7 @@ import com.google.common.collect.ImmutableList;
import java.util.List;
/**
- * scalar function Ipv4StringToNumOrDefault
+ * scalar function ipv4_string_to_num_or_default
*/
public class Ipv4StringToNumOrDefault extends ScalarFunction
implements BinaryExpression, ExplicitlyCastableSignature,
AlwaysNotNullable {
@@ -43,13 +43,13 @@ public class Ipv4StringToNumOrDefault extends ScalarFunction
FunctionSignature.ret(BigIntType.INSTANCE).args(StringType.INSTANCE));
public Ipv4StringToNumOrDefault(Expression arg0) {
- super("ipv4stringtonumordefault", arg0);
+ super("ipv4_string_to_num_or_default", arg0);
}
@Override
public Ipv4StringToNumOrDefault withChildren(List<Expression> children) {
Preconditions.checkArgument(children.size() == 1,
- "ipv4stringtonumordefault accept 1 args, but got %s (%s)",
+ "ipv4_string_to_num_or_default accept 1 args, but got %s (%s)",
children.size(),
children);
return new Ipv4StringToNumOrDefault(children.get(0));
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4StringToNumOrNull.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4StringToNumOrNull.java
index 618593a303a..17a64605494 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4StringToNumOrNull.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv4StringToNumOrNull.java
@@ -33,7 +33,7 @@ import com.google.common.collect.ImmutableList;
import java.util.List;
/**
- * scalar function Ipv4StringToNumOrNull
+ * scalar function ipv4_string_to_num_or_null
*/
public class Ipv4StringToNumOrNull extends ScalarFunction
implements BinaryExpression, ExplicitlyCastableSignature,
AlwaysNullable {
@@ -43,13 +43,13 @@ public class Ipv4StringToNumOrNull extends ScalarFunction
FunctionSignature.ret(BigIntType.INSTANCE).args(StringType.INSTANCE));
public Ipv4StringToNumOrNull(Expression arg0) {
- super("ipv4stringtonumornull", arg0);
+ super("ipv4_string_to_num_or_null", arg0);
}
@Override
public Ipv4StringToNumOrNull withChildren(List<Expression> children) {
Preconditions.checkArgument(children.size() == 1,
- "ipv4stringtonumornull accept 1 args, but got %s (%s)",
+ "ipv4_string_to_num_or_null accept 1 args, but got %s (%s)",
children.size(),
children);
return new Ipv4StringToNumOrNull(children.get(0));
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv6NumToString.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv6NumToString.java
index fafd3fe7a46..ddfde3fb8f3 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv6NumToString.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/Ipv6NumToString.java
@@ -32,7 +32,7 @@ import com.google.common.collect.ImmutableList;
import java.util.List;
/**
- * scalar function Ipv6NumToString
+ * scalar function ipv6_num_to_string
*/
public class Ipv6NumToString extends ScalarFunction
implements BinaryExpression, ExplicitlyCastableSignature,
AlwaysNullable {
@@ -42,13 +42,13 @@ public class Ipv6NumToString extends ScalarFunction
FunctionSignature.ret(StringType.INSTANCE).args(StringType.INSTANCE));
public Ipv6NumToString(Expression arg0) {
- super("ipv6numtostring", arg0);
+ super("ipv6_num_to_string", arg0);
}
@Override
public Ipv6NumToString withChildren(List<Expression> children) {
Preconditions.checkArgument(children.size() == 1,
- "ipv6numtostring accept 1 args, but got %s (%s)",
+ "ipv6_num_to_string accept 1 args, but got %s (%s)",
children.size(),
children);
return new Ipv6NumToString(children.get(0));
diff --git a/gensrc/script/doris_builtins_functions.py
b/gensrc/script/doris_builtins_functions.py
index 77992a539b5..1ec2973f879 100644
--- a/gensrc/script/doris_builtins_functions.py
+++ b/gensrc/script/doris_builtins_functions.py
@@ -1994,18 +1994,18 @@ visible_functions = {
#ip functions
"IP": [
- [['ipv4numtostring','inet_ntoa'], 'VARCHAR', ['TINYINT'],
'ALWAYS_NULLABLE'],
- [['ipv4numtostring','inet_ntoa'], 'VARCHAR', ['SMALLINT'],
'ALWAYS_NULLABLE'],
- [['ipv4numtostring','inet_ntoa'], 'VARCHAR', ['INT'],
'ALWAYS_NULLABLE'],
- [['ipv4numtostring','inet_ntoa'], 'VARCHAR', ['BIGINT'],
'ALWAYS_NULLABLE'],
- [['ipv4stringtonum','inet_aton'], 'BIGINT', ['VARCHAR'],
'ALWAYS_NOT_NULLABLE'],
- [['ipv4stringtonum','inet_aton'], 'BIGINT', ['STRING'],
'ALWAYS_NOT_NULLABLE'],
- [['ipv4stringtonumordefault'], 'BIGINT', ['VARCHAR'],
'ALWAYS_NOT_NULLABLE'],
- [['ipv4stringtonumordefault'], 'BIGINT', ['STRING'],
'ALWAYS_NOT_NULLABLE'],
- [['ipv4stringtonumornull'], 'BIGINT', ['VARCHAR'], 'ALWAYS_NULLABLE'],
- [['ipv4stringtonumornull'], 'BIGINT', ['STRING'], 'ALWAYS_NULLABLE'],
- [['ipv6numtostring','inet6_ntoa'], 'VARCHAR', ['VARCHAR'],
'ALWAYS_NULLABLE'],
- [['ipv6numtostring','inet6_ntoa'], 'STRING', ['STRING'],
'ALWAYS_NULLABLE'],
+ [['ipv4_num_to_string','inet_ntoa'], 'VARCHAR', ['TINYINT'],
'ALWAYS_NULLABLE'],
+ [['ipv4_num_to_string','inet_ntoa'], 'VARCHAR', ['SMALLINT'],
'ALWAYS_NULLABLE'],
+ [['ipv4_num_to_string','inet_ntoa'], 'VARCHAR', ['INT'],
'ALWAYS_NULLABLE'],
+ [['ipv4_num_to_string','inet_ntoa'], 'VARCHAR', ['BIGINT'],
'ALWAYS_NULLABLE'],
+ [['ipv4_string_to_num','inet_aton'], 'BIGINT', ['VARCHAR'],
'ALWAYS_NOT_NULLABLE'],
+ [['ipv4_string_to_num','inet_aton'], 'BIGINT', ['STRING'],
'ALWAYS_NOT_NULLABLE'],
+ [['ipv4_string_to_num_or_default'], 'BIGINT', ['VARCHAR'],
'ALWAYS_NOT_NULLABLE'],
+ [['ipv4_string_to_num_or_default'], 'BIGINT', ['STRING'],
'ALWAYS_NOT_NULLABLE'],
+ [['ipv4_string_to_num_or_null'], 'BIGINT', ['VARCHAR'],
'ALWAYS_NULLABLE'],
+ [['ipv4_string_to_num_or_null'], 'BIGINT', ['STRING'],
'ALWAYS_NULLABLE'],
+ [['ipv6_num_to_string','inet6_ntoa'], 'VARCHAR', ['VARCHAR'],
'ALWAYS_NULLABLE'],
+ [['ipv6_num_to_string','inet6_ntoa'], 'STRING', ['STRING'],
'ALWAYS_NULLABLE'],
[['ipv6_string_to_num','inet6_aton'], 'VARCHAR', ['VARCHAR'],
'ALWAYS_NOT_NULLABLE'],
[['ipv6_string_to_num','inet6_aton'], 'STRING', ['STRING'],
'ALWAYS_NOT_NULLABLE'],
[['ipv6_string_to_num_or_default'], 'VARCHAR', ['VARCHAR'],
'ALWAYS_NOT_NULLABLE'],
diff --git a/regression-test/suites/nereids_function_p0/ip_functions.groovy
b/regression-test/suites/nereids_function_p0/ip_functions.groovy
index 76accd986dc..837eca9211b 100644
--- a/regression-test/suites/nereids_function_p0/ip_functions.groovy
+++ b/regression-test/suites/nereids_function_p0/ip_functions.groovy
@@ -17,29 +17,29 @@
suite("ip_functions") {
sql "set batch_size = 4096;"
- qt_ip1 "SELECT ipv4numtostring(-1);"
- qt_ip2 "SELECT ipv4numtostring(2130706433);"
- qt_ip3 "SELECT ipv4numtostring(4294967298);"
- qt_ip4 "SELECT ipv4numtostring(3232235521);"
+ qt_ip1 "SELECT ipv4_num_to_string(-1);"
+ qt_ip2 "SELECT ipv4_num_to_string(2130706433);"
+ qt_ip3 "SELECT ipv4_num_to_string(4294967298);"
+ qt_ip4 "SELECT ipv4_num_to_string(3232235521);"
qt_ip5 "SELECT inet_ntoa(-1);"
qt_ip6 "SELECT inet_ntoa(2130706433);"
qt_ip7 "SELECT inet_ntoa(4294967298);"
qt_ip8 "SELECT inet_ntoa(3232235521);"
- qt_ip9 "SELECT ipv4stringtonum('127.0.0.1');"
- qt_ip10 "SELECT ipv4stringtonumornull('');"
- qt_ip11 "SELECT ipv4stringtonumordefault('');"
+ qt_ip9 "SELECT ipv4_string_to_num('127.0.0.1');"
+ qt_ip10 "SELECT ipv4_string_to_num_or_null('');"
+ qt_ip11 "SELECT ipv4_string_to_num_or_default('');"
qt_ip12 "SELECT inet_aton('192.168.0.1');"
- qt_ip13 "SELECT ipv6numtostring(unhex('0A0005091'));"
- qt_ip14 "SELECT
ipv6numtostring(unhex('2A0206B8000000000000000000000011'));"
- qt_ip15 "SELECT
ipv6numtostring(unhex('FDFE0000000000005A55CAFFFEFA9089'));"
- qt_ip16 "SELECT ipv6numtostring(unhex(''));"
- qt_ip17 "SELECT ipv6numtostring(unhex('KK'));"
- qt_ip18 "SELECT ipv6numtostring(unhex('0A000509'));"
- qt_ip19 "SELECT ipv6numtostring(unhex('abcd123456'));"
- qt_ip20 "SELECT
ipv6numtostring(unhex('ffffffffffffffffffffffffffffffffffffffffffffffffffffff'));"
+ qt_ip13 "SELECT ipv6_num_to_string(unhex('0A0005091'));"
+ qt_ip14 "SELECT
ipv6_num_to_string(unhex('2A0206B8000000000000000000000011'));"
+ qt_ip15 "SELECT
ipv6_num_to_string(unhex('FDFE0000000000005A55CAFFFEFA9089'));"
+ qt_ip16 "SELECT ipv6_num_to_string(unhex(''));"
+ qt_ip17 "SELECT ipv6_num_to_string(unhex('KK'));"
+ qt_ip18 "SELECT ipv6_num_to_string(unhex('0A000509'));"
+ qt_ip19 "SELECT ipv6_num_to_string(unhex('abcd123456'));"
+ qt_ip20 "SELECT
ipv6_num_to_string(unhex('ffffffffffffffffffffffffffffffffffffffffffffffffffffff'));"
qt_ip21 "SELECT inet6_ntoa(unhex('0A0005091'));"
qt_ip22 "SELECT inet6_ntoa(unhex('2A0206B8000000000000000000000011'));"
qt_ip23 "SELECT inet6_ntoa(unhex(NULL));"
diff --git
a/regression-test/suites/query_p0/sql_functions/ip_functions/test_ip_functions.groovy
b/regression-test/suites/query_p0/sql_functions/ip_functions/test_ip_functions.groovy
index 633ff9ddf42..828de6cbe41 100644
---
a/regression-test/suites/query_p0/sql_functions/ip_functions/test_ip_functions.groovy
+++
b/regression-test/suites/query_p0/sql_functions/ip_functions/test_ip_functions.groovy
@@ -17,24 +17,24 @@
suite("test_ip_functions", "arrow_flight_sql") {
sql "set batch_size = 4096;"
- qt_sql "SELECT ipv4numtostring(-1);"
- qt_sql "SELECT ipv4numtostring(2130706433);"
- qt_sql "SELECT ipv4numtostring(4294967298);"
+ qt_sql "SELECT ipv4_num_to_string(-1);"
+ qt_sql "SELECT ipv4_num_to_string(2130706433);"
+ qt_sql "SELECT ipv4_num_to_string(4294967298);"
qt_sql "SELECT inet_ntoa(3232235521);"
- qt_sql "SELECT ipv4stringtonum('127.0.0.1');"
- qt_sql "SELECT ipv4stringtonumornull('');"
- qt_sql "SELECT ipv4stringtonumordefault('');"
+ qt_sql "SELECT ipv4_string_to_num('127.0.0.1');"
+ qt_sql "SELECT ipv4_string_to_num_or_null('');"
+ qt_sql "SELECT ipv4_string_to_num_or_default('');"
qt_sql "SELECT inet_aton('192.168.0.1');"
- qt_sql "SELECT ipv6numtostring(unhex('0A0005091'));"
- qt_sql "SELECT ipv6numtostring(unhex('2A0206B8000000000000000000000011'));"
- qt_sql "SELECT ipv6numtostring(unhex('FDFE0000000000005A55CAFFFEFA9089'));"
- qt_sql "SELECT ipv6numtostring(unhex(''));"
- qt_sql "SELECT ipv6numtostring(unhex('KK'));"
- qt_sql "SELECT ipv6numtostring(unhex('0A000509'));"
- qt_sql "SELECT ipv6numtostring(unhex('abcd123456'));"
- qt_sql "SELECT
ipv6numtostring(unhex('ffffffffffffffffffffffffffffffffffffffffffffffffffffff'));"
+ qt_sql "SELECT ipv6_num_to_string(unhex('0A0005091'));"
+ qt_sql "SELECT
ipv6_num_to_string(unhex('2A0206B8000000000000000000000011'));"
+ qt_sql "SELECT
ipv6_num_to_string(unhex('FDFE0000000000005A55CAFFFEFA9089'));"
+ qt_sql "SELECT ipv6_num_to_string(unhex(''));"
+ qt_sql "SELECT ipv6_num_to_string(unhex('KK'));"
+ qt_sql "SELECT ipv6_num_to_string(unhex('0A000509'));"
+ qt_sql "SELECT ipv6_num_to_string(unhex('abcd123456'));"
+ qt_sql "SELECT
ipv6_num_to_string(unhex('ffffffffffffffffffffffffffffffffffffffffffffffffffffff'));"
qt_sql "SELECT inet6_ntoa(unhex('0A0005091'));"
qt_sql "SELECT inet6_ntoa(unhex('2A0206B8000000000000000000000011'));"
qt_sql "SELECT inet6_ntoa(unhex(NULL));"
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
