1 | #include "duckdb/function/scalar/generic_functions.hpp" |
2 | #include "duckdb/common/operator/comparison_operators.hpp" |
3 | #include "duckdb/execution/expression_executor.hpp" |
4 | #include "duckdb/planner/expression/bound_function_expression.hpp" |
5 | |
6 | namespace duckdb { |
7 | |
8 | struct ConstantOrNullBindData : public FunctionData { |
9 | explicit ConstantOrNullBindData(Value val) : value(std::move(val)) { |
10 | } |
11 | |
12 | Value value; |
13 | |
14 | public: |
15 | unique_ptr<FunctionData> Copy() const override { |
16 | return make_uniq<ConstantOrNullBindData>(args: value); |
17 | } |
18 | |
19 | bool Equals(const FunctionData &other_p) const override { |
20 | auto &other = other_p.Cast<ConstantOrNullBindData>(); |
21 | return value == other.value; |
22 | } |
23 | }; |
24 | |
25 | static void ConstantOrNullFunction(DataChunk &args, ExpressionState &state, Vector &result) { |
26 | auto &func_expr = state.expr.Cast<BoundFunctionExpression>(); |
27 | auto &info = func_expr.bind_info->Cast<ConstantOrNullBindData>(); |
28 | result.Reference(value: info.value); |
29 | for (idx_t idx = 1; idx < args.ColumnCount(); idx++) { |
30 | switch (args.data[idx].GetVectorType()) { |
31 | case VectorType::FLAT_VECTOR: { |
32 | auto &input_mask = FlatVector::Validity(vector&: args.data[idx]); |
33 | if (!input_mask.AllValid()) { |
34 | // there are null values: need to merge them into the result |
35 | result.Flatten(count: args.size()); |
36 | auto &result_mask = FlatVector::Validity(vector&: result); |
37 | result_mask.Combine(other: input_mask, count: args.size()); |
38 | } |
39 | break; |
40 | } |
41 | case VectorType::CONSTANT_VECTOR: { |
42 | if (ConstantVector::IsNull(vector: args.data[idx])) { |
43 | // input is constant null, return constant null |
44 | result.Reference(value: info.value); |
45 | ConstantVector::SetNull(vector&: result, is_null: true); |
46 | return; |
47 | } |
48 | break; |
49 | } |
50 | default: { |
51 | UnifiedVectorFormat vdata; |
52 | args.data[idx].ToUnifiedFormat(count: args.size(), data&: vdata); |
53 | if (!vdata.validity.AllValid()) { |
54 | result.Flatten(count: args.size()); |
55 | auto &result_mask = FlatVector::Validity(vector&: result); |
56 | for (idx_t i = 0; i < args.size(); i++) { |
57 | if (!vdata.validity.RowIsValid(row_idx: vdata.sel->get_index(idx: i))) { |
58 | result_mask.SetInvalid(i); |
59 | } |
60 | } |
61 | } |
62 | break; |
63 | } |
64 | } |
65 | } |
66 | } |
67 | |
68 | ScalarFunction ConstantOrNull::GetFunction(const LogicalType &return_type) { |
69 | return ScalarFunction("constant_or_null" , {return_type, LogicalType::ANY}, return_type, ConstantOrNullFunction); |
70 | } |
71 | |
72 | unique_ptr<FunctionData> ConstantOrNull::Bind(Value value) { |
73 | return make_uniq<ConstantOrNullBindData>(args: std::move(value)); |
74 | } |
75 | |
76 | bool ConstantOrNull::IsConstantOrNull(BoundFunctionExpression &expr, const Value &val) { |
77 | if (expr.function.name != "constant_or_null" ) { |
78 | return false; |
79 | } |
80 | D_ASSERT(expr.bind_info); |
81 | auto &bind_data = expr.bind_info->Cast<ConstantOrNullBindData>(); |
82 | D_ASSERT(bind_data.value.type() == val.type()); |
83 | return bind_data.value == val; |
84 | } |
85 | |
86 | unique_ptr<FunctionData> ConstantOrNullBind(ClientContext &context, ScalarFunction &bound_function, |
87 | vector<unique_ptr<Expression>> &arguments) { |
88 | if (arguments[0]->HasParameter()) { |
89 | throw ParameterNotResolvedException(); |
90 | } |
91 | if (!arguments[0]->IsFoldable()) { |
92 | throw BinderException("ConstantOrNull requires a constant input" ); |
93 | } |
94 | D_ASSERT(arguments.size() >= 2); |
95 | auto value = ExpressionExecutor::EvaluateScalar(context, expr: *arguments[0]); |
96 | bound_function.return_type = arguments[0]->return_type; |
97 | return make_uniq<ConstantOrNullBindData>(args: std::move(value)); |
98 | } |
99 | |
100 | void ConstantOrNull::RegisterFunction(BuiltinFunctions &set) { |
101 | auto fun = ConstantOrNull::GetFunction(return_type: LogicalType::ANY); |
102 | fun.bind = ConstantOrNullBind; |
103 | fun.varargs = LogicalType::ANY; |
104 | set.AddFunction(function: fun); |
105 | } |
106 | |
107 | } // namespace duckdb |
108 | |