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

dataroaring pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/branch-3.0 by this push:
     new 3c8c8e412ac branch-3.0: [fix](array-funcs)fix array funcs which ret 
can be nullable (#43353)
3c8c8e412ac is described below

commit 3c8c8e412ac40f7ae197fff0edaf85d999ed9553
Author: github-actions[bot] 
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Nov 7 14:18:24 2024 +0800

    branch-3.0: [fix](array-funcs)fix array funcs which ret can be nullable 
(#43353)
    
    Cherry-picked from #43243
    
    Co-authored-by: amory <[email protected]>
---
 .../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 fa05196e5e1..5284a3838ad 100644
--- a/be/src/vec/functions/array/function_array_distance.h
+++ b/be/src/vec/functions/array/function_array_distance.h
@@ -123,7 +123,7 @@ public:
         // prepare return data
         auto dst = ColumnFloat64::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 4a9bffdbb3c..60a353b9eb0 100644
--- a/be/src/vec/functions/array/function_array_element.h
+++ b/be/src/vec/functions/array/function_array_element.h
@@ -97,7 +97,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 ec31277c36c..25a43973095 100644
--- a/be/src/vec/functions/array/function_array_index.h
+++ b/be/src/vec/functions/array/function_array_index.h
@@ -217,9 +217,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
@@ -286,9 +286,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 09663b5c10a..e3255beb8a8 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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to