forked from oceanbase/oceanbase
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathob_expr_between.cpp
More file actions
139 lines (133 loc) · 5.92 KB
/
Copy pathob_expr_between.cpp
File metadata and controls
139 lines (133 loc) · 5.92 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
/**
* Copyright (c) 2021 OceanBase
* OceanBase CE is licensed under Mulan PubL v2.
* You can use this software according to the terms and conditions of the Mulan PubL v2.
* You may obtain a copy of Mulan PubL v2 at:
* http://license.coscl.org.cn/MulanPubL-2.0
* THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
* EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
* MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
* See the Mulan PubL v2 for more details.
*/
#define USING_LOG_PREFIX SQL_EXE
#include "common/object/ob_obj_compare.h"
#include "sql/engine/expr/ob_expr_between.h"
#include "sql/engine/expr/ob_expr_less_than.h"
#include "sql/engine/expr/ob_expr_less_equal.h"
#include "sql/engine/expr/ob_expr_cmp_func.h"
#include "sql/session/ob_sql_session_info.h"
namespace oceanbase
{
using namespace common;
namespace sql
{
ObExprBetween::ObExprBetween(ObIAllocator &alloc)
: ObRelationalExprOperator(alloc, T_OP_BTW, N_BTW, 3)
{
}
int calc_between_expr(const ObExpr &expr, ObEvalCtx &ctx, ObDatum &res_datum)
{
// left <= val <= right
int ret = OB_SUCCESS;
ObDatum *val = NULL;
ObDatum *left = NULL;
ObDatum *right = NULL;
if (OB_FAIL(expr.args_[0]->eval(ctx, val))) {
LOG_WARN("eval arg 0 failed", K(ret));
} else if (val->is_null()) {
res_datum.set_null();
} else if (OB_FAIL(expr.args_[1]->eval(ctx, left))) {
LOG_WARN("eval arg 1 failed", K(ret));
} else if (OB_FAIL(expr.args_[2]->eval(ctx, right))) {
LOG_WARN("eval arg 2 failed", K(ret));
} else if (left->is_null() && right->is_null()) {
res_datum.set_null();
} else {
bool left_cmp_succ = true; // is left <= val true or not
bool right_cmp_succ = true; // is val <= right true or not
int cmp_ret = 0;
if (!left->is_null()) {
if (OB_FAIL((reinterpret_cast<DatumCmpFunc>(expr.inner_functions_[0]))(*left, *val, cmp_ret))) {
LOG_WARN("compare left failed", K(ret));
} else {
left_cmp_succ = cmp_ret <= 0 ? true : false;
}
}
if (OB_FAIL(ret)) {
} else if (left->is_null() || (left_cmp_succ && !right->is_null())) {
if (OB_FAIL((reinterpret_cast<DatumCmpFunc>(expr.inner_functions_[1]))(*val, *right, cmp_ret))) {
LOG_WARN("compare left failed", K(ret));
} else {
right_cmp_succ = cmp_ret <= 0 ? true : false;
}
}
if (OB_FAIL(ret)) {
} else if ((left->is_null() && right_cmp_succ) || (right->is_null() && left_cmp_succ)) {
res_datum.set_null();
} else if (left_cmp_succ && right_cmp_succ) {
res_datum.set_int32(1);
} else {
res_datum.set_int32(0);
}
}
return ret;
}
int ObExprBetween::cg_expr(ObExprCGCtx &expr_cg_ctx,
const ObRawExpr &raw_expr,
ObExpr &rt_expr) const
{
// left <= val <= right
int ret = OB_SUCCESS;
if (OB_UNLIKELY(3 != rt_expr.arg_cnt_) || OB_ISNULL(rt_expr.args_) ||
OB_ISNULL(rt_expr.args_[0]) || OB_ISNULL(rt_expr.args_[1]) ||
OB_ISNULL(rt_expr.args_[2]) || OB_ISNULL(expr_cg_ctx.allocator_)) {
ret = OB_INVALID_ARGUMENT;
LOG_WARN("rt_expr is invalid", K(ret), K(rt_expr.arg_cnt_), KP(rt_expr.args_),
KP(rt_expr.args_[0]), KP(rt_expr.args_[1]), KP(rt_expr.args_[2]));
} else {
DatumCmpFunc cmp_func_1 = NULL; // left <= val
DatumCmpFunc cmp_func_2 = NULL; // val <= right
const ObDatumMeta &val_meta = rt_expr.args_[0]->datum_meta_;
const ObDatumMeta &left_meta = rt_expr.args_[1]->datum_meta_;
const ObDatumMeta &right_meta = rt_expr.args_[2]->datum_meta_;
const ObCollationType cmp_cs_type =
raw_expr.get_result_type().get_calc_collation_type();
const bool has_lob_header1 = rt_expr.args_[0]->obj_meta_.has_lob_header() ||
rt_expr.args_[1]->obj_meta_.has_lob_header();
const bool has_lob_header2 = rt_expr.args_[0]->obj_meta_.has_lob_header() ||
rt_expr.args_[2]->obj_meta_.has_lob_header();
if (OB_ISNULL(cmp_func_1 = ObExprCmpFuncsHelper::get_datum_expr_cmp_func(
left_meta.type_, val_meta.type_,
left_meta.scale_, val_meta.scale_,
left_meta.precision_, val_meta.precision_,
is_oracle_mode(),
cmp_cs_type,
has_lob_header1))) {
ret = OB_ERR_UNEXPECTED;
LOG_WARN("get_datum_expr_cmp_func failed", K(ret), K(left_meta), K(val_meta),
K(is_oracle_mode()), K(rt_expr));
} else if (OB_ISNULL(cmp_func_2 = ObExprCmpFuncsHelper::get_datum_expr_cmp_func(
val_meta.type_, right_meta.type_,
val_meta.scale_, right_meta.scale_,
val_meta.precision_, right_meta.precision_,
is_oracle_mode(),
cmp_cs_type,
has_lob_header2))) {
ret = OB_ERR_UNEXPECTED;
LOG_WARN("get_datum_expr_cmp_func failed", K(ret), K(val_meta), K(right_meta),
K(is_oracle_mode()), K(rt_expr));
} else if (OB_ISNULL(rt_expr.inner_functions_ = reinterpret_cast<void**>(
expr_cg_ctx.allocator_->alloc(sizeof(DatumCmpFunc) * 2)))) {
ret = OB_ALLOCATE_MEMORY_FAILED;
LOG_WARN("alloc memory for inner_functions_ failed", K(ret));
} else {
rt_expr.inner_func_cnt_ = 2;
rt_expr.inner_functions_[0] = reinterpret_cast<void*>(cmp_func_1);
rt_expr.inner_functions_[1] = reinterpret_cast<void*>(cmp_func_2);
rt_expr.eval_func_ = calc_between_expr;
}
}
return ret;
}
}
}