This is an automated email from the ASF dual-hosted git repository.

airborne 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 c3e6702d287 branch-2.1: [fix](array-funcs)fix array funcs which ret 
can be nullable (#43354)
c3e6702d287 is described below

commit c3e6702d287b9294c9258aa768e7d5490377bc6e
Author: github-actions[bot] 
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Nov 7 18:28:50 2024 +0800

    branch-2.1: [fix](array-funcs)fix array funcs which ret can be nullable 
(#43354)
    
    Cherry-picked from #43243
    
    Co-authored-by: amory <wangqian...@selectdb.com>
---
 .../vec/functions/array/function_array_distance.h  |  2 +-
 .../vec/functions/array/function_array_element.h   |  2 +-
 be/src/vec/functions/array/function_array_index.h  |  8 ++---
 .../test_array_with_inverted_index_all_type.out    | 36 ++++++++++++++++++----
 .../test_array_with_inverted_index_all_type.groovy |  4 +++
 5 files changed, 40 insertions(+), 12 deletions(-)

diff --git a/be/src/vec/functions/array/function_array_distance.h 
b/be/src/vec/functions/array/function_array_distance.h
index fac25e1cb88..641c2f03813 100644
--- a/be/src/vec/functions/array/function_array_distance.h
+++ b/be/src/vec/functions/array/function_array_distance.h
@@ -121,7 +121,7 @@ public:
         // prepare return data
         auto dst = ColumnVector<Float64>::create(input_rows_count);
         auto& dst_data = dst->get_data();
-        auto dst_null_column = ColumnUInt8::create(input_rows_count);
+        auto dst_null_column = ColumnUInt8::create(input_rows_count, 0);
         auto& dst_null_data = dst_null_column->get_data();
 
         const auto& offsets1 = *arr1.offsets_ptr;
diff --git a/be/src/vec/functions/array/function_array_element.h 
b/be/src/vec/functions/array/function_array_element.h
index fef7aa3beab..eae1f1294c5 100644
--- a/be/src/vec/functions/array/function_array_element.h
+++ b/be/src/vec/functions/array/function_array_element.h
@@ -96,7 +96,7 @@ public:
 
     Status execute_impl(FunctionContext* context, Block& block, const 
ColumnNumbers& arguments,
                         size_t result, size_t input_rows_count) const override 
{
-        auto dst_null_column = ColumnUInt8::create(input_rows_count);
+        auto dst_null_column = ColumnUInt8::create(input_rows_count, 0);
         UInt8* dst_null_map = dst_null_column->get_data().data();
         const UInt8* src_null_map = nullptr;
         ColumnsWithTypeAndName args;
diff --git a/be/src/vec/functions/array/function_array_index.h 
b/be/src/vec/functions/array/function_array_index.h
index a2e26c2d212..b313c8385d9 100644
--- a/be/src/vec/functions/array/function_array_index.h
+++ b/be/src/vec/functions/array/function_array_index.h
@@ -194,9 +194,9 @@ private:
         const auto& right_chars = reinterpret_cast<const 
ColumnString&>(right_column).get_chars();
 
         // prepare return data
-        auto dst = ColumnVector<ResultType>::create(offsets.size());
+        auto dst = ColumnVector<ResultType>::create(offsets.size(), 0);
         auto& dst_data = dst->get_data();
-        auto dst_null_column = ColumnUInt8::create(offsets.size());
+        auto dst_null_column = ColumnUInt8::create(offsets.size(), 0);
         auto& dst_null_data = dst_null_column->get_data();
 
         // process
@@ -266,9 +266,9 @@ private:
         const auto& right_data = reinterpret_cast<const 
RightColumnType&>(right_column).get_data();
 
         // prepare return data
-        auto dst = ColumnVector<ResultType>::create(offsets.size());
+        auto dst = ColumnVector<ResultType>::create(offsets.size(), 0);
         auto& dst_data = dst->get_data();
-        auto dst_null_column = ColumnUInt8::create(offsets.size());
+        auto dst_null_column = ColumnUInt8::create(offsets.size(), 0);
         auto& dst_null_data = dst_null_column->get_data();
 
         // process
diff --git 
a/regression-test/data/inverted_index_p0/test_array_with_inverted_index_all_type.out
 
b/regression-test/data/inverted_index_p0/test_array_with_inverted_index_all_type.out
index 966ff5a6d5a..8801dd53566 100644
--- 
a/regression-test/data/inverted_index_p0/test_array_with_inverted_index_all_type.out
+++ 
b/regression-test/data/inverted_index_p0/test_array_with_inverted_index_all_type.out
@@ -1,6 +1,24 @@
 -- This file is automatically generated. You should know what you did if you 
want to edit this
+-- !sql_null --
+101    \N      \N      \N      \N      \N      \N      \N      \N      \N      
\N      \N      \N      \N
+
+-- !sql_null --
+101    \N      \N      \N      \N
+
+-- !sql_null --
+101    \N      \N      \N      \N      \N      \N      \N      \N      \N      
\N      \N      \N      \N
+
+-- !sql_null --
+101    \N      \N      \N      \N
+
+-- !sql_null --
+101    \N      \N      \N      \N      \N      \N      \N      \N      \N      
\N      \N      \N      \N
+
+-- !sql_null --
+101    \N      \N      \N      \N
+
 -- !sql_count --
-101
+102
 
 -- !sql_array_contains --
 0      1
@@ -900,6 +918,7 @@
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 
 -- !sql --
+\N     0
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
@@ -1003,7 +1022,7 @@
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 
 -- !sql_count --
-101
+102
 
 -- !sql_array_contains --
 0      1
@@ -1497,6 +1516,7 @@
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 
 -- !sql --
+\N     0
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
@@ -1600,7 +1620,7 @@
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 
 -- !sql_count --
-101
+102
 
 -- !sql_array_contains --
 0      1
@@ -2500,6 +2520,7 @@
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 
 -- !sql --
+\N     0
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
@@ -2603,7 +2624,7 @@
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 
 -- !sql_count --
-101
+102
 
 -- !sql_array_contains --
 0      1
@@ -3097,6 +3118,7 @@
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 
 -- !sql --
+\N     0
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
@@ -3200,7 +3222,7 @@
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 
 -- !sql_count --
-101
+102
 
 -- !sql_array_contains --
 0      1
@@ -4100,6 +4122,7 @@
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 
 -- !sql --
+\N     0
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
@@ -4203,7 +4226,7 @@
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 
 -- !sql_count --
-101
+102
 
 -- !sql_array_contains --
 0      1
@@ -4697,6 +4720,7 @@
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 
 -- !sql --
+\N     0
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
 ["2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", 
"2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", "2024-04-29", " [...]
diff --git 
a/regression-test/suites/inverted_index_p0/test_array_with_inverted_index_all_type.groovy
 
b/regression-test/suites/inverted_index_p0/test_array_with_inverted_index_all_type.groovy
index 75e38dc7a63..6b0c4b89f28 100644
--- 
a/regression-test/suites/inverted_index_p0/test_array_with_inverted_index_all_type.groovy
+++ 
b/regression-test/suites/inverted_index_p0/test_array_with_inverted_index_all_type.groovy
@@ -267,6 +267,10 @@ suite("test_array_with_inverted_index_all_type"){
                 assertEquals(101, json.NumberLoadedRows)
             }
         }
+
+        // insert into null array
+        sql """insert into ${tableName} (k1) values(101);"""
+        qt_sql_null """ select * from ${tableName} where k1 = 101; """
     }
 
     // stream load with table


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to