This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 20bd0c2987e0edc0314caf8f0cc20ba49dc65f07
Author: amory <wangqian...@selectdb.com>
AuthorDate: Sun Apr 28 10:59:54 2024 +0800
[FIX](cases )fix ipv6 value for regress case
---
.../test_ipv6_cidr_to_range_function.out | 28 +++++++++++-----------
.../test_ipv6_cidr_to_range_function.groovy | 13 ++++++++--
2 files changed, 25 insertions(+), 16 deletions(-)
diff --git
a/regression-test/data/query_p0/sql_functions/ip_functions/test_ipv6_cidr_to_range_function.out
b/regression-test/data/query_p0/sql_functions/ip_functions/test_ipv6_cidr_to_range_function.out
index 201af35987a..84d0abfde6d 100644
---
a/regression-test/data/query_p0/sql_functions/ip_functions/test_ipv6_cidr_to_range_function.out
+++
b/regression-test/data/query_p0/sql_functions/ip_functions/test_ipv6_cidr_to_range_function.out
@@ -23,23 +23,23 @@
-- !sql --
1 {"min": "::", "max": "ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-4 {"min": "3132:372e::", "max": "3132:372e:ffff:ffff:ffff:ffff:ffff:ffff"}
-5 {"min": "3132::", "max": "3132:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-7 {"min": "b000::", "max": "bfff:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-8 {"min": "be00::", "max": "beff:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+4 {"min": "::", "max": "::ffff:ffff:ffff:ffff:ffff:ffff"}
+5 {"min": "::", "max": "0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+7 {"min": "::", "max": "fff:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+8 {"min": "::", "max": "ff:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
9 \N
-- !sql --
-0 {"min": "3132::", "max": "3132:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-1 {"min": "3132::", "max": "3132:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-2 {"min": "3132::", "max": "3132:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-3 {"min": "3132::", "max": "3132:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-4 {"min": "3132::", "max": "3132:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-5 {"min": "3132::", "max": "3132:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-6 {"min": "3132::", "max": "3132:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-7 {"min": "3132::", "max": "3132:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-8 {"min": "3132::", "max": "3132:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-9 {"min": "3132::", "max": "3132:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+0 {"min": "::", "max": "0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+1 {"min": "::", "max": "0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+2 {"min": "::", "max": "0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+3 {"min": "::", "max": "0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+4 {"min": "::", "max": "0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+5 {"min": "::", "max": "0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+6 {"min": "::", "max": "0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+7 {"min": "::", "max": "0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+8 {"min": "::", "max": "0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+9 {"min": "::", "max": "0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
-- !sql --
1 :: ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
diff --git
a/regression-test/suites/query_p0/sql_functions/ip_functions/test_ipv6_cidr_to_range_function.groovy
b/regression-test/suites/query_p0/sql_functions/ip_functions/test_ipv6_cidr_to_range_function.groovy
index d1fe0e2761a..41432c986fe 100644
---
a/regression-test/suites/query_p0/sql_functions/ip_functions/test_ipv6_cidr_to_range_function.groovy
+++
b/regression-test/suites/query_p0/sql_functions/ip_functions/test_ipv6_cidr_to_range_function.groovy
@@ -50,8 +50,17 @@ suite("test_ipv6_cidr_to_range_function") {
qt_sql "select id, struct_element(ipv6_cidr_to_range(addr, cidr), 'min')
as min_range, struct_element(ipv6_cidr_to_range(addr, cidr), 'max') as
max_range from test_ipv6_cidr_to_range_function order by id"
qt_sql "select id, ipv6_cidr_to_range(addr, 16) from
test_ipv6_cidr_to_range_function order by id;"
sql """ delete from test_ipv6_cidr_to_range_function where id in
(2,3,6);"""
- qt_sql """ select id, ipv6_cidr_to_range("127.0.0.1", cidr) from
test_ipv6_cidr_to_range_function order by id;"""
- qt_sql """ select number, ipv6_cidr_to_range("127.0.0.1", 16) from
numbers("number"="10") order by number;"""
+ test {
+ sql """select id, ipv6_cidr_to_range(to_ipv6("127.0.0.1"), cidr) from
test_ipv6_cidr_to_range_function order by id;"""
+ exception "Invalid IPv6 value '127.0.0.1'"
+ }
+ test {
+ sql """ select number, ipv6_cidr_to_range(to_ipv6("127.0.0.1"), 16) from
numbers("number"="10") order by number;"""
+ exception "Invalid IPv6 value '127.0.0.1'"
+ }
+ qt_sql """ select id, ipv6_cidr_to_range(to_ipv6("::1"), cidr) from
test_ipv6_cidr_to_range_function order by id; """
+ qt_sql """ select number, ipv6_cidr_to_range(to_ipv6("::1"), 16) from
numbers("number"="10") order by number;"""
+
sql """ DROP TABLE IF EXISTS test_ipv6_cidr_to_range_function """
sql """ DROP TABLE IF EXISTS test_str_cidr_to_range_function """
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
