This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new 59663541657 [FIX](cases)fix cases for test_ip_in_inverted_index
(#35971)
59663541657 is described below
commit 5966354165746e7e5314e5d1fffe75ace97ba9a1
Author: amory <wangqian...@selectdb.com>
AuthorDate: Thu Jun 6 21:52:53 2024 +0800
[FIX](cases)fix cases for test_ip_in_inverted_index (#35971)
bp #35881
---
.../datatype_p0/ip/test_ip_in_inverted_index.out | 104 ++++++++++-----------
.../ip/test_ip_in_inverted_index.groovy | 4 +-
2 files changed, 54 insertions(+), 54 deletions(-)
diff --git a/regression-test/data/datatype_p0/ip/test_ip_in_inverted_index.out
b/regression-test/data/datatype_p0/ip/test_ip_in_inverted_index.out
index 5216a275c54..3b0bd6d604b 100644
--- a/regression-test/data/datatype_p0/ip/test_ip_in_inverted_index.out
+++ b/regression-test/data/datatype_p0/ip/test_ip_in_inverted_index.out
@@ -1,23 +1,23 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !sql_index_1 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-- !sql_index_2 --
-2 42.117.228.166 2001:16a0:2:200a::2
-3 119.36.22.147 2001:4888:1f:e891:161:26::
+112 42.117.228.166 2001:16a0:2:200a::2
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql_index_3 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-- !sql_index_4 --
-2 42.117.228.166 2001:16a0:2:200a::2
+112 42.117.228.166 2001:16a0:2:200a::2
-- !sql_index_4 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-3 119.36.22.147 2001:4888:1f:e891:161:26::
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql_index_5 --
-2 42.117.228.166 2001:16a0:2:200a::2
+112 42.117.228.166 2001:16a0:2:200a::2
-- !sql_index_6 --
@@ -26,39 +26,39 @@
-- !sql_index_8 --
-- !sql_index_9 --
-3 119.36.22.147 2001:4888:1f:e891:161:26::
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql_index_10 --
-2 42.117.228.166 2001:16a0:2:200a::2
+112 42.117.228.166 2001:16a0:2:200a::2
-- !sql_index_11 --
-3 119.36.22.147 2001:4888:1f:e891:161:26::
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql_index_12 --
-- !sql_index_13 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-3 119.36.22.147 2001:4888:1f:e891:161:26::
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql1 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-- !sql2 --
-2 42.117.228.166 2001:16a0:2:200a::2
-3 119.36.22.147 2001:4888:1f:e891:161:26::
+112 42.117.228.166 2001:16a0:2:200a::2
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql3 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-- !sql4 --
-2 42.117.228.166 2001:16a0:2:200a::2
+112 42.117.228.166 2001:16a0:2:200a::2
-- !sql4 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-3 119.36.22.147 2001:4888:1f:e891:161:26::
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql5 --
-2 42.117.228.166 2001:16a0:2:200a::2
+112 42.117.228.166 2001:16a0:2:200a::2
-- !sql6 --
@@ -67,35 +67,34 @@
-- !sql8 --
-- !sql9 --
-3 119.36.22.147 2001:4888:1f:e891:161:26::
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql10 --
-2 42.117.228.166 2001:16a0:2:200a::2
+112 42.117.228.166 2001:16a0:2:200a::2
-- !sql11 --
-3 119.36.22.147 2001:4888:1f:e891:161:26::
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql12 --
-- !sql13 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-3 119.36.22.147 2001:4888:1f:e891:161:26::
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql --
103
-- !sql_index_1 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
84 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-- !sql_index_2 --
-2 42.117.228.166 2001:16a0:2:200a::2
-3 119.36.22.147 2001:4888:1f:e891:161:26::
85 42.117.228.166 2001:16a0:2:200a::2
86 119.36.22.147 2001:4888:1f:e891:161:26::
+112 42.117.228.166 2001:16a0:2:200a::2
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql_index_3 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
1 116.253.40.133 2606:2b00::1
2 183.247.232.58 2001:2000:3080:1351::2
3 116.106.34.242 2a01:8840:16::1
@@ -194,20 +193,20 @@
98 171.229.231.90 2001:550:2:48::34:1
99 58.19.84.138 2a03:9d40:fe00:5::
100 36.79.88.107 2403:e800:200:102::2
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-- !sql_index_4 --
-2 42.117.228.166 2001:16a0:2:200a::2
85 42.117.228.166 2001:16a0:2:200a::2
+112 42.117.228.166 2001:16a0:2:200a::2
-- !sql_index_4 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-3 119.36.22.147 2001:4888:1f:e891:161:26::
84 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
86 119.36.22.147 2001:4888:1f:e891:161:26::
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql_index_5 --
1 116.253.40.133 2606:2b00::1
-2 42.117.228.166 2001:16a0:2:200a::2
2 183.247.232.58 2001:2000:3080:1351::2
3 116.106.34.242 2a01:8840:16::1
4 111.56.27.171 2001:550:0:1000::9a36:2a61
@@ -305,6 +304,7 @@
98 171.229.231.90 2001:550:2:48::34:1
99 58.19.84.138 2a03:9d40:fe00:5::
100 36.79.88.107 2403:e800:200:102::2
+112 42.117.228.166 2001:16a0:2:200a::2
-- !sql_index_6 --
21 36.186.75.121 2001:fb1:fe0:9::8
@@ -317,12 +317,11 @@
30 117.150.98.199 2a01:b740:a09::1
-- !sql_index_9 --
-3 119.36.22.147 2001:4888:1f:e891:161:26::
30 117.150.98.199 2a01:b740:a09::1
86 119.36.22.147 2001:4888:1f:e891:161:26::
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql_index_10 --
-2 42.117.228.166 2001:16a0:2:200a::2
21 36.186.75.121 2001:fb1:fe0:9::8
37 36.183.59.29 2a0a:6f40:2::1
42 36.183.126.25 2a04:2dc0::16d
@@ -339,10 +338,10 @@
93 58.16.171.31 2001:13c7:6014::1
99 58.19.84.138 2a03:9d40:fe00:5::
100 36.79.88.107 2403:e800:200:102::2
+112 42.117.228.166 2001:16a0:2:200a::2
-- !sql_index_11 --
2 183.247.232.58 2001:2000:3080:1351::2
-3 119.36.22.147 2001:4888:1f:e891:161:26::
5 183.245.137.140 2001:578:400:4:2000::19
6 183.212.25.70 2607:f290::1
7 162.144.2.57 2a02:23f0:ffff:8::5
@@ -378,6 +377,7 @@
91 210.183.19.113 2001:920:1833::1
94 171.234.78.185 2003:0:1203:4001::1
98 171.229.231.90 2001:550:2:48::34:1
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql_index_12 --
4 111.56.27.171 2001:550:0:1000::9a36:2a61
@@ -410,9 +410,7 @@
98 171.229.231.90 2001:550:2:48::34:1
-- !sql_index_13 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
1 116.253.40.133 2606:2b00::1
-3 119.36.22.147 2001:4888:1f:e891:161:26::
3 116.106.34.242 2a01:8840:16::1
6 183.212.25.70 2607:f290::1
7 162.144.2.57 2a02:23f0:ffff:8::5
@@ -473,19 +471,20 @@
96 111.53.182.225 2a02:2e00:2080:f000:0:261:1:11
99 58.19.84.138 2a03:9d40:fe00:5::
100 36.79.88.107 2403:e800:200:102::2
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql1 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
84 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-- !sql2 --
-2 42.117.228.166 2001:16a0:2:200a::2
-3 119.36.22.147 2001:4888:1f:e891:161:26::
85 42.117.228.166 2001:16a0:2:200a::2
86 119.36.22.147 2001:4888:1f:e891:161:26::
+112 42.117.228.166 2001:16a0:2:200a::2
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql3 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
1 116.253.40.133 2606:2b00::1
2 183.247.232.58 2001:2000:3080:1351::2
3 116.106.34.242 2a01:8840:16::1
@@ -584,20 +583,20 @@
98 171.229.231.90 2001:550:2:48::34:1
99 58.19.84.138 2a03:9d40:fe00:5::
100 36.79.88.107 2403:e800:200:102::2
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-- !sql4 --
-2 42.117.228.166 2001:16a0:2:200a::2
85 42.117.228.166 2001:16a0:2:200a::2
+112 42.117.228.166 2001:16a0:2:200a::2
-- !sql4 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
-3 119.36.22.147 2001:4888:1f:e891:161:26::
84 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
86 119.36.22.147 2001:4888:1f:e891:161:26::
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql5 --
1 116.253.40.133 2606:2b00::1
-2 42.117.228.166 2001:16a0:2:200a::2
2 183.247.232.58 2001:2000:3080:1351::2
3 116.106.34.242 2a01:8840:16::1
4 111.56.27.171 2001:550:0:1000::9a36:2a61
@@ -695,6 +694,7 @@
98 171.229.231.90 2001:550:2:48::34:1
99 58.19.84.138 2a03:9d40:fe00:5::
100 36.79.88.107 2403:e800:200:102::2
+112 42.117.228.166 2001:16a0:2:200a::2
-- !sql6 --
21 36.186.75.121 2001:fb1:fe0:9::8
@@ -707,12 +707,11 @@
30 117.150.98.199 2a01:b740:a09::1
-- !sql9 --
-3 119.36.22.147 2001:4888:1f:e891:161:26::
30 117.150.98.199 2a01:b740:a09::1
86 119.36.22.147 2001:4888:1f:e891:161:26::
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql10 --
-2 42.117.228.166 2001:16a0:2:200a::2
21 36.186.75.121 2001:fb1:fe0:9::8
37 36.183.59.29 2a0a:6f40:2::1
42 36.183.126.25 2a04:2dc0::16d
@@ -729,10 +728,10 @@
93 58.16.171.31 2001:13c7:6014::1
99 58.19.84.138 2a03:9d40:fe00:5::
100 36.79.88.107 2403:e800:200:102::2
+112 42.117.228.166 2001:16a0:2:200a::2
-- !sql11 --
2 183.247.232.58 2001:2000:3080:1351::2
-3 119.36.22.147 2001:4888:1f:e891:161:26::
5 183.245.137.140 2001:578:400:4:2000::19
6 183.212.25.70 2607:f290::1
7 162.144.2.57 2a02:23f0:ffff:8::5
@@ -768,6 +767,7 @@
91 210.183.19.113 2001:920:1833::1
94 171.234.78.185 2003:0:1203:4001::1
98 171.229.231.90 2001:550:2:48::34:1
+113 119.36.22.147 2001:4888:1f:e891:161:26::
-- !sql12 --
4 111.56.27.171 2001:550:0:1000::9a36:2a61
@@ -800,9 +800,7 @@
98 171.229.231.90 2001:550:2:48::34:1
-- !sql13 --
-1 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
1 116.253.40.133 2606:2b00::1
-3 119.36.22.147 2001:4888:1f:e891:161:26::
3 116.106.34.242 2a01:8840:16::1
6 183.212.25.70 2607:f290::1
7 162.144.2.57 2a02:23f0:ffff:8::5
@@ -863,4 +861,6 @@
96 111.53.182.225 2a02:2e00:2080:f000:0:261:1:11
99 58.19.84.138 2a03:9d40:fe00:5::
100 36.79.88.107 2403:e800:200:102::2
+111 59.50.185.152 2a02:e980:83:5b09:ecb8:c669:b336:650e
+113 119.36.22.147 2001:4888:1f:e891:161:26::
diff --git
a/regression-test/suites/datatype_p0/ip/test_ip_in_inverted_index.groovy
b/regression-test/suites/datatype_p0/ip/test_ip_in_inverted_index.groovy
index 5b31698f9bc..79aee287a37 100644
--- a/regression-test/suites/datatype_p0/ip/test_ip_in_inverted_index.groovy
+++ b/regression-test/suites/datatype_p0/ip/test_ip_in_inverted_index.groovy
@@ -37,8 +37,8 @@ suite("test_ip_in_inverted_index") {
);
"""
- sql """insert into test_ip_with_inverted_index values(1, '59.50.185.152',
'2a02:e980:83:5b09:ecb8:c669:b336:650e'),(3, '119.36.22.147',
'2001:4888:1f:e891:161:26::')"""
- sql "insert into test_ip_with_inverted_index values(2, '42.117.228.166',
'2001:16a0:2:200a::2')"
+ sql """insert into test_ip_with_inverted_index values(111,
'59.50.185.152', '2a02:e980:83:5b09:ecb8:c669:b336:650e'),(113,
'119.36.22.147', '2001:4888:1f:e891:161:26::')"""
+ sql "insert into test_ip_with_inverted_index values(112, '42.117.228.166',
'2001:16a0:2:200a::2')"
// query with inverted index and no inverted index
sql """set enable_inverted_index_query=true; """
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
