http://git-wip-us.apache.org/repos/asf/hive/blob/ae008b79/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out
b/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out
index a1df0ac..b95fc59 100644
--- a/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out
@@ -1501,7 +1501,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: vector_interval_2
- filterExpr: ((TIMESTAMP'2002-03-01 01:02:03.0' = (ts +
INTERVAL'1-2')) and (TIMESTAMP'2002-03-01 01:02:03.0' <= (ts + INTERVAL'1-2'))
and (TIMESTAMP'2002-03-01 01:02:03.0' >= (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-04-01 01:02:03.0' <> (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-02-01 01:02:03.0' < (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-04-01 01:02:03.0' > (ts + INTERVAL'1-2')) and ((ts +
INTERVAL'1-2') = TIMESTAMP'2002-03-01 01:02:03.0') and ((ts + INTERVAL'1-2') >=
TIMESTAMP'2002-03-01 01:02:03.0') and ((ts + INTERVAL'1-2') <=
TIMESTAMP'2002-03-01 01:02:03.0') and ((ts + INTERVAL'1-2') <>
TIMESTAMP'2002-04-01 01:02:03.0') and ((ts + INTERVAL'1-2') >
TIMESTAMP'2002-02-01 01:02:03.0') and ((ts + INTERVAL'1-2') <
TIMESTAMP'2002-04-01 01:02:03.0') and (ts = (ts + INTERVAL'0-0')) and (ts <>
(ts + INTERVAL'1-0')) and (ts <= (ts + INTERVAL'1-0')) and (ts < (ts +
INTERVAL'1-0')) and (ts >= (ts - INTERVAL'1-0')) and (ts > (ts -
INTERVAL'1-0'))) (type: boolean)
+ filterExpr: ((TIMESTAMP'2002-03-01 01:02:03' = (ts +
INTERVAL'1-2')) and (TIMESTAMP'2002-03-01 01:02:03' <= (ts + INTERVAL'1-2'))
and (TIMESTAMP'2002-03-01 01:02:03' >= (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-04-01 01:02:03' <> (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-02-01 01:02:03' < (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-04-01 01:02:03' > (ts + INTERVAL'1-2')) and ((ts +
INTERVAL'1-2') = TIMESTAMP'2002-03-01 01:02:03') and ((ts + INTERVAL'1-2') >=
TIMESTAMP'2002-03-01 01:02:03') and ((ts + INTERVAL'1-2') <=
TIMESTAMP'2002-03-01 01:02:03') and ((ts + INTERVAL'1-2') <>
TIMESTAMP'2002-04-01 01:02:03') and ((ts + INTERVAL'1-2') >
TIMESTAMP'2002-02-01 01:02:03') and ((ts + INTERVAL'1-2') <
TIMESTAMP'2002-04-01 01:02:03') and (ts = (ts + INTERVAL'0-0')) and (ts <> (ts
+ INTERVAL'1-0')) and (ts <= (ts + INTERVAL'1-0')) and (ts < (ts +
INTERVAL'1-0')) and (ts >= (ts - INTERVAL'1-0')) and (ts > (ts -
INTERVAL'1-0'))) (type: boolean)
Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE
Column stats: NONE
TableScan Vectorization:
native: true
@@ -1509,8 +1509,8 @@ STAGE PLANS:
Filter Vectorization:
className: VectorFilterOperator
native: true
- predicateExpression: FilterExprAndExpr(children:
FilterTimestampScalarEqualTimestampColumn(val 2002-03-01 01:02:03.0, col
7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 1-2) -> 7:timestamp), FilterTimestampScalarLessEqualTimestampColumn(val
2002-03-01 01:02:03.0, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampScalarGreaterEqualTimestampColumn(val 2002-03-01
01:02:03.0, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampScalarNotEqualTimestampColumn(val 2002-04-01
01:02:03.0, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampScalarLessTimestampColumn(val 2002-02-01
01:02:03.0, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampScalar
GreaterTimestampColumn(val 2002-04-01 01:02:03.0, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampColEqualTimestampScalar(col 7:timestamp, val
2002-03-01 01:02:03.0)(children: TimestampColAddIntervalYearMonthScalar(col
0:timestamp, val 1-2) -> 7:timestamp),
FilterTimestampColGreaterEqualTimestampScalar(col 7:timestamp, val 2002-03-01
01:02:03.0)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 1-2) -> 7:timestamp), FilterTimestampColLessEqualTimestampScalar(col
7:timestamp, val 2002-03-01 01:02:03.0)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampColNotEqualTimestampScalar(col 7:timestamp, val
2002-04-01 01:02:03.0)(children: TimestampColAddIntervalYearMonthScalar(col
0:timestamp, val 1-2) -> 7:timestamp),
FilterTimestampColGreaterTimestampScalar(col 7:timestamp, val 2002-02-01
01:02:03.0)(children: TimestampColAddIntervalYearMo
nthScalar(col 0:timestamp, val 1-2) -> 7:timestamp),
FilterTimestampColLessTimestampScalar(col 7:timestamp, val 2002-04-01
01:02:03.0)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 1-2) -> 7:timestamp), FilterTimestampColEqualTimestampColumn(col
0:timestamp, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 0-0) ->
7:timestamp), FilterTimestampColNotEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 1-0) -> 7:timestamp), FilterTimestampColLessEqualTimestampColumn(col
0:timestamp, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-0) ->
7:timestamp), FilterTimestampColLessTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 1-0) -> 7:timestamp), FilterTimestampColGreaterEqualTimestampColumn(col
0:timestamp, col 7:timestamp)(children: TimestampColSu
btractIntervalYearMonthScalar(col 0:timestamp, val 1-0) -> 7:timestamp),
FilterTimestampColGreaterTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColSubtractIntervalYearMonthScalar(col
0:timestamp, val 1-0) -> 7:timestamp))
- predicate: (((ts + INTERVAL'1-2') < TIMESTAMP'2002-04-01
01:02:03.0') and ((ts + INTERVAL'1-2') <= TIMESTAMP'2002-03-01 01:02:03.0') and
((ts + INTERVAL'1-2') <> TIMESTAMP'2002-04-01 01:02:03.0') and ((ts +
INTERVAL'1-2') = TIMESTAMP'2002-03-01 01:02:03.0') and ((ts + INTERVAL'1-2') >
TIMESTAMP'2002-02-01 01:02:03.0') and ((ts + INTERVAL'1-2') >=
TIMESTAMP'2002-03-01 01:02:03.0') and (TIMESTAMP'2002-02-01 01:02:03.0' < (ts +
INTERVAL'1-2')) and (TIMESTAMP'2002-03-01 01:02:03.0' <= (ts + INTERVAL'1-2'))
and (TIMESTAMP'2002-03-01 01:02:03.0' = (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-03-01 01:02:03.0' >= (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-04-01 01:02:03.0' <> (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-04-01 01:02:03.0' > (ts + INTERVAL'1-2')) and (ts < (ts +
INTERVAL'1-0')) and (ts <= (ts + INTERVAL'1-0')) and (ts <> (ts +
INTERVAL'1-0')) and (ts = (ts + INTERVAL'0-0')) and (ts > (ts - INTERVAL'1-0'))
and (ts >= (ts - INTERVAL'1-0'))) (type: boolean)
+ predicateExpression: FilterExprAndExpr(children:
FilterTimestampScalarEqualTimestampColumn(val 2002-03-01 01:02:03, col
7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 1-2) -> 7:timestamp), FilterTimestampScalarLessEqualTimestampColumn(val
2002-03-01 01:02:03, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampScalarGreaterEqualTimestampColumn(val 2002-03-01
01:02:03, col 7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col
0:timestamp, val 1-2) -> 7:timestamp),
FilterTimestampScalarNotEqualTimestampColumn(val 2002-04-01 01:02:03, col
7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 1-2) -> 7:timestamp), FilterTimestampScalarLessTimestampColumn(val
2002-02-01 01:02:03, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampScalarGreaterTim
estampColumn(val 2002-04-01 01:02:03, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampColEqualTimestampScalar(col 7:timestamp, val
2002-03-01 01:02:03)(children: TimestampColAddIntervalYearMonthScalar(col
0:timestamp, val 1-2) -> 7:timestamp),
FilterTimestampColGreaterEqualTimestampScalar(col 7:timestamp, val 2002-03-01
01:02:03)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val
1-2) -> 7:timestamp), FilterTimestampColLessEqualTimestampScalar(col
7:timestamp, val 2002-03-01 01:02:03)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampColNotEqualTimestampScalar(col 7:timestamp, val
2002-04-01 01:02:03)(children: TimestampColAddIntervalYearMonthScalar(col
0:timestamp, val 1-2) -> 7:timestamp),
FilterTimestampColGreaterTimestampScalar(col 7:timestamp, val 2002-02-01
01:02:03)(children: TimestampColAddIntervalYearMonthScalar(col 0:timest
amp, val 1-2) -> 7:timestamp), FilterTimestampColLessTimestampScalar(col
7:timestamp, val 2002-04-01 01:02:03)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampColEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 0-0) -> 7:timestamp), FilterTimestampColNotEqualTimestampColumn(col
0:timestamp, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-0) ->
7:timestamp), FilterTimestampColLessEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 1-0) -> 7:timestamp), FilterTimestampColLessTimestampColumn(col
0:timestamp, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-0) ->
7:timestamp), FilterTimestampColGreaterEqualTimestampColumn(col 0:timestamp,
col 7:timestamp)(children: TimestampColSubtractIntervalYearMonthS
calar(col 0:timestamp, val 1-0) -> 7:timestamp),
FilterTimestampColGreaterTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColSubtractIntervalYearMonthScalar(col
0:timestamp, val 1-0) -> 7:timestamp))
+ predicate: (((ts + INTERVAL'1-2') < TIMESTAMP'2002-04-01
01:02:03') and ((ts + INTERVAL'1-2') <= TIMESTAMP'2002-03-01 01:02:03') and
((ts + INTERVAL'1-2') <> TIMESTAMP'2002-04-01 01:02:03') and ((ts +
INTERVAL'1-2') = TIMESTAMP'2002-03-01 01:02:03') and ((ts + INTERVAL'1-2') >
TIMESTAMP'2002-02-01 01:02:03') and ((ts + INTERVAL'1-2') >=
TIMESTAMP'2002-03-01 01:02:03') and (TIMESTAMP'2002-02-01 01:02:03' < (ts +
INTERVAL'1-2')) and (TIMESTAMP'2002-03-01 01:02:03' <= (ts + INTERVAL'1-2'))
and (TIMESTAMP'2002-03-01 01:02:03' = (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-03-01 01:02:03' >= (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-04-01 01:02:03' <> (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-04-01 01:02:03' > (ts + INTERVAL'1-2')) and (ts < (ts +
INTERVAL'1-0')) and (ts <= (ts + INTERVAL'1-0')) and (ts <> (ts +
INTERVAL'1-0')) and (ts = (ts + INTERVAL'0-0')) and (ts > (ts - INTERVAL'1-0'))
and (ts >= (ts - INTERVAL'1-0'))) (type: boolean)
Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: ts (type: timestamp)
@@ -1696,7 +1696,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: vector_interval_2
- filterExpr: ((TIMESTAMP'2001-01-01 01:02:03.0' = (dt +
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' <> (dt +
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' <= (dt +
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' < (dt +
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' >= (dt -
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' > (dt -
INTERVAL'0 01:02:04.000000000')) and ((dt + INTERVAL'0 01:02:03.000000000') =
TIMESTAMP'2001-01-01 01:02:03.0') and ((dt + INTERVAL'0 01:02:04.000000000') <>
TIMESTAMP'2001-01-01 01:02:03.0') and ((dt + INTERVAL'0 01:02:03.000000000') >=
TIMESTAMP'2001-01-01 01:02:03.0') and ((dt + INTERVAL'0 01:02:04.000000000') >
TIMESTAMP'2001-01-01 01:02:03.0') and ((dt - INTERVAL'0 01:02:03.000000000') <=
TIMESTAMP'2001-01-01 01:02:03.0') and ((dt - INTERVAL'0 01:02:04.000000000') <
TIMESTAMP'2001-01-01 01:02:03.0') and (ts = (dt +
INTERVAL'0 01:02:03.000000000')) and (ts <> (dt + INTERVAL'0
01:02:04.000000000')) and (ts <= (dt + INTERVAL'0 01:02:03.000000000')) and (ts
< (dt + INTERVAL'0 01:02:04.000000000')) and (ts >= (dt - INTERVAL'0
01:02:03.000000000')) and (ts > (dt - INTERVAL'0 01:02:04.000000000'))) (type:
boolean)
+ filterExpr: ((TIMESTAMP'2001-01-01 01:02:03' = (dt +
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <> (dt +
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <= (dt +
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' < (dt +
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' >= (dt -
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' > (dt -
INTERVAL'0 01:02:04.000000000')) and ((dt + INTERVAL'0 01:02:03.000000000') =
TIMESTAMP'2001-01-01 01:02:03') and ((dt + INTERVAL'0 01:02:04.000000000') <>
TIMESTAMP'2001-01-01 01:02:03') and ((dt + INTERVAL'0 01:02:03.000000000') >=
TIMESTAMP'2001-01-01 01:02:03') and ((dt + INTERVAL'0 01:02:04.000000000') >
TIMESTAMP'2001-01-01 01:02:03') and ((dt - INTERVAL'0 01:02:03.000000000') <=
TIMESTAMP'2001-01-01 01:02:03') and ((dt - INTERVAL'0 01:02:04.000000000') <
TIMESTAMP'2001-01-01 01:02:03') and (ts = (dt + INTERVAL'0 01:02:03.0000
00000')) and (ts <> (dt + INTERVAL'0 01:02:04.000000000')) and (ts <= (dt +
INTERVAL'0 01:02:03.000000000')) and (ts < (dt + INTERVAL'0
01:02:04.000000000')) and (ts >= (dt - INTERVAL'0 01:02:03.000000000')) and (ts
> (dt - INTERVAL'0 01:02:04.000000000'))) (type: boolean)
Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE
Column stats: NONE
TableScan Vectorization:
native: true
@@ -1704,8 +1704,8 @@ STAGE PLANS:
Filter Vectorization:
className: VectorFilterOperator
native: true
- predicateExpression: FilterExprAndExpr(children:
FilterTimestampScalarEqualTimestampColumn(val 2001-01-01 01:02:03.0, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampScalarNotEqualTimestampColumn(val 2001-01-01 01:02:03.0, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampScalarLessEqualTimestampColumn(val 2001-01-01 01:02:03.0, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampScalarLessTimestampColumn(val 2001-01-01 01:02:03.0, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampScalarGreaterEqualTimestampColumn(val 2001-01-01 01:02:03.0, col
7:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:tim
estamp), FilterTimestampScalarGreaterTimestampColumn(val 2001-01-01
01:02:03.0, col 7:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col
1:date, val 0 01:02:04.000000000) -> 7:timestamp),
FilterTimestampColEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03.0)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampColNotEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03.0)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampColGreaterEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03.0)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampColGreaterTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03.0)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampColLessEqualTimestampScalar(col 7:timestamp, val 20
01-01-01 01:02:03.0)(children: DateColSubtractIntervalDayTimeScalar(col
1:date, val 0 01:02:03.000000000) -> 7:timestamp),
FilterTimestampColLessTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03.0)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp), FilterTimestampColEqualTimestampColumn(col
0:timestamp, col 7:timestamp)(children: DateColAddIntervalDayTimeScalar(col
1:date, val 0 01:02:03.000000000) -> 7:timestamp),
FilterTimestampColNotEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampColLessEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp), FilterTimestampColLessTimestampColumn(col
0:timestamp, col 7:timestamp)(children: DateColAddIntervalDayTimeScalar(col
1:date, val 0 01:02:04.000000000) -> 7:timestamp), Filt
erTimestampColGreaterEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampColGreaterTimestampColumn(col 0:timestamp, col
7:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp))
- predicate: (((dt + INTERVAL'0 01:02:03.000000000') =
TIMESTAMP'2001-01-01 01:02:03.0') and ((dt + INTERVAL'0 01:02:03.000000000') >=
TIMESTAMP'2001-01-01 01:02:03.0') and ((dt + INTERVAL'0 01:02:04.000000000') <>
TIMESTAMP'2001-01-01 01:02:03.0') and ((dt + INTERVAL'0 01:02:04.000000000') >
TIMESTAMP'2001-01-01 01:02:03.0') and ((dt - INTERVAL'0 01:02:03.000000000') <=
TIMESTAMP'2001-01-01 01:02:03.0') and ((dt - INTERVAL'0 01:02:04.000000000') <
TIMESTAMP'2001-01-01 01:02:03.0') and (TIMESTAMP'2001-01-01 01:02:03.0' < (dt +
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' <= (dt +
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' <> (dt +
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' = (dt +
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' > (dt -
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' >= (dt -
INTERVAL'0 01:02:03.000000000')) and (ts < (dt +
INTERVAL'0 01:02:04.000000000')) and (ts <= (dt + INTERVAL'0
01:02:03.000000000')) and (ts <> (dt + INTERVAL'0 01:02:04.000000000')) and (ts
= (dt + INTERVAL'0 01:02:03.000000000')) and (ts > (dt - INTERVAL'0
01:02:04.000000000')) and (ts >= (dt - INTERVAL'0 01:02:03.000000000'))) (type:
boolean)
+ predicateExpression: FilterExprAndExpr(children:
FilterTimestampScalarEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampScalarNotEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampScalarLessEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampScalarLessTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampScalarGreaterEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp), F
ilterTimestampScalarGreaterTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp), FilterTimestampColEqualTimestampScalar(col
7:timestamp, val 2001-01-01 01:02:03)(children:
DateColAddIntervalDayTimeScalar(col 1:date, val 0 01:02:03.000000000) ->
7:timestamp), FilterTimestampColNotEqualTimestampScalar(col 7:timestamp, val
2001-01-01 01:02:03)(children: DateColAddIntervalDayTimeScalar(col 1:date, val
0 01:02:04.000000000) -> 7:timestamp),
FilterTimestampColGreaterEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampColGreaterTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampColLessEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(c
hildren: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp), FilterTimestampColLessTimestampScalar(col
7:timestamp, val 2001-01-01 01:02:03)(children:
DateColSubtractIntervalDayTimeScalar(col 1:date, val 0 01:02:04.000000000) ->
7:timestamp), FilterTimestampColEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampColNotEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampColLessEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp), FilterTimestampColLessTimestampColumn(col
0:timestamp, col 7:timestamp)(children: DateColAddIntervalDayTimeScalar(col
1:date, val 0 01:02:04.000000000) -> 7:timestamp), FilterTimestampColGreaterEqu
alTimestampColumn(col 0:timestamp, col 7:timestamp)(children:
DateColSubtractIntervalDayTimeScalar(col 1:date, val 0 01:02:03.000000000) ->
7:timestamp), FilterTimestampColGreaterTimestampColumn(col 0:timestamp, col
7:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp))
+ predicate: (((dt + INTERVAL'0 01:02:03.000000000') =
TIMESTAMP'2001-01-01 01:02:03') and ((dt + INTERVAL'0 01:02:03.000000000') >=
TIMESTAMP'2001-01-01 01:02:03') and ((dt + INTERVAL'0 01:02:04.000000000') <>
TIMESTAMP'2001-01-01 01:02:03') and ((dt + INTERVAL'0 01:02:04.000000000') >
TIMESTAMP'2001-01-01 01:02:03') and ((dt - INTERVAL'0 01:02:03.000000000') <=
TIMESTAMP'2001-01-01 01:02:03') and ((dt - INTERVAL'0 01:02:04.000000000') <
TIMESTAMP'2001-01-01 01:02:03') and (TIMESTAMP'2001-01-01 01:02:03' < (dt +
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <= (dt +
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <> (dt +
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' = (dt +
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' > (dt -
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' >= (dt -
INTERVAL'0 01:02:03.000000000')) and (ts < (dt + INTERVAL'0 01:02:04.000
000000')) and (ts <= (dt + INTERVAL'0 01:02:03.000000000')) and (ts <> (dt +
INTERVAL'0 01:02:04.000000000')) and (ts = (dt + INTERVAL'0
01:02:03.000000000')) and (ts > (dt - INTERVAL'0 01:02:04.000000000')) and (ts
>= (dt - INTERVAL'0 01:02:03.000000000'))) (type: boolean)
Statistics: Num rows: 1 Data size: 96 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: ts (type: timestamp)
@@ -1891,7 +1891,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: vector_interval_2
- filterExpr: ((TIMESTAMP'2001-01-01 01:02:03.0' = (ts +
INTERVAL'0 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' <> (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' <= (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' < (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' >= (ts -
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' > (ts -
INTERVAL'1 00:00:00.000000000')) and ((ts + INTERVAL'0 00:00:00.000000000') =
TIMESTAMP'2001-01-01 01:02:03.0') and ((ts + INTERVAL'1 00:00:00.000000000') <>
TIMESTAMP'2001-01-01 01:02:03.0') and ((ts + INTERVAL'1 00:00:00.000000000') >=
TIMESTAMP'2001-01-01 01:02:03.0') and ((ts + INTERVAL'1 00:00:00.000000000') >
TIMESTAMP'2001-01-01 01:02:03.0') and ((ts - INTERVAL'1 00:00:00.000000000') <=
TIMESTAMP'2001-01-01 01:02:03.0') and ((ts - INTERVAL'1 00:00:00.000000000') <
TIMESTAMP'2001-01-01 01:02:03.0') and (ts = (ts +
INTERVAL'0 00:00:00.000000000')) and (ts <> (ts + INTERVAL'1
00:00:00.000000000')) and (ts <= (ts + INTERVAL'1 00:00:00.000000000')) and (ts
< (ts + INTERVAL'1 00:00:00.000000000')) and (ts >= (ts - INTERVAL'1
00:00:00.000000000')) and (ts > (ts - INTERVAL'1 00:00:00.000000000'))) (type:
boolean)
+ filterExpr: ((TIMESTAMP'2001-01-01 01:02:03' = (ts +
INTERVAL'0 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <> (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <= (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' < (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' >= (ts -
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' > (ts -
INTERVAL'1 00:00:00.000000000')) and ((ts + INTERVAL'0 00:00:00.000000000') =
TIMESTAMP'2001-01-01 01:02:03') and ((ts + INTERVAL'1 00:00:00.000000000') <>
TIMESTAMP'2001-01-01 01:02:03') and ((ts + INTERVAL'1 00:00:00.000000000') >=
TIMESTAMP'2001-01-01 01:02:03') and ((ts + INTERVAL'1 00:00:00.000000000') >
TIMESTAMP'2001-01-01 01:02:03') and ((ts - INTERVAL'1 00:00:00.000000000') <=
TIMESTAMP'2001-01-01 01:02:03') and ((ts - INTERVAL'1 00:00:00.000000000') <
TIMESTAMP'2001-01-01 01:02:03') and (ts = (ts + INTERVAL'0 00:00:00.0000
00000')) and (ts <> (ts + INTERVAL'1 00:00:00.000000000')) and (ts <= (ts +
INTERVAL'1 00:00:00.000000000')) and (ts < (ts + INTERVAL'1
00:00:00.000000000')) and (ts >= (ts - INTERVAL'1 00:00:00.000000000')) and (ts
> (ts - INTERVAL'1 00:00:00.000000000'))) (type: boolean)
Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE
Column stats: NONE
TableScan Vectorization:
native: true
@@ -1899,8 +1899,8 @@ STAGE PLANS:
Filter Vectorization:
className: VectorFilterOperator
native: true
- predicateExpression: FilterExprAndExpr(children:
FilterTimestampScalarEqualTimestampColumn(val 2001-01-01 01:02:03.0, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 0 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarNotEqualTimestampColumn(val 2001-01-01 01:02:03.0, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarLessEqualTimestampColumn(val 2001-01-01 01:02:03.0, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarLessTimestampColumn(val 2001-01-01 01:02:03.0, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarGreaterEqualTimestampColumn(val 2001-01-01 01:02:03.0, col
7:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(c
ol 0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarGreaterTimestampColumn(val 2001-01-01 01:02:03.0, col
7:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03.0)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val
0 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColNotEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03.0)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val
1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColGreaterEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03.0)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val
1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColGreaterTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03.0)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val
1 00:
00:00.000000000) -> 7:timestamp),
FilterTimestampColLessEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03.0)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColLessTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03.0)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 0 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColNotEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColLessEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp), FilterTimestampColLessT
imestampColumn(col 0:timestamp, col 7:timestamp)(children:
TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 1 00:00:00.000000000)
-> 7:timestamp), FilterTimestampColGreaterEqualTimestampColumn(col 0:timestamp,
col 7:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColGreaterTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp))
- predicate: (((ts + INTERVAL'0 00:00:00.000000000') =
TIMESTAMP'2001-01-01 01:02:03.0') and ((ts + INTERVAL'1 00:00:00.000000000') <>
TIMESTAMP'2001-01-01 01:02:03.0') and ((ts + INTERVAL'1 00:00:00.000000000') >
TIMESTAMP'2001-01-01 01:02:03.0') and ((ts + INTERVAL'1 00:00:00.000000000') >=
TIMESTAMP'2001-01-01 01:02:03.0') and ((ts - INTERVAL'1 00:00:00.000000000') <
TIMESTAMP'2001-01-01 01:02:03.0') and ((ts - INTERVAL'1 00:00:00.000000000') <=
TIMESTAMP'2001-01-01 01:02:03.0') and (TIMESTAMP'2001-01-01 01:02:03.0' < (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' <= (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' <> (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' = (ts +
INTERVAL'0 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' > (ts -
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03.0' >= (ts -
INTERVAL'1 00:00:00.000000000')) and (ts < (ts +
INTERVAL'1 00:00:00.000000000')) and (ts <= (ts + INTERVAL'1
00:00:00.000000000')) and (ts <> (ts + INTERVAL'1 00:00:00.000000000')) and (ts
= (ts + INTERVAL'0 00:00:00.000000000')) and (ts > (ts - INTERVAL'1
00:00:00.000000000')) and (ts >= (ts - INTERVAL'1 00:00:00.000000000'))) (type:
boolean)
+ predicateExpression: FilterExprAndExpr(children:
FilterTimestampScalarEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 0 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarNotEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarLessEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarLessTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarGreaterEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col 0:times
tamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarGreaterTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 0
00:00:00.000000000) -> 7:timestamp),
FilterTimestampColNotEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 1
00:00:00.000000000) -> 7:timestamp),
FilterTimestampColGreaterEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 1
00:00:00.000000000) -> 7:timestamp),
FilterTimestampColGreaterTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 1
00:00:00.000000000) ->
7:timestamp), FilterTimestampColLessEqualTimestampScalar(col 7:timestamp, val
2001-01-01 01:02:03)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColLessTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: TimestampColSubtractIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 0 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColNotEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColLessEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColLessTimestampColumn(col 0:tim
estamp, col 7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColGreaterEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColGreaterTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp))
+ predicate: (((ts + INTERVAL'0 00:00:00.000000000') =
TIMESTAMP'2001-01-01 01:02:03') and ((ts + INTERVAL'1 00:00:00.000000000') <>
TIMESTAMP'2001-01-01 01:02:03') and ((ts + INTERVAL'1 00:00:00.000000000') >
TIMESTAMP'2001-01-01 01:02:03') and ((ts + INTERVAL'1 00:00:00.000000000') >=
TIMESTAMP'2001-01-01 01:02:03') and ((ts - INTERVAL'1 00:00:00.000000000') <
TIMESTAMP'2001-01-01 01:02:03') and ((ts - INTERVAL'1 00:00:00.000000000') <=
TIMESTAMP'2001-01-01 01:02:03') and (TIMESTAMP'2001-01-01 01:02:03' < (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <= (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <> (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' = (ts +
INTERVAL'0 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' > (ts -
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' >= (ts -
INTERVAL'1 00:00:00.000000000')) and (ts < (ts + INTERVAL'1 00:00:00.000
000000')) and (ts <= (ts + INTERVAL'1 00:00:00.000000000')) and (ts <> (ts +
INTERVAL'1 00:00:00.000000000')) and (ts = (ts + INTERVAL'0
00:00:00.000000000')) and (ts > (ts - INTERVAL'1 00:00:00.000000000')) and (ts
>= (ts - INTERVAL'1 00:00:00.000000000'))) (type: boolean)
Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: ts (type: timestamp)
