Coverage Report

Created: 2026-06-09 00:35

next uncovered line (L), next uncovered region (R), next uncovered branch (B)
be/src/exprs/function/function.cpp
Line
Count
Source
1
// Licensed to the Apache Software Foundation (ASF) under one
2
// or more contributor license agreements.  See the NOTICE file
3
// distributed with this work for additional information
4
// regarding copyright ownership.  The ASF licenses this file
5
// to you under the Apache License, Version 2.0 (the
6
// "License"); you may not use this file except in compliance
7
// with the License.  You may obtain a copy of the License at
8
//
9
//   http://www.apache.org/licenses/LICENSE-2.0
10
//
11
// Unless required by applicable law or agreed to in writing,
12
// software distributed under the License is distributed on an
13
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
14
// KIND, either express or implied.  See the License for the
15
// specific language governing permissions and limitations
16
// under the License.
17
// This file is copied from
18
// https://github.com/ClickHouse/ClickHouse/blob/master/src/Functions/IFunction.cpp
19
// and modified by Doris
20
21
#include "exprs/function/function.h"
22
23
#include <algorithm>
24
#include <memory>
25
#include <numeric>
26
27
#include "common/status.h"
28
#include "core/assert_cast.h"
29
#include "core/column/column.h"
30
#include "core/column/column_const.h"
31
#include "core/column/column_nullable.h"
32
#include "core/column/column_vector.h"
33
#include "core/data_type/data_type_array.h"
34
#include "core/data_type/data_type_nothing.h"
35
#include "core/data_type/data_type_nullable.h"
36
#include "core/data_type/define_primitive_type.h"
37
#include "core/data_type/primitive_type.h"
38
#include "core/field.h"
39
#include "exec/common/util.hpp"
40
#include "exprs/aggregate/aggregate_function.h"
41
#include "exprs/function/function_helpers.h"
42
43
namespace doris {
44
ColumnPtr wrap_in_nullable(const ColumnPtr& src, const Block& block, const ColumnNumbers& args,
45
513k
                           size_t input_rows_count) {
46
513k
    ColumnPtr result_null_map_column;
47
    /// If result is already nullable.
48
513k
    ColumnPtr src_not_nullable = src;
49
513k
    MutableColumnPtr mutable_result_null_map_column;
50
51
513k
    if (auto nullable = check_and_get_column_ptr<ColumnNullable>(src)) {
52
45.2k
        src_not_nullable = nullable->get_nested_column_ptr();
53
45.2k
        result_null_map_column = nullable->get_null_map_column_ptr();
54
45.2k
    }
55
56
914k
    for (const auto& arg : args) {
57
914k
        const ColumnWithTypeAndName& elem = block.get_by_position(arg);
58
914k
        if (!elem.type->is_nullable() || is_column_const(*elem.column)) {
59
383k
            continue;
60
383k
        }
61
62
531k
        if (auto nullable = cast_to_column<ColumnNullable>(elem.column); nullable->has_null()) {
63
120k
            const ColumnPtr& null_map_column = nullable->get_null_map_column_ptr();
64
120k
            if (!result_null_map_column) { // NOLINT(bugprone-use-after-move)
65
119k
                result_null_map_column = null_map_column->clone_resized(input_rows_count);
66
119k
                continue;
67
119k
            }
68
69
400
            if (!mutable_result_null_map_column) {
70
375
                mutable_result_null_map_column = (*std::move(result_null_map_column)).mutate();
71
375
            }
72
73
400
            NullMap& result_null_map =
74
400
                    assert_cast<ColumnUInt8&>(*mutable_result_null_map_column).get_data();
75
400
            const NullMap& src_null_map =
76
400
                    assert_cast<const ColumnUInt8&>(*null_map_column).get_data();
77
78
400
            VectorizedUtils::update_null_map(result_null_map, src_null_map);
79
400
        }
80
531k
    }
81
82
    // Commit merged null map back: result_null_map_column was moved into
83
    // mutable_result_null_map_column when merging 2+ nullable args with nulls.
84
513k
    if (mutable_result_null_map_column) {
85
375
        result_null_map_column = std::move(mutable_result_null_map_column);
86
375
    }
87
88
513k
    if (!result_null_map_column) {
89
348k
        if (is_column_const(*src)) {
90
2
            return ColumnConst::create(
91
2
                    make_nullable(assert_cast<const ColumnConst&>(*src).get_data_column_ptr(),
92
2
                                  false),
93
2
                    input_rows_count);
94
2
        }
95
348k
        return ColumnNullable::create(src, ColumnUInt8::create(input_rows_count, 0));
96
348k
    }
97
98
164k
    return ColumnNullable::create(src_not_nullable, result_null_map_column);
99
513k
}
100
101
794k
bool have_null_column(const Block& block, const ColumnNumbers& args) {
102
1.21M
    return std::ranges::any_of(args, [&block](const auto& elem) {
103
1.21M
        return block.get_by_position(elem).type->is_nullable();
104
1.21M
    });
105
794k
}
106
107
254k
bool have_null_column(const ColumnsWithTypeAndName& args) {
108
455k
    return std::ranges::any_of(args, [](const auto& elem) { return elem.type->is_nullable(); });
109
254k
}
110
111
inline Status PreparedFunctionImpl::_execute_skipped_constant_deal(FunctionContext* context,
112
                                                                   Block& block,
113
                                                                   const ColumnNumbers& args,
114
                                                                   uint32_t result,
115
1.17M
                                                                   size_t input_rows_count) const {
116
1.17M
    bool executed = false;
117
1.17M
    RETURN_IF_ERROR(default_implementation_for_nulls(context, block, args, result, input_rows_count,
118
1.17M
                                                     &executed));
119
1.17M
    if (executed) {
120
395k
        return Status::OK();
121
395k
    }
122
781k
    return execute_impl(context, block, args, result, input_rows_count);
123
1.17M
}
124
125
Status PreparedFunctionImpl::default_implementation_for_constant_arguments(
126
        FunctionContext* context, Block& block, const ColumnNumbers& args, uint32_t result,
127
1.17M
        size_t input_rows_count, bool* executed) const {
128
1.17M
    *executed = false;
129
1.17M
    ColumnNumbers args_expect_const = get_arguments_that_are_always_constant();
130
131
    // Check that these arguments are really constant.
132
1.17M
    for (auto arg_num : args_expect_const) {
133
157k
        if (arg_num < args.size() &&
134
157k
            !is_column_const(*block.get_by_position(args[arg_num]).column)) {
135
0
            return Status::InvalidArgument("Argument at index {} for function {} must be constant",
136
0
                                           arg_num, get_name());
137
0
        }
138
157k
    }
139
140
1.17M
    if (args.empty() || !use_default_implementation_for_constants() ||
141
1.17M
        !VectorizedUtils::all_arguments_are_constant(block, args)) {
142
1.16M
        return Status::OK();
143
1.16M
    }
144
145
    // now all columns are const.
146
15.9k
    Block temporary_block;
147
148
15.9k
    int arguments_size = (int)args.size();
149
46.3k
    for (size_t arg_num = 0; arg_num < arguments_size; ++arg_num) {
150
30.4k
        const ColumnWithTypeAndName& column = block.get_by_position(args[arg_num]);
151
        // Columns in const_list --> column_const,    others --> nested_column
152
        // that's because some functions supposes some specific columns always constant.
153
        // If we unpack it, there will be unnecessary cost of virtual judge.
154
30.4k
        if (args_expect_const.end() !=
155
30.4k
            std::find(args_expect_const.begin(), args_expect_const.end(), arg_num)) {
156
0
            temporary_block.insert({column.column, column.type, column.name});
157
30.4k
        } else {
158
30.4k
            temporary_block.insert(
159
30.4k
                    {assert_cast<const ColumnConst*>(column.column.get())->get_data_column_ptr(),
160
30.4k
                     column.type, column.name});
161
30.4k
        }
162
30.4k
    }
163
164
15.9k
    temporary_block.insert(block.get_by_position(result));
165
166
15.9k
    ColumnNumbers temporary_argument_numbers(arguments_size);
167
46.3k
    for (int i = 0; i < arguments_size; ++i) {
168
30.4k
        temporary_argument_numbers[i] = i;
169
30.4k
    }
170
171
15.9k
    RETURN_IF_ERROR(_execute_skipped_constant_deal(context, temporary_block,
172
15.9k
                                                   temporary_argument_numbers, arguments_size,
173
15.9k
                                                   temporary_block.rows()));
174
175
15.9k
    ColumnPtr result_column;
176
    /// extremely rare case, when we have function with completely const arguments
177
    /// but some of them produced by non is_deterministic function
178
15.9k
    if (temporary_block.get_by_position(arguments_size).column->size() > 1) {
179
0
        result_column = temporary_block.get_by_position(arguments_size).column->clone_resized(1);
180
15.9k
    } else {
181
15.9k
        result_column = temporary_block.get_by_position(arguments_size).column;
182
15.9k
    }
183
    // We shuold handle the case where the result column is also a ColumnConst.
184
15.9k
    block.get_by_position(result).column = ColumnConst::create(result_column, input_rows_count);
185
15.9k
    *executed = true;
186
15.9k
    return Status::OK();
187
15.9k
}
188
189
Status PreparedFunctionImpl::default_implementation_for_nulls(
190
        FunctionContext* context, Block& block, const ColumnNumbers& args, uint32_t result,
191
1.17M
        size_t input_rows_count, bool* executed) const {
192
1.17M
    *executed = false;
193
1.17M
    if (args.empty() || !use_default_implementation_for_nulls()) {
194
375k
        return Status::OK();
195
375k
    }
196
197
1.60M
    if (std::ranges::any_of(args, [&block](const auto& elem) {
198
1.60M
            return block.get_by_position(elem).column->only_null();
199
1.60M
        })) {
200
7.06k
        block.get_by_position(result).column =
201
7.06k
                block.get_by_position(result).type->create_column_const(input_rows_count, Field());
202
7.06k
        *executed = true;
203
7.06k
        return Status::OK();
204
7.06k
    }
205
206
794k
    if (have_null_column(block, args)) {
207
388k
        bool need_to_default = need_replace_null_data_to_default();
208
        // extract nested column from nulls
209
388k
        ColumnNumbers new_args;
210
388k
        Block new_block;
211
212
1.16M
        for (int i = 0; i < args.size(); ++i) {
213
777k
            uint32_t arg = args[i];
214
777k
            new_args.push_back(i);
215
777k
            new_block.insert(block.get_by_position(arg).unnest_nullable(need_to_default));
216
777k
        }
217
388k
        new_block.insert(block.get_by_position(result));
218
388k
        int new_result = new_block.columns() - 1;
219
220
388k
        RETURN_IF_ERROR(default_execute(context, new_block, new_args, new_result, block.rows()));
221
        // After run with nested, wrap them in null. Before this, block.get_by_position(result).type
222
        // is not compatible with get_by_position(result).column
223
224
388k
        block.get_by_position(result).column = wrap_in_nullable(
225
388k
                new_block.get_by_position(new_result).column, block, args, input_rows_count);
226
227
388k
        *executed = true;
228
388k
        return Status::OK();
229
388k
    }
230
406k
    return Status::OK();
231
794k
}
232
233
Status PreparedFunctionImpl::default_execute(FunctionContext* context, Block& block,
234
                                             const ColumnNumbers& args, uint32_t result,
235
1.17M
                                             size_t input_rows_count) const {
236
1.17M
    bool executed = false;
237
238
1.17M
    RETURN_IF_ERROR(default_implementation_for_constant_arguments(context, block, args, result,
239
1.17M
                                                                  input_rows_count, &executed));
240
1.17M
    if (executed) {
241
15.9k
        return Status::OK();
242
15.9k
    }
243
244
1.16M
    return _execute_skipped_constant_deal(context, block, args, result, input_rows_count);
245
1.17M
}
246
247
Status PreparedFunctionImpl::execute(FunctionContext* context, Block& block,
248
                                     const ColumnNumbers& args, uint32_t result,
249
788k
                                     size_t input_rows_count) const {
250
788k
    return default_execute(context, block, args, result, input_rows_count);
251
788k
}
252
253
273k
void FunctionBuilderImpl::check_number_of_arguments(size_t number_of_arguments) const {
254
273k
    if (is_variadic()) {
255
19.7k
        return;
256
19.7k
    }
257
258
253k
    size_t expected_number_of_arguments = get_number_of_arguments();
259
260
253k
    DCHECK_EQ(number_of_arguments, expected_number_of_arguments) << fmt::format(
261
0
            "Number of arguments for function {} doesn't match: passed {} , should be {}",
262
0
            get_name(), number_of_arguments, expected_number_of_arguments);
263
253k
    if (number_of_arguments != expected_number_of_arguments) {
264
0
        throw Exception(
265
0
                ErrorCode::INVALID_ARGUMENT,
266
0
                "Number of arguments for function {} doesn't match: passed {} , should be {}",
267
0
                get_name(), number_of_arguments, expected_number_of_arguments);
268
0
    }
269
253k
}
270
271
275k
DataTypePtr FunctionBuilderImpl::get_return_type(const ColumnsWithTypeAndName& arguments) const {
272
275k
    check_number_of_arguments(arguments.size());
273
274
275k
    if (!arguments.empty() && use_default_implementation_for_nulls()) {
275
254k
        if (have_null_column(arguments)) {
276
52.0k
            ColumnNumbers numbers(arguments.size());
277
52.0k
            std::iota(numbers.begin(), numbers.end(), 0);
278
52.0k
            auto [nested_block, _] =
279
52.0k
                    create_block_with_nested_columns(Block(arguments), numbers, false);
280
52.0k
            auto return_type = get_return_type_impl(
281
52.0k
                    ColumnsWithTypeAndName(nested_block.begin(), nested_block.end()));
282
52.0k
            if (!return_type) {
283
0
                return nullptr;
284
0
            }
285
52.0k
            return make_nullable(return_type);
286
52.0k
        }
287
254k
    }
288
289
223k
    return get_return_type_impl(arguments);
290
275k
}
291
292
bool FunctionBuilderImpl::is_date_or_datetime_or_decimal(
293
268
        const DataTypePtr& return_type, const DataTypePtr& func_return_type) const {
294
268
    return (is_date_or_datetime(return_type->get_primitive_type()) &&
295
268
            is_date_or_datetime(func_return_type->get_primitive_type())) ||
296
268
           (is_date_v2_or_datetime_v2(return_type->get_primitive_type()) &&
297
268
            is_date_v2_or_datetime_v2(func_return_type->get_primitive_type())) ||
298
           // For some date functions such as str_to_date(string, string), return_type will
299
           // be datetimev2 if users enable datev2 but get_return_type(arguments) will still
300
           // return datetime. We need keep backward compatibility here.
301
268
           (is_date_v2_or_datetime_v2(return_type->get_primitive_type()) &&
302
237
            is_date_or_datetime(func_return_type->get_primitive_type())) ||
303
268
           (is_date_or_datetime(return_type->get_primitive_type()) &&
304
237
            is_date_v2_or_datetime_v2(func_return_type->get_primitive_type())) ||
305
268
           (is_decimal(return_type->get_primitive_type()) &&
306
237
            is_decimal(func_return_type->get_primitive_type())) ||
307
268
           (is_time_type(return_type->get_primitive_type()) &&
308
21
            is_time_type(func_return_type->get_primitive_type()));
309
268
}
310
311
17
bool contains_date_or_datetime_or_decimal(const DataTypePtr& type) {
312
17
    auto type_ptr = type->is_nullable() ? ((DataTypeNullable*)type.get())->get_nested_type() : type;
313
314
17
    switch (type_ptr->get_primitive_type()) {
315
0
    case TYPE_ARRAY: {
316
0
        const auto* array_type = assert_cast<const DataTypeArray*>(type_ptr.get());
317
0
        return contains_date_or_datetime_or_decimal(array_type->get_nested_type());
318
0
    }
319
0
    case TYPE_MAP: {
320
0
        const auto* map_type = assert_cast<const DataTypeMap*>(type_ptr.get());
321
0
        return contains_date_or_datetime_or_decimal(map_type->get_key_type()) ||
322
0
               contains_date_or_datetime_or_decimal(map_type->get_value_type());
323
0
    }
324
0
    case TYPE_STRUCT: {
325
0
        const auto* struct_type = assert_cast<const DataTypeStruct*>(type_ptr.get());
326
0
        const auto& elements = struct_type->get_elements();
327
0
        return std::ranges::any_of(elements, [](const DataTypePtr& element) {
328
0
            return contains_date_or_datetime_or_decimal(element);
329
0
        });
330
0
    }
331
17
    default:
332
        // For scalar types, check if it's date/datetime/decimal
333
17
        return is_date_or_datetime(type_ptr->get_primitive_type()) ||
334
17
               is_date_v2_or_datetime_v2(type_ptr->get_primitive_type()) ||
335
17
               is_decimal(type_ptr->get_primitive_type()) ||
336
17
               is_time_type(type_ptr->get_primitive_type());
337
17
    }
338
17
}
339
340
// make sure array/map/struct and nested  array/map/struct can be check
341
bool FunctionBuilderImpl::is_nested_type_date_or_datetime_or_decimal(
342
19
        const DataTypePtr& return_type, const DataTypePtr& func_return_type) const {
343
19
    auto return_type_ptr = return_type->is_nullable()
344
19
                                   ? ((DataTypeNullable*)return_type.get())->get_nested_type()
345
19
                                   : return_type;
346
19
    auto func_return_type_ptr =
347
19
            func_return_type->is_nullable()
348
19
                    ? ((DataTypeNullable*)func_return_type.get())->get_nested_type()
349
19
                    : func_return_type;
350
    // make sure that map/struct/array also need to check
351
19
    if (return_type_ptr->get_primitive_type() != func_return_type_ptr->get_primitive_type()) {
352
2
        return false;
353
2
    }
354
355
    // Check if this type contains date/datetime/decimal types
356
17
    if (!contains_date_or_datetime_or_decimal(return_type_ptr)) {
357
        // If no date/datetime/decimal types, just pass through
358
17
        return true;
359
17
    }
360
361
    // If contains date/datetime/decimal types, recursively check each element
362
0
    switch (return_type_ptr->get_primitive_type()) {
363
0
    case TYPE_ARRAY: {
364
0
        auto nested_return_type = remove_nullable(
365
0
                (assert_cast<const DataTypeArray*>(return_type_ptr.get()))->get_nested_type());
366
0
        auto nested_func_type = remove_nullable(
367
0
                (assert_cast<const DataTypeArray*>(func_return_type_ptr.get()))->get_nested_type());
368
0
        return is_nested_type_date_or_datetime_or_decimal(nested_return_type, nested_func_type);
369
0
    }
370
0
    case TYPE_MAP: {
371
0
        const auto* return_map = assert_cast<const DataTypeMap*>(return_type_ptr.get());
372
0
        const auto* func_map = assert_cast<const DataTypeMap*>(func_return_type_ptr.get());
373
374
0
        auto key_return = remove_nullable(return_map->get_key_type());
375
0
        auto key_func = remove_nullable(func_map->get_key_type());
376
0
        auto value_return = remove_nullable(return_map->get_value_type());
377
0
        auto value_func = remove_nullable(func_map->get_value_type());
378
379
0
        return is_nested_type_date_or_datetime_or_decimal(key_return, key_func) &&
380
0
               is_nested_type_date_or_datetime_or_decimal(value_return, value_func);
381
0
    }
382
0
    case TYPE_STRUCT: {
383
0
        const auto* return_struct = assert_cast<const DataTypeStruct*>(return_type_ptr.get());
384
0
        const auto* func_struct = assert_cast<const DataTypeStruct*>(func_return_type_ptr.get());
385
386
0
        auto return_elements = return_struct->get_elements();
387
0
        auto func_elements = func_struct->get_elements();
388
389
0
        if (return_elements.size() != func_elements.size()) {
390
0
            return false;
391
0
        }
392
393
0
        for (size_t i = 0; i < return_elements.size(); i++) {
394
0
            auto elem_return = remove_nullable(return_elements[i]);
395
0
            auto elem_func = remove_nullable(func_elements[i]);
396
397
0
            if (!is_nested_type_date_or_datetime_or_decimal(elem_return, elem_func)) {
398
0
                return false;
399
0
            }
400
0
        }
401
0
        return true;
402
0
    }
403
0
    default:
404
0
        return is_date_or_datetime_or_decimal(return_type_ptr, func_return_type_ptr);
405
0
    }
406
0
}
407
408
} // namespace doris