[
https://issues.apache.org/jira/browse/TRAFODION-2047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15399361#comment-15399361
]
ASF GitHub Bot commented on TRAFODION-2047:
-------------------------------------------
Github user traflm commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/623#discussion_r72794212
--- Diff: core/sql/optimizer/BindRelExpr.cpp ---
@@ -717,7 +717,7 @@ static ItemExpr *intersectColumns(const RETDesc
&leftTable,
ItemExpr *leftExpr = leftTable.getValueId(i).getItemExpr();
ItemExpr *rightExpr = rightTable.getValueId(i).getItemExpr();
BiRelat *compare = new (bindWA->wHeap())
- BiRelat(ITM_EQUAL, leftExpr, rightExpr);
+ BiRelat(ITM_EQUAL, leftExpr, rightExpr, TRUE);
--- End diff --
EXPLAIN:
>> explain select eno, ename, dno from t021
intersect
+>+>select eno, ename, dno from t022;
------------------------------------------------------------------ PLAN
SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... NOT NAMED
PLAN_ID .................. 212336560049570734
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.02
STATEMENT ................ select eno, ename, dno
from t021 intersect select eno, ename,
dno from t022;
------------------------------------------------------------------ NODE
LISTING
ROOT ====================================== SEQ_NO 5 ONLY CHILD 4
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.02
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
statement_index ........ 0
affinity_value ......... 0
max_max_cardinality 100
total_overflow_size .... 0.00 KB
xn_access_mode ......... read_only
xn_autoabort_interval 0
auto_query_retry ....... enabled
plan_version ....... 2,600
embedded_arkcmp ........ used
IS_SQLCI ............... ON
LDAP_USERNAME
MODE_SPECIAL_4 ......... ON
GENERATE_EXPLAIN ....... ON
ObjectUIDs ............. 9084990775623580461, 9084990775623580331
select_list ............ TRAFODION.SEABASE.T022.ENO,
TRAFODION.SEABASE.T022.ENAME,
TRAFODION.SEABASE.T022.DNO
NESTED_JOIN =============================== SEQ_NO 4 CHILDREN 2, 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.02
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
join_type .............. inner
join_method ............ nested
TRAFODION_VSBB_SCAN ======================= SEQ_NO 3 NO CHILDREN
TABLE_NAME ............... T021
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.02
EST_TOTAL_COST ........... 0.02
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
scan_type .............. subset scan of table TRAFODION.SEABASE.T021
object_type ............ Trafodion
cache_size ........... 100
probes ................. 2
successful_probes ...... 2
unique_probes .......... 2
rows_accessed .......... 2
column_retrieved ....... #1:1,#1:2,#1:3
key_columns ............ ENO
executor_predicates .... (ENAME = TRAFODION.SEABASE.T022.ENAME) and (DNO =
TRAFODION.SEABASE.T022.DNO)
begin_key .............. (ENO = TRAFODION.SEABASE.T022.ENO)
end_key ................ (ENO = TRAFODION.SEABASE.T022.ENO)
HASH_GROUPBY ============================== SEQ_NO 2 ONLY CHILD 1
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
memory_quota ........... 1200 MB
max_card_est ........... 8
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
grouping_columns ....... TRAFODION.SEABASE.T022.ENO,
TRAFODION.SEABASE.T022.ENAME,
TRAFODION.SEABASE.T022.DNO
TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
TABLE_NAME ............... T022
REQUESTS_IN .............. 1
ROWS_OUT ................ 25
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est ......... 100
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
scan_type .............. subset scan of table TRAFODION.SEABASE.T022
object_type ............ Trafodion
columns ................ all
begin_keys(incl)
end_keys(incl)
cache_size ........... 100
probes ................. 1
rows_accessed ........ 100
column_retrieved ....... #1:1,#1:2,#1:3,#1:4
key_columns ............ SYSKEY
--- SQL operation complete.
SHOWPLAN ===================================================
>>showplan select eno, ename, dno from t021
intersect
+>+>select eno, ename, dno from t022;
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x43e93e0 (1)
Preds:
Succs:
NULL_VIOLATION_MBIN16U = [4,0](MBIN16U), 21 4 0
MOVE_MBIN32U_MBIN32U [2,0](MBIN32U) = [4,4](MBIN32U), 202 2 0 4 4
OPDATA_MPTR32_IBIN32S [2,0](MPTR32) = 0 2 0 10
CLAUSE_EVAL = 108 1448768272 32524 0
OPDATA_MPTR32_IBIN32S [4,8](MPTR32) = 0 4 8 0
OPDATA_MPTR32_IBIN32S [4,10](MPTR32) = 0 4 10 10
CLAUSE_EVAL = 108 1448768824 32524 0
OPDATA_MPTR32_IBIN32S [4,30](MPTR32) = 0 4 30 0
OPDATA_MPTR32_IBIN32S [4,32](MPTR32) = 0 4 32 10
CLAUSE_EVAL = 108 1448769384 32524 0
RETURN = 264
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x2d845c0 (1)
Preds:
Succs: 2 3
NNB_MATTR3_IBIN32S = [4,8,0](MPTR32), 306 4 8 0 10
BLOCK: 0x4a7bc70 (2)
Preds: 1
Succs: 4
MOVE_MBIN32S_IBIN32S [2,8](MBIN32S) = 3 2 8 666654765
BRANCH = 95 8
BLOCK: 0x4a7cae0 (3)
Preds: 1
Succs: 4
HASH_MBIN32U_MBIN32_IBIN32S_IBIN32S [2,8](MBIN32U) = [4,24](MBIN32S), 170 2
8 4 24 0 4
BLOCK: 0x43e9c50 (4)
Preds: 3 2
Succs: 5 6
NNB_MATTR3_IBIN32S = [4,8,1](MPTR32), 306 4 8 1 10
BLOCK: 0x43eaaa0 (5)
Preds: 4
Succs: 7
MOVE_MBIN32S_IBIN32S [2,12](MBIN32S) = 3 2 12 666654765
BRANCH = 95 8
BLOCK: 0x3543970 (6)
Preds: 4
Succs: 7
HASH_MBIN32U_MPTR32_IBIN32S_IBIN32S [2,12](MBIN32U) = [4,32](MPTR32), 94 2
12 4 32 0 20
BLOCK: 0x3544700 (7)
Preds: 6 5
Succs: 8 9
HASHCOMB_MBIN32U_MBIN32U_MBIN32U [2,4](MBIN32U) =
[2,8](MBIN32U),[2,12](MBIN32U), 156 2 4 2 8 2 12
NNB_MATTR3_IBIN32S = [4,8,2](MPTR32), 306 4 8 2 12
BLOCK: 0x371a980 (8)
Preds: 7
Succs:
HASHCOMB_MBIN32U_MBIN32U_MBIN32U [5,0](MBIN32U) =
[2,4](MBIN32U),[1,8](MBIN32U), 156 5 0 2 4 1 8
RETURN = 264
BLOCK: 0x371b7b0 (9)
Preds: 7
Succs:
HASH_MBIN32U_MBIN32_IBIN32S_IBIN32S [2,16](MBIN32U) = [4,28](MBIN32S), 170
2 16 4 28 0 4
HASHCOMB_MBIN32U_MBIN32U_MBIN32U [5,0](MBIN32U) =
[2,4](MBIN32U),[2,16](MBIN32U), 156 5 0 2 4 2 16
RETURN = 264
BLOCK: 0x51a5280 (10)
Preds:
Succs:
RETURN = 264
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x493a4b0 (1)
Preds:
Succs: 2 3
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S [5,0](MBIN16S) =
[4,8,0](MPTR32), 248 5 0 4 8 134219268 -1 0 14
BLOCK: 0x493b2a0 (2)
Preds: 1
Succs: 4
MOVE_MBIN32S_IBIN32S [5,4](MBIN32S) = 3 5 4 0
BRANCH = 95 6
BLOCK: 0x5c67910 (3)
Preds: 1
Succs: 4
MOVE_MBIN32U_MBIN32U [5,4](MBIN32U) = [4,24](MBIN32U), 202 5 4 4 24
BLOCK: 0x5c686a0 (4)
Preds: 3 2
Succs: 5 6
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S [5,8](MBIN16S) =
[4,8,1](MPTR32), 248 5 8 4 8 134219268 -1 1 15
BLOCK: 0x5c69510 (5)
Preds: 4
Succs: 7
FILL_MEM_BYTES [5,10](MPTR32)[5,12](MPTR32)[5,14](MPTR32) = 115 5 10 20 0
BRANCH = 95 7
BLOCK: 0x5c6a380 (6)
Preds: 4
Succs: 7
MOVE_MBIN8_MBIN8_IBIN32S [5,10](MPTR32) = [4,32](MPTR32), 4 5 10 4 32 20
BLOCK: 0x2984d30 (7)
Preds: 6 5
Succs: 8 9
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S [5,30](MBIN16S) =
[4,8,2](MPTR32), 248 5 30 4 8 134219268 -1 2 13
BLOCK: 0x2985ba0 (8)
Preds: 7
Succs:
MOVE_MBIN32S_IBIN32S [5,32](MBIN32S) = 3 5 32 0
RETURN = 264
BLOCK: 0x2986a10 (9)
Preds: 7
Succs:
MOVE_MBIN32U_MBIN32U [5,32](MBIN32U) = [4,28](MBIN32U), 202 5 32 4 28
RETURN = 264
BLOCK: 0x2d87830 (10)
Preds:
Succs:
RETURN = 264
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x3717880 (1)
Preds:
Succs:
MOVE_MBIN32U_MBIN32U [5,0](MBIN32U) = [4,0](MBIN32U), 202 5 0 4 0
MOVE_MBIN32U_MBIN32U [5,4](MBIN32U) = [4,4](MBIN32U), 202 5 4 4 4
MOVE_MBIN16U_MBIN16U [5,8](MBIN16U) = [4,8](MBIN16U), 201 5 8 4 8
MOVE_MBIN8_MBIN8_IBIN32S [5,10](MPTR32) = [4,10](MPTR32), 4 5 10 4 10 20
MOVE_MBIN16U_MBIN16U [5,30](MBIN16U) = [4,30](MBIN16U), 201 5 30 4 30
MOVE_MBIN32U_MBIN32U [5,32](MBIN32U) = [4,32](MBIN32U), 202 5 32 4 32
RETURN = 264
BLOCK: 0x3718670 (2)
Preds:
Succs:
RETURN = 264
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x3cbde80 (1)
Preds:
Succs: 2 3
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S [5,0](MBIN16S) =
[4,8,0](MPTR32), 248 5 0 4 8 134219268 -1 0 14
BLOCK: 0x3cbec70 (2)
Preds: 1
Succs: 4
MOVE_MBIN32S_IBIN32S [5,4](MBIN32S) = 3 5 4 0
BRANCH = 95 6
BLOCK: 0x3cbfae0 (3)
Preds: 1
Succs: 4
MOVE_MBIN32U_MBIN32U [5,4](MBIN32U) = [4,24](MBIN32U), 202 5 4 4 24
BLOCK: 0x3cc08d0 (4)
Preds: 3 2
Succs: 5 6
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S [5,8](MBIN16S) =
[4,8,1](MPTR32), 248 5 8 4 8 134219268 -1 1 15
BLOCK: 0x36b7a90 (5)
Preds: 4
Succs: 7
FILL_MEM_BYTES [5,10](MPTR32)[5,12](MPTR32)[5,14](MPTR32) = 115 5 10 20 0
BRANCH = 95 7
BLOCK: 0x36b8900 (6)
Preds: 4
Succs: 7
MOVE_MBIN8_MBIN8_IBIN32S [5,10](MPTR32) = [4,32](MPTR32), 4 5 10 4 32 20
BLOCK: 0x36b96f0 (7)
Preds: 6 5
Succs: 8 9
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S [5,30](MBIN16S) =
[4,8,2](MPTR32), 248 5 30 4 8 134219268 -1 2 13
BLOCK: 0x36ba560 (8)
Preds: 7
Succs:
MOVE_MBIN32S_IBIN32S [5,32](MBIN32S) = 3 5 32 0
RETURN = 264
BLOCK: 0x36bb3d0 (9)
Preds: 7
Succs:
MOVE_MBIN32U_MBIN32U [5,32](MBIN32U) = [4,28](MBIN32U), 202 5 32 4 28
RETURN = 264
BLOCK: 0x36bc1c0 (10)
Preds:
Succs:
RETURN = 264
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x3ac86a0 (1)
Preds:
Succs:
MOVE_MBIN8_MBIN8_IBIN32S [5,0](MPTR32) = [4,0](MPTR32), 4 5 0 4 0 36
RETURN = 264
BLOCK: 0x3ac9490 (2)
Preds:
Succs:
RETURN = 264
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x494d170 (1)
Preds:
Succs: 2 3
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S [2,8](MBIN32S) =
[4,8,0](MPTR32),[5,0](MBIN16S), 304 2 8 4 8 0 5 0 -1 2020 12
BLOCK: 0x494df60 (2)
Preds: 1
Succs: 4
BRANCH = 95 8
BLOCK: 0x494edd0 (3)
Preds: 1
Succs: 4
EQ_MBIN32S_MBIN32S_MBIN32S [2,8](MBIN32S) = [4,24](MBIN32S),[5,4](MBIN32S),
36 2 8 4 24 5 4
BLOCK: 0x494fbc0 (4)
Preds: 3 2
Succs: 5 13
BRANCH_AND [2,4](MBIN32S) = [2,8](MBIN32S), 168 67 0 0 0 2 4 2 8
BLOCK: 0x4950a30 (5)
Preds: 4
Succs: 6 7
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S [2,12](MBIN32S) =
[4,8,1](MPTR32),[5,8](MBIN16S), 304 2 12 4 8 1 5 8 -1 2020 12
BLOCK: 0x49518a0 (6)
Preds: 5
Succs: 8
BRANCH = 95 9
BLOCK: 0x4952710 (7)
Preds: 5
Succs: 8
EQ_MBIN32S_MASCII_MASCII [2,12](MBIN32S) = [4,32](MASCII),[5,10](MASCII),
117 2 12 4 32 5 10 20
BLOCK: 0x4953500 (8)
Preds: 7 6
Succs: 9 13
BRANCH_AND [2,0](MBIN32S) = [2,12](MBIN32S), 168 37 0 0 0 2 0 2 12
BLOCK: 0x4954370 (9)
Preds: 8
Succs: 10 11
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S [2,16](MBIN32S) =
[4,8,2](MPTR32),[5,30](MBIN16S), 304 2 16 4 8 2 5 30 -1 2020 12
BLOCK: 0x3724610 (10)
Preds: 9
Succs: 12
BRANCH = 95 8
BLOCK: 0x3725480 (11)
Preds: 9
Succs: 12
EQ_MBIN32S_MBIN32S_MBIN32S [2,16](MBIN32S) =
[4,28](MBIN32S),[5,32](MBIN32S), 36 2 16 4 28 5 32
BLOCK: 0x3726360 (12)
Preds: 11 10
Succs: 13 14
BRANCH_OR [2,0](MBIN32S) = [2,16](MBIN32S), 169 10 0 0 0 2 0 2 16
BLOCK: 0x3727140 (13)
Preds: 12 4 8
Succs:
RETURN_IBIN32S = 265 0
BLOCK: 0x3727fb0 (14)
Preds: 12
Succs:
RETURN_IBIN32S = 265 1
BLOCK: 0x3728da0 (15)
Preds:
Succs:
RETURN = 264
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x3a109c0 (1)
Preds:
Succs: 2 3
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S [2,8](MBIN32S) =
[4,0](MBIN16S),[5,0](MBIN16S), 304 2 8 4 0 -1 5 0 -1 2020 12
BLOCK: 0x3a117b0 (2)
Preds: 1
Succs: 4
BRANCH = 95 8
BLOCK: 0x3a12620 (3)
Preds: 1
Succs: 4
EQ_MBIN32S_MBIN32S_MBIN32S [2,8](MBIN32S) = [4,4](MBIN32S),[5,4](MBIN32S),
36 2 8 4 4 5 4
BLOCK: 0x3a13410 (4)
Preds: 3 2
Succs: 5 13
BRANCH_AND [2,4](MBIN32S) = [2,8](MBIN32S), 168 67 0 0 0 2 4 2 8
BLOCK: 0x3a14280 (5)
Preds: 4
Succs: 6 7
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S [2,12](MBIN32S) =
[4,8](MBIN16S),[5,8](MBIN16S), 304 2 12 4 8 -1 5 8 -1 2020 12
BLOCK: 0x3a150f0 (6)
Preds: 5
Succs: 8
BRANCH = 95 9
BLOCK: 0x3a15f60 (7)
Preds: 5
Succs: 8
EQ_MBIN32S_MASCII_MASCII [2,12](MBIN32S) = [4,10](MASCII),[5,10](MASCII),
117 2 12 4 10 5 10 20
BLOCK: 0x2b15880 (8)
Preds: 7 6
Succs: 9 13
BRANCH_AND [2,0](MBIN32S) = [2,12](MBIN32S), 168 37 0 0 0 2 0 2 12
BLOCK: 0x2b16690 (9)
Preds: 8
Succs: 10 11
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S [2,16](MBIN32S) =
[4,30](MBIN16S),[5,30](MBIN16S), 304 2 16 4 30 -1 5 30 -1 2020 12
BLOCK: 0x2b17500 (10)
Preds: 9
Succs: 12
BRANCH = 95 8
BLOCK: 0x2b18370 (11)
Preds: 9
Succs: 12
EQ_MBIN32S_MBIN32S_MBIN32S [2,16](MBIN32S) =
[4,32](MBIN32S),[5,32](MBIN32S), 36 2 16 4 32 5 32
BLOCK: 0x2b19200 (12)
Preds: 11 10
Succs: 13 14
BRANCH_OR [2,0](MBIN32S) = [2,16](MBIN32S), 169 10 0 0 0 2 0 2 16
BLOCK: 0x2b19fe0 (13)
Preds: 12 4 8
Succs:
RETURN_IBIN32S = 265 0
BLOCK: 0x2b1ae50 (14)
Preds: 12
Succs:
RETURN_IBIN32S = 265 1
BLOCK: 0x2b1bc40 (15)
Preds:
Succs:
RETURN = 264
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x2b236b0 (1)
Preds:
Succs: 2 3
HDR_MPTR32_IBIN32S_IBIN32S_IBIN32S_IBIN32S_IBIN32S
[4,0](MPTR32)[4,4](MBIN16S) = 303 4 0 16 16 4 8 4
MOVE_MBIN64S_MBIN64S [4,16](MBIN64S) = [5,0](MBIN64S), 203 4 16 5 0
OPDATA_MPTR32_IBIN32S [4,8](MPTR32) = 0 4 8 0
OPDATA_MBIN16U_IBIN32S = [5,8](MBIN16U), 1 5 8 1
OPDATA_MPTR32_IBIN32S [4,24](MPTR32) = 0 4 24 10
OPDATA_MPTR32_IBIN32S = [5,12](MPTR32), 0 5 12 11
CLAUSE_EVAL = 108 1448711376 32524 1
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S [4,8,1](MPTR32) =
[5,16](MBIN16S), 248 4 8 5 16 134218758 1 -1 34
BLOCK: 0x4a4c1f0 (2)
Preds: 1
Succs:
FILL_MEM_BYTES [4,32](MPTR32)[4,34](MPTR32)[4,36](MPTR32) = 115 4 32 20 0
OPDATA_MPTR32_IBIN32S [4,8](MPTR32) = 0 4 8 0
OPDATA_MBIN16U_IBIN32S = [5,38](MBIN16U), 1 5 38 1
OPDATA_MPTR32_IBIN32S [4,28](MPTR32) = 0 4 28 10
OPDATA_MPTR32_IBIN32S = [5,40](MPTR32), 0 5 40 11
CLAUSE_EVAL = 108 1448713768 32524 1
RETURN = 264
BLOCK: 0x4a4d060 (3)
Preds: 1
Succs:
MOVE_MBIN8_MBIN8_IBIN32S [4,32](MPTR32) = [5,18](MPTR32), 4 4 32 5 18 20
OPDATA_MPTR32_IBIN32S [4,8](MPTR32) = 0 4 8 0
OPDATA_MBIN16U_IBIN32S = [5,38](MBIN16U), 1 5 38 1
OPDATA_MPTR32_IBIN32S [4,28](MPTR32) = 0 4 28 10
OPDATA_MPTR32_IBIN32S = [5,40](MPTR32), 0 5 40 11
CLAUSE_EVAL = 108 1448713768 32524 1
RETURN = 264
BLOCK: 0x4a4de50 (4)
Preds:
Succs:
RETURN = 264
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x4a589b0 (1)
Preds:
Succs:
CONVVCPTR_MBIN64S_MATTR5_IBIN32S [2,0](MBIN64S) = [5,2](MATTR5), 330 2 0 5
2 -1 8 512 8
ENCODE_MASCII_MBIN64S_IBIN32S [4,0](MBIN64S) = [2,0](MBIN64S), 91 4 0 2 0 0
RETURN = 264
BLOCK: 0x4a597a0 (2)
Preds:
Succs:
RETURN = 264
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x4a904e0 (1)
Preds:
Succs: 2 3
HDR_MPTR32_IBIN32S_IBIN32S_IBIN32S_IBIN32S_IBIN32S
[4,0](MPTR32)[4,4](MBIN16S) = 303 4 0 12 12 4 8 4
OPDATA_MPTR32_IBIN32S [4,12](MPTR32) = 0 4 12 10
OPDATA_MPTR32_IBIN32S = [5,0](MPTR32), 0 5 0 11
CLAUSE_EVAL = 108 1448757280 32524 0
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S [4,8,0](MPTR32) =
[5,4](MBIN16S), 248 4 8 5 4 134218758 0 -1 34
BLOCK: 0x4a912d0 (2)
Preds: 1
Succs:
FILL_MEM_BYTES [4,20](MPTR32)[4,22](MPTR32)[4,24](MPTR32) = 115 4 20 20 0
OPDATA_MPTR32_IBIN32S [4,8](MPTR32) = 0 4 8 0
OPDATA_MBIN16U_IBIN32S = [5,26](MBIN16U), 1 5 26 1
OPDATA_MPTR32_IBIN32S [4,16](MPTR32) = 0 4 16 10
OPDATA_MPTR32_IBIN32S = [5,28](MPTR32), 0 5 28 11
CLAUSE_EVAL = 108 1448759672 32524 1
RETURN = 264
BLOCK: 0x4a92140 (3)
Preds: 1
Succs:
MOVE_MBIN8_MBIN8_IBIN32S [4,20](MPTR32) = [5,6](MPTR32), 4 4 20 5 6 20
OPDATA_MPTR32_IBIN32S [4,8](MPTR32) = 0 4 8 0
OPDATA_MBIN16U_IBIN32S = [5,26](MBIN16U), 1 5 26 1
OPDATA_MPTR32_IBIN32S [4,16](MPTR32) = 0 4 16 10
OPDATA_MPTR32_IBIN32S = [5,28](MPTR32), 0 5 28 11
CLAUSE_EVAL = 108 1448759672 32524 1
RETURN = 264
BLOCK: 0x4a92f30 (4)
Preds:
Succs:
RETURN = 264
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x514c850 (1)
Preds:
Succs: 2 3
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S [2,4](MBIN32S) =
[5,8,0](MPTR32),[4,8](MBIN16S), 304 2 4 5 8 0 4 8 -1 2020 12
BLOCK: 0x514d640 (2)
Preds: 1
Succs: 4
BRANCH = 95 9
BLOCK: 0x514e4b0 (3)
Preds: 1
Succs: 4
EQ_MBIN32S_MASCII_MASCII [2,4](MBIN32S) = [5,20](MASCII),[4,10](MASCII),
117 2 4 5 20 4 10 20
BLOCK: 0x514f2a0 (4)
Preds: 3 2
Succs: 5 9
BRANCH_AND [2,0](MBIN32S) = [2,4](MBIN32S), 168 37 0 0 0 2 0 2 4
BLOCK: 0x5150110 (5)
Preds: 4
Succs: 6 7
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S [2,8](MBIN32S) =
[5,8,1](MPTR32),[4,30](MBIN16S), 304 2 8 5 8 1 4 30 -1 2020 12
BLOCK: 0x4a632b0 (6)
Preds: 5
Succs: 8
BRANCH = 95 8
BLOCK: 0x4a640f0 (7)
Preds: 5
Succs: 8
EQ_MBIN32S_MBIN32S_MBIN32S [2,8](MBIN32S) =
[5,16](MBIN32S),[4,32](MBIN32S), 36 2 8 5 16 4 32
BLOCK: 0x4a64ee0 (8)
Preds: 7 6
Succs: 9 10
BRANCH_OR [2,0](MBIN32S) = [2,8](MBIN32S), 169 10 0 0 0 2 0 2 8
BLOCK: 0x4a65d50 (9)
Preds: 8 4
Succs:
RETURN_IBIN32S = 265 0
BLOCK: 0x4a66bc0 (10)
Preds: 8
Succs:
RETURN_IBIN32S = 265 1
BLOCK: 0x4a679b0 (11)
Preds:
Succs:
RETURN = 264
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*
CFG [0]
*-*-*-*
BLOCK: 0x4054930 (1)
Preds:
Succs:
OPDATA_MBIN16U_IBIN32S = [4,0](MBIN16U), 1 4 0 1
OPDATA_MPTR32_IBIN32S [2,0](MPTR32) = 0 2 0 10
OPDATA_MPTR32_IBIN32S = [4,4](MPTR32), 0 4 4 11
OPDATA_MPTR32_IBIN32S = [6,0](MPTR32), 0 6 0 12
CLAUSE_EVAL = 108 1448752192 32524 1
ENCODE_MASCII_MBIN32S_IBIN32S [5,0](MBIN32S) = [2,0](MBIN32S), 89 5 0 2 0 0
RETURN = 264
BLOCK: 0x4055720 (2)
Preds:
Succs:
RETURN = 264
MASTER Executor fragment
========================
Fragment ID: 0, Length: 67376
Contents of EX_ROOT [5]:
------------------------
For ComTdb :
Class Version = 1, Class Size = 536
InitialQueueSizeDown = 4, InitialQueueSizeUp = 4
queueResizeLimit = 9, queueResizeFactor = 4
queueSizeDown = 0, queueSizeUp = 0, numBuffers = 0, bufferSize = 0
estimatedRowUsed = 0, estimatedRowsAccessed = 0, expressionMode = 0
Flag = 0000000100101001
For ComTdbRoot :
FirstNRows = -1, baseTablenamePosition = -1
queryType_ = 2, planVersion_ = 2600
rtFlags1_ = 00100000001100000000101000000000
rtFlags2_ = 00000000000000000000000000001000
rtFlags3_ = 0000000000000000
rtFlags4_ = 00000000000000000010000000000000
rtFlags5_ = 00000000000000000000000000000000
queryType_ = 2
inputVarsSize_ = 0
explain_plan_size = 5496
# of Expressions = 4
Expression: inputExpr_ is NULL
Expression: outputExpr_
Expr Len: 496, Consts Len: 0
flags_ = 0000000010001000
Clause #1: ex_conv_clause
OperatorTypeEnum = ITM_CAST(2452), NumOperands = 2
ex_clause::flags_ = 0000000010000010
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 173
Text = cast
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 2
Offset = 4, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 14
Text = TRAFODION.SEABASE.T022.ENO
Clause #2: ex_inout_clause
OperatorTypeEnum = ITM_NATYPE(2454), NumOperands = 1
ex_clause::flags_ = 0000000010100000
ex_inout_clause::flags_ = 0000000000000000
PCODE = not supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 174
Text = INTEGER SIGNED
Clause #3: ex_inout_clause
OperatorTypeEnum = ITM_NATYPE(2454), NumOperands = 1
ex_clause::flags_ = 0000000010100100
ex_inout_clause::flags_ = 0000000000000000
PCODE = not supported
Operand #0 (result):
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 2
Offset = 10, NullIndOffset = 8, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 175
Text = CHAR(20) CHARACTER SET ISO88591
Clause #4: ex_inout_clause
OperatorTypeEnum = ITM_NATYPE(2454), NumOperands = 1
ex_clause::flags_ = 0000000010100100
ex_inout_clause::flags_ = 0000000000000000
PCODE = not supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 2
Offset = 32, NullIndOffset = 30, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 176
Text = INTEGER SIGNED
PCode:
PCode Expr Length: 176
[1]
NULL_VIOLATION_MBIN16U (21) 4 0
MOVE_MBIN32U_MBIN32U (202) 2 0 4 4
OPDATA_MPTR32_IBIN32S (0) 2 0 10
CLAUSE_EVAL (108) 1448768272 32524 0
OPDATA_MPTR32_IBIN32S (0) 4 8 0
OPDATA_MPTR32_IBIN32S (0) 4 10 10
CLAUSE_EVAL (108) 1448768824 32524 0
OPDATA_MPTR32_IBIN32S (0) 4 30 0
OPDATA_MPTR32_IBIN32S (0) 4 32 10
CLAUSE_EVAL (108) 1448769384 32524 0
Expression: pkeyExpr_ is NULL
Expression: predExpr_ is NULL
Contents of EX_ONLJ [4]:
------------------------
For ComTdb :
Class Version = 1, Class Size = 264
InitialQueueSizeDown = 4, InitialQueueSizeUp = 4
queueResizeLimit = 9, queueResizeFactor = 4
queueSizeDown = 2048, queueSizeUp = 2048, numBuffers = 5, bufferSize = 5120
estimatedRowUsed = 2, estimatedRowsAccessed = 0, expressionMode = 0
Flag = 0000000000001001
For ComTdbOnlj :
Flags = 0000000000000000, ljRecLen = 0, instantiatedRowAtpIndex = 0
# of Expressions = 4
Expression: postJoinPred_ is NULL
Expression: preJoinPred_ is NULL
Expression: ljExpr_ is NULL
Expression: niExpr_ is NULL
Contents of EX_HASH_GRBY [2]:
-----------------------------
For ComTdb :
Class Version = 1, Class Size = 360
InitialQueueSizeDown = 4, InitialQueueSizeUp = 2048
queueResizeLimit = 9, queueResizeFactor = 4
queueSizeDown = 2048, queueSizeUp = 2048, numBuffers = 5, bufferSize =
262144
estimatedRowUsed = 2, estimatedRowsAccessed = 0, expressionMode = 0
Flag = 0000000000001001
For ComTdbHashGrby :
resultRowLength = 36, extGroupedRowLength = 52
keyLength = 34, isPartialGroup = 0, initialHashTableSize = 262144
memUsagePercent = 5, pressureThreshold = 100, minBuffersToFlush = 4
logDiagnostics = 0
memoryQuotaMB = 1200
# of Expressions = 13
Expression: hashExpr_
Expr Len: 616, Consts Len: 12
flags_ = 0000000010001000
Clause #1: ex_function_clause
OperatorTypeEnum = ITM_HASH(2115), NumOperands = 2
ex_clause::flags_ = 0000000010000010
ex_function_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_UNSIGNED(133), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 8, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 134
Text = Hash
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 24, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 8, VoaOffset = -1, NullBitIdx = 0
NullIndLength = 0, VClenIndLength = 0
ValueId = 14
Text = TRAFODION.SEABASE.T022.ENO
Clause #2: ex_function_clause
OperatorTypeEnum = ITM_HASH(2115), NumOperands = 2
ex_clause::flags_ = 0000000010000010
ex_function_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_UNSIGNED(133), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 12, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 135
Text = Hash
Operand #1:
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 32, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 16, VoaOffset = -1, NullBitIdx = 1
NullIndLength = 0, VClenIndLength = 0
ValueId = 15
Text = TRAFODION.SEABASE.T022.ENAME
Clause #3: ex_function_clause
OperatorTypeEnum = ITM_HASHCOMB(2362), NumOperands = 3
ex_clause::flags_ = 0000000010000000
ex_function_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_UNSIGNED(133), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 136
Text = HashComb
Operand #1:
Datatype = REC_BIN32_UNSIGNED(133), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 8, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 134
Text = Hash
Operand #2:
Datatype = REC_BIN32_UNSIGNED(133), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 12, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 135
Text = Hash
Clause #4: ex_function_clause
OperatorTypeEnum = ITM_HASH(2115), NumOperands = 2
ex_clause::flags_ = 0000000010000010
ex_function_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_UNSIGNED(133), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 16, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 137
Text = Hash
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 28, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 12, VoaOffset = -1, NullBitIdx = 2
NullIndLength = 0, VClenIndLength = 0
ValueId = 16
Text = TRAFODION.SEABASE.T022.DNO
Clause #5: ex_function_clause
OperatorTypeEnum = ITM_HASHCOMB(2362), NumOperands = 3
ex_clause::flags_ = 0000000010000000
ex_function_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_UNSIGNED(133), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 138
Text = HashComb
Operand #1:
Datatype = REC_BIN32_UNSIGNED(133), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 136
Text = HashComb
Operand #2:
Datatype = REC_BIN32_UNSIGNED(133), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 16, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 137
Text = Hash
Clause #6: ex_conv_clause
OperatorTypeEnum = ITM_CAST(2452), NumOperands = 2
ex_clause::flags_ = 0000000010000000
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_UNSIGNED(133), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 4
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 139
Text = cast
Operand #1:
Datatype = REC_BIN32_UNSIGNED(133), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 138
Text = HashComb
PCode:
PCode Expr Length: 308
[1]
NNB_MATTR3_IBIN32S (306) 4 8 0 10 (Tgt: 3)
[2]
MOVE_MBIN32S_IBIN32S (3) 2 8 666654765
BRANCH (95) 8 (Tgt: 4)
[3] (Preds: 1 )
HASH_MBIN32U_MBIN32_IBIN32S_IBIN32S (170) 2 8 4 24 0 4
[4] (Preds: 2 )
NNB_MATTR3_IBIN32S (306) 4 8 1 10 (Tgt: 6)
[5]
MOVE_MBIN32S_IBIN32S (3) 2 12 666654765
BRANCH (95) 8 (Tgt: 7)
[6] (Preds: 4 )
HASH_MBIN32U_MPTR32_IBIN32S_IBIN32S (94) 2 12 4 32 0 20
[7] (Preds: 5 )
HASHCOMB_MBIN32U_MBIN32U_MBIN32U (156) 2 4 2 8 2 12
NNB_MATTR3_IBIN32S (306) 4 8 2 12 (Tgt: 9)
[8]
HASHCOMB_MBIN32U_MBIN32U_MBIN32U (156) 5 0 2 4 1 8
RETURN (264)
[9] (Preds: 7 )
HASH_MBIN32U_MBIN32_IBIN32S_IBIN32S (170) 2 16 4 28 0 4
HASHCOMB_MBIN32U_MBIN32U_MBIN32U (156) 5 0 2 4 2 16
RETURN (264)
Expression: bitMuxExpr_ is NULL
Expression: bitMuxAggrExpr_ is NULL
Expression: hbMoveInExpr_
Expr Len: 736, Consts Len: 175
flags_ = 0000001110011000
Clause #1: ex_conv_clause
OperatorTypeEnum = ITM_CONVERT(2451), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 4, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 111
Text = convert
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000001
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 24, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 8, VoaOffset = -1, NullBitIdx = 0
NullIndLength = 0, VClenIndLength = 0
ValueId = 14
Text = TRAFODION.SEABASE.T022.ENO
Clause #2: ex_conv_clause
OperatorTypeEnum = ITM_CONVERT(2451), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 10, NullIndOffset = 8, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 113
Text = convert
Operand #1:
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 32, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 16, VoaOffset = -1, NullBitIdx = 1
NullIndLength = 0, VClenIndLength = 0
ValueId = 15
Text = TRAFODION.SEABASE.T022.ENAME
Clause #3: ex_conv_clause
OperatorTypeEnum = ITM_CONVERT(2451), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 32, NullIndOffset = 30, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 115
Text = convert
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000001
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 28, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 12, VoaOffset = -1, NullBitIdx = 2
NullIndLength = 0, VClenIndLength = 0
ValueId = 16
Text = TRAFODION.SEABASE.T022.DNO
PCode:
PCode Expr Length: 272
[1]
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S (248) 5 0 4 8 134219268
-1 0 14 (Tgt: 3)
[2]
MOVE_MBIN32S_IBIN32S (3) 5 4 0
BRANCH (95) 6 (Tgt: 4)
[3] (Preds: 1 )
MOVE_MBIN32U_MBIN32U (202) 5 4 4 24
[4] (Preds: 2 )
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S (248) 5 8 4 8 134219268
-1 1 15 (Tgt: 6)
[5]
FILL_MEM_BYTES (115) 5 10 20 0
BRANCH (95) 7 (Tgt: 7)
[6] (Preds: 4 )
MOVE_MBIN8_MBIN8_IBIN32S (4) 5 10 4 32 20
[7] (Preds: 5 )
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S (248) 5 30 4 8 134219268
-1 2 13 (Tgt: 9)
[8]
MOVE_MBIN32S_IBIN32S (3) 5 32 0
RETURN (264)
[9] (Preds: 7 )
MOVE_MBIN32U_MBIN32U (202) 5 32 4 28
RETURN (264)
Native Expr (Length: 167 bytes)
mov 0x30(%rdx), %rax 488b4230
mov 0x10(%rax), %rax 488b4010
mov 0x38(%rsi), %rcx 488b4e38
mov 0x10(%rcx), %rcx 488b4910
cmp $0x0, 0x8(%rcx) 80790800
js 0x2a 0f8810000000
mov $0x0, (%rax) 66c7000000
mov 0x18(%rcx), %edx 8b5118
mov %edx, 0x4(%rax) 895004
jmp 0x36 e90c000000
mov $0xffff, (%rax) 66c700ffff
mov $0x0, 0x4(%rax) c7400400000000
test $0x40, 0x8(%rcx) f6410840
jz 0x62 0f8422000000
mov $0xffff, 0x8(%rax) 66c74008ffff
mov $0x0, 0xa(%rax) 48c7400a00000000
mov $0x0, 0x12(%rax) 48c7401200000000
mov $0x0, 0xa(%rax) c7400a00000000
jmp 0x7e e91c000000
mov $0x0, 0x8(%rax) 66c740080000
mov 0x20(%rcx), %rdx 488b5120
mov %rdx, 0xa(%rax) 4889500a
mov 0x28(%rcx), %rdx 488b5128
mov %rdx, 0x12(%rax) 48895012
mov 0x30(%rcx), %edx 8b5130
mov %edx, 0x1a(%rax) 89501a
test $0x20, 0x8(%rcx) f6410820
jz 0x98 0f8410000000
mov $0xffff, 0x1e(%rax) 66c7401effff
mov $0x0, 0x20(%rax) c7402000000000
xor %eax, %eax 31c0
ret c3
mov $0x0, 0x1e(%rax) 66c7401e0000
mov 0x1c(%rcx), %ecx 8b491c
mov %ecx, 0x20(%rax) 894820
xor %eax, %eax 31c0
ret c3
Expression: ofMoveInExpr_
Expr Len: 528, Consts Len: 81
flags_ = 0000001110011000
Clause #1: ex_conv_clause
OperatorTypeEnum = ITM_CONVERT(2451), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 4, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 149
Text = convert
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 4, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 111
Text = convert
Clause #2: ex_conv_clause
OperatorTypeEnum = ITM_CONVERT(2451), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 10, NullIndOffset = 8, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 151
Text = convert
Operand #1:
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 10, NullIndOffset = 8, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 113
Text = convert
Clause #3: ex_conv_clause
OperatorTypeEnum = ITM_CONVERT(2451), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 32, NullIndOffset = 30, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 153
Text = convert
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 32, NullIndOffset = 30, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 115
Text = convert
PCode:
PCode Expr Length: 152
[1]
MOVE_MBIN32U_MBIN32U (202) 5 0 4 0
MOVE_MBIN32U_MBIN32U (202) 5 4 4 4
MOVE_MBIN16U_MBIN16U (201) 5 8 4 8
MOVE_MBIN8_MBIN8_IBIN32S (4) 5 10 4 10 20
MOVE_MBIN16U_MBIN16U (201) 5 30 4 30
MOVE_MBIN32U_MBIN32U (202) 5 32 4 32
RETURN (264)
Native Expr (Length: 73 bytes)
mov 0x30(%rdx), %rax 488b4230
mov 0x10(%rax), %rax 488b4010
mov 0x38(%rsi), %rcx 488b4e38
mov 0x10(%rcx), %rcx 488b4910
mov (%rcx), %edx 8b11
mov %edx, (%rax) 8910
mov 0x4(%rcx), %edx 8b5104
mov %edx, 0x4(%rax) 895004
mov 0x8(%rcx), %dx 668b5108
mov %dx, 0x8(%rax) 66895008
mov 0xa(%rcx), %rdx 488b510a
mov %rdx, 0xa(%rax) 4889500a
mov 0x12(%rcx), %rdx 488b5112
mov %rdx, 0x12(%rax) 48895012
mov 0x1a(%rcx), %edx 8b511a
mov %edx, 0x1a(%rax) 89501a
mov 0x1e(%rcx), %dx 668b511e
mov %dx, 0x1e(%rax) 6689501e
mov 0x20(%rcx), %ecx 8b4920
mov %ecx, 0x20(%rax) 894820
xor %eax, %eax 31c0
ret c3
Expression: resMoveInExpr_
Expr Len: 736, Consts Len: 175
flags_ = 0000001110011000
Clause #1: ex_conv_clause
OperatorTypeEnum = ITM_CONVERT(2451), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 5
Offset = 4, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 131
Text = convert
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000001
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 24, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 8, VoaOffset = -1, NullBitIdx = 0
NullIndLength = 0, VClenIndLength = 0
ValueId = 14
Text = TRAFODION.SEABASE.T022.ENO
Clause #2: ex_conv_clause
OperatorTypeEnum = ITM_CONVERT(2451), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 5
Offset = 10, NullIndOffset = 8, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 132
Text = convert
Operand #1:
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 32, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 16, VoaOffset = -1, NullBitIdx = 1
NullIndLength = 0, VClenIndLength = 0
ValueId = 15
Text = TRAFODION.SEABASE.T022.ENAME
Clause #3: ex_conv_clause
OperatorTypeEnum = ITM_CONVERT(2451), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 5
Offset = 32, NullIndOffset = 30, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 133
Text = convert
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000001
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 28, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 12, VoaOffset = -1, NullBitIdx = 2
NullIndLength = 0, VClenIndLength = 0
ValueId = 16
Text = TRAFODION.SEABASE.T022.DNO
PCode:
PCode Expr Length: 272
[1]
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S (248) 5 0 4 8 134219268
-1 0 14 (Tgt: 3)
[2]
MOVE_MBIN32S_IBIN32S (3) 5 4 0
BRANCH (95) 6 (Tgt: 4)
[3] (Preds: 1 )
MOVE_MBIN32U_MBIN32U (202) 5 4 4 24
[4] (Preds: 2 )
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S (248) 5 8 4 8 134219268
-1 1 15 (Tgt: 6)
[5]
FILL_MEM_BYTES (115) 5 10 20 0
BRANCH (95) 7 (Tgt: 7)
[6] (Preds: 4 )
MOVE_MBIN8_MBIN8_IBIN32S (4) 5 10 4 32 20
[7] (Preds: 5 )
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S (248) 5 30 4 8 134219268
-1 2 13 (Tgt: 9)
[8]
MOVE_MBIN32S_IBIN32S (3) 5 32 0
RETURN (264)
[9] (Preds: 7 )
MOVE_MBIN32U_MBIN32U (202) 5 32 4 28
RETURN (264)
Native Expr (Length: 167 bytes)
mov 0x48(%rdx), %rax 488b4248
mov 0x10(%rax), %rax 488b4010
mov 0x38(%rsi), %rcx 488b4e38
mov 0x10(%rcx), %rcx 488b4910
cmp $0x0, 0x8(%rcx) 80790800
js 0x2a 0f8810000000
mov $0x0, (%rax) 66c7000000
mov 0x18(%rcx), %edx 8b5118
mov %edx, 0x4(%rax) 895004
jmp 0x36 e90c000000
mov $0xffff, (%rax) 66c700ffff
mov $0x0, 0x4(%rax) c7400400000000
test $0x40, 0x8(%rcx) f6410840
jz 0x62 0f8422000000
mov $0xffff, 0x8(%rax) 66c74008ffff
mov $0x0, 0xa(%rax) 48c7400a00000000
mov $0x0, 0x12(%rax) 48c7401200000000
mov $0x0, 0xa(%rax) c7400a00000000
jmp 0x7e e91c000000
mov $0x0, 0x8(%rax) 66c740080000
mov 0x20(%rcx), %rdx 488b5120
mov %rdx, 0xa(%rax) 4889500a
mov 0x28(%rcx), %rdx 488b5128
mov %rdx, 0x12(%rax) 48895012
mov 0x30(%rcx), %edx 8b5130
mov %edx, 0x1a(%rax) 89501a
test $0x20, 0x8(%rcx) f6410820
jz 0x98 0f8410000000
mov $0xffff, 0x1e(%rax) 66c7401effff
mov $0x0, 0x20(%rax) c7402000000000
xor %eax, %eax 31c0
ret c3
mov $0x0, 0x1e(%rax) 66c7401e0000
mov 0x1c(%rcx), %ecx 8b491c
mov %ecx, 0x20(%rax) 894820
xor %eax, %eax 31c0
ret c3
Expression: hbAggrExpr_ is NULL
Expression: ofAggrExpr_ is NULL
Expression: resAggrExpr_ is NULL
Expression: havingExpr_ is NULL
Expression: moveOutExpr_
Expr Len: 448, Consts Len: 99
flags_ = 0000001110011000
Clause #1: ex_conv_clause
OperatorTypeEnum = ITM_CONVERT(2451), NumOperands = 2
ex_clause::flags_ = 0000000010000000
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BYTE_F_ASCII(0), Length = 36, Null Flag = 0
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 5
Offset = 0, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 148
Text = convert
Operand #1:
Datatype = REC_BYTE_F_ASCII(0), Length = 36, Null Flag = 0
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 0, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 147
Text = CHAR(36) CHARACTER SET ISO88591
PCode:
PCode Expr Length: 52
[1]
MOVE_MBIN8_MBIN8_IBIN32S (4) 5 0 4 0 36
RETURN (264)
Native Expr (Length: 91 bytes)
mov 0x30(%rdx), %rax 488b4230
mov 0x48(%rdx), %rcx 488b4a48
mov 0x10(%rax), %rdi 488b7810
mov 0x10(%rcx), %rcx 488b4910
mov $0x0, -0x8(%rsp) 48c74424f800000000
xor %edx, %edx 31d2
mov (%rdi,%rdx), %rsi 488b3417
mov %rsi, (%rcx,%rdx) 48893411
add $0x8, %rdx 4883c208
mov %rdx, -0x8(%rsp) 48895424f8
cmp $0x20, %rdx 4883fa20
jb 0x1b 0f82e5ffffff
cmp $0x23, %rdx 4883fa23
ja 0x58 0f8718000000
mov (%rdi,%rdx), %al 8a0417
mov %al, (%rcx,%rdx) 880411
inc %rdx 48ffc2
mov %rdx, -0x8(%rsp) 48895424f8
cmp $0x24, %rdx 4883fa24
jb 0x40 0f82e8ffffff
xor %eax, %eax 31c0
ret c3
Expression: hbSearchExpr_
Expr Len: 1056, Consts Len: 376
flags_ = 0000001110011000
Clause #1: ex_comp_clause
OperatorTypeEnum = ITM_EQUAL(2020), NumOperands = 3
ex_clause::flags_ = 0000000010000011
ex_comp_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 8, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 112
Text = =
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000001
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 24, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 8, VoaOffset = -1, NullBitIdx = 0
NullIndLength = 0, VClenIndLength = 0
ValueId = 14
Text = TRAFODION.SEABASE.T022.ENO
Operand #2:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 4, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 111
Text = convert
Clause #2: ex_branch_clause
OperatorTypeEnum = ITM_AND(2001), NumOperands = 2
flags_ = 0000000010000000
PCODE = supported
branch to = #4
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 8, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
Clause #3: ex_comp_clause
OperatorTypeEnum = ITM_EQUAL(2020), NumOperands = 3
ex_clause::flags_ = 0000000010000011
ex_comp_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 12, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 114
Text = =
Operand #1:
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 32, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 16, VoaOffset = -1, NullBitIdx = 1
NullIndLength = 0, VClenIndLength = 0
ValueId = 15
Text = TRAFODION.SEABASE.T022.ENAME
Operand #2:
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 10, NullIndOffset = 8, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 113
Text = convert
Clause #4: ex_bool_clause
OperatorTypeEnum = ITM_AND(2001), NumOperands = 3
ex_clause::flags_ = 0000000010000000
ex_bool_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 141
Text = and
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 8, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 112
Text = =
Operand #2:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 12, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 114
Text = =
Clause #5: ex_branch_clause
OperatorTypeEnum = ITM_AND(2001), NumOperands = 2
flags_ = 0000000010000000
PCODE = supported
branch to = #7
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
Clause #6: ex_comp_clause
OperatorTypeEnum = ITM_EQUAL(2020), NumOperands = 3
ex_clause::flags_ = 0000000010000011
ex_comp_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 16, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 116
Text = =
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000001
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 28, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 12, VoaOffset = -1, NullBitIdx = 2
NullIndLength = 0, VClenIndLength = 0
ValueId = 16
Text = TRAFODION.SEABASE.T022.DNO
Operand #2:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 32, NullIndOffset = 30, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 115
Text = convert
Clause #7: ex_bool_clause
OperatorTypeEnum = ITM_AND(2001), NumOperands = 3
ex_clause::flags_ = 0000000010000000
ex_bool_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 142
Text = and
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 141
Text = and
Operand #2:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 16, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 116
Text = =
Clause #8: bool_result_clause
OperatorTypeEnum = ITM_BOOL_RESULT(2107), NumOperands = 1
ex_clause::flags_ = 0000000010000000
bool_result_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 143
Text = bool_result
PCode:
PCode Expr Length: 392
[1]
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S (304) 2 8 4 8 0
5 0 -1 2020 12 (Tgt: 3)
[2]
BRANCH (95) 8 (Tgt: 4)
[3] (Preds: 1 )
EQ_MBIN32S_MBIN32S_MBIN32S (36) 2 8 4 24 5 4
[4] (Preds: 2 )
BRANCH_AND (168) 67 0 0 0 2 4 2 8 (Tgt: 13)
[5]
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S (304) 2 12 4 8
1 5 8 -1 2020 12 (Tgt: 7)
[6]
BRANCH (95) 9 (Tgt: 8)
[7] (Preds: 5 )
EQ_MBIN32S_MASCII_MASCII (117) 2 12 4 32 5 10 20
[8] (Preds: 6 )
BRANCH_AND (168) 37 0 0 0 2 0 2 12 (Tgt: 13)
[9]
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S (304) 2 16 4 8
2 5 30 -1 2020 12 (Tgt: 11)
[10]
BRANCH (95) 8 (Tgt: 12)
[11] (Preds: 9 )
EQ_MBIN32S_MBIN32S_MBIN32S (36) 2 16 4 28 5 32
[12] (Preds: 10 )
BRANCH_OR (169) 10 0 0 0 2 0 2 16 (Tgt: 14)
[13] (Preds: 4 8 )
RETURN_IBIN32S (265) 0
[14] (Preds: 12 )
RETURN_IBIN32S (265) 1
Native Expr (Length: 368 bytes)
push %rbp 55
mov %rsp, %rbp 4889e5
sub $0x10, %rsp 4883ec10
mov 0x30(%rdx), %rax 488b4230
mov 0x10(%rax), %r9 4c8b4810
movzx (%r9), %eax 410fb701
mov 0x38(%rsi), %rcx 488b4e38
mov 0x10(%rcx), %r8 4c8b4110
mov 0x8(%r8), %sil 418a7008
test %sil, %sil 4084f6
js 0x51 0f8828000000
test %ax, %ax 6685c0
jnz 0x5f 0f852d000000
mov $0x0, -0x4(%rbp) c745fc00000000
mov 0x18(%r8), %eax 418b4018
mov $0x1, %edi bf01000000
cmp 0x4(%r9), %eax 413b4104
jnz 0x5f 0f8513000000
jmp 0x61 e910000000
mov $0x1, %edi bf01000000
test %ax, %ax 6685c0
jnz 0x61 0f8502000000
xor %edi, %edi 31ff
mov %edi, -0x4(%rbp) 897dfc
mov $0x3, %eax b803000000
test %edi, %edi 85ff
jz 0x16b 0f84fa000000
movzx 0x8(%r9), %ecx 410fb74908
test $0x40, %sil 40f6c640
jz 0x93 0f8413000000
mov $0x1, %esi be01000000
test %cx, %cx 6685c9
jnz 0x109 0f857b000000
jmp 0x9c e909000000
test %cx, %cx 6685c9
jz 0xa3 0f8407000000
xor %esi, %esi 31f6
jmp 0x109 e966000000
mov $0x0, -0x8(%rbp) c745f800000000
mov %rsp, %rcx 4889e1
lea -0x10(%rcx), %rsi 488d71f0
mov %rsi, %rsp 4889f4
mov $0x0, -0x10(%rcx) 48c741f000000000
xor %edi, %edi 31ff
mov 0x20(%r8,%rdi), %rcx 498b4c3820
cmp 0xa(%r9,%rdi), %rcx 493b4c390a
jnz 0xdf 0f8511000000
add $0x8, %rdi 4883c708
mov %rdi, (%rsi) 48893e
cmp $0x10, %rdi 4883ff10
jb 0xbe 0f82dfffffff
mov 0xa(%r9,%rdi), %dl 418a54390a
mov 0x20(%r8,%rdi), %cl 418a4c3820
cmp %dl, %cl 38d1
jnz 0x101 0f8510000000
inc %rdi 48ffc7
mov %rdi, (%rsi) 48893e
cmp $0x14, %rdi 4883ff14
jb 0xdf 0f82deffffff
cmp %dl, %cl 38d1
setz %cl 0f94c1
movzx %cl, %esi 0fb6f1
mov %esi, -0x8(%rbp) 8975f8
test %esi, %esi 85f6
jz 0x16b 0f8457000000
movzx 0x1e(%r9), %ecx 410fb7491e
test $0x20, 0x8(%r8) 41f6400820
jz 0x137 0f8413000000
mov $0x1, %eax b801000000
test %cx, %cx 6685c9
jnz 0x15c 0f852a000000
jmp 0x15a e923000000
test %cx, %cx 6685c9
jnz 0x15a 0f851a000000
mov $0x0, -0xc(%rbp) c745f400000000
mov 0x1c(%r8), %ecx 418b481c
mov $0x1, %eax b801000000
cmp 0x20(%r9), %ecx 413b4920
jz 0x15c 0f8402000000
xor %eax, %eax 31c0
mov %eax, -0xc(%rbp) 8945f4
cmp $0x1, %eax 83f801
setnz %al 0f95c0
movzx %al, %eax 0fb6c0
or $0x2, %eax 83c802
mov %rbp, %rsp 4889ec
pop %rbp 5d
ret c3
Expression: ofSearchExpr_
Expr Len: 1064, Consts Len: 377
flags_ = 0000001110011000
Clause #1: ex_comp_clause
OperatorTypeEnum = ITM_EQUAL(2020), NumOperands = 3
ex_clause::flags_ = 0000000010000011
ex_comp_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 8, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 150
Text = =
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 4, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 111
Text = convert
Operand #2:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 4, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 149
Text = convert
Clause #2: ex_branch_clause
OperatorTypeEnum = ITM_AND(2001), NumOperands = 2
flags_ = 0000000010000000
PCODE = supported
branch to = #4
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 8, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
Clause #3: ex_comp_clause
OperatorTypeEnum = ITM_EQUAL(2020), NumOperands = 3
ex_clause::flags_ = 0000000010000011
ex_comp_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 12, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 152
Text = =
Operand #1:
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 10, NullIndOffset = 8, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 113
Text = convert
Operand #2:
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 10, NullIndOffset = 8, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 151
Text = convert
Clause #4: ex_bool_clause
OperatorTypeEnum = ITM_AND(2001), NumOperands = 3
ex_clause::flags_ = 0000000010000000
ex_bool_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 155
Text = and
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 8, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 150
Text = =
Operand #2:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 12, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 152
Text = =
Clause #5: ex_branch_clause
OperatorTypeEnum = ITM_AND(2001), NumOperands = 2
flags_ = 0000000010000000
PCODE = supported
branch to = #7
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
Clause #6: ex_comp_clause
OperatorTypeEnum = ITM_EQUAL(2020), NumOperands = 3
ex_clause::flags_ = 0000000010000011
ex_comp_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 16, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 154
Text = =
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 3
Offset = 32, NullIndOffset = 30, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 115
Text = convert
Operand #2:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 32, NullIndOffset = 30, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 153
Text = convert
Clause #7: ex_bool_clause
OperatorTypeEnum = ITM_AND(2001), NumOperands = 3
ex_clause::flags_ = 0000000010000000
ex_bool_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 156
Text = and
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 155
Text = and
Operand #2:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 16, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 154
Text = =
Clause #8: bool_result_clause
OperatorTypeEnum = ITM_BOOL_RESULT(2107), NumOperands = 1
ex_clause::flags_ = 0000000010000000
bool_result_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 157
Text = bool_result
PCode:
PCode Expr Length: 392
[1]
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S (304) 2 8 4 0
-1 5 0 -1 2020 12 (Tgt: 3)
[2]
BRANCH (95) 8 (Tgt: 4)
[3] (Preds: 1 )
EQ_MBIN32S_MBIN32S_MBIN32S (36) 2 8 4 4 5 4
[4] (Preds: 2 )
BRANCH_AND (168) 67 0 0 0 2 4 2 8 (Tgt: 13)
[5]
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S (304) 2 12 4 8
-1 5 8 -1 2020 12 (Tgt: 7)
[6]
BRANCH (95) 9 (Tgt: 8)
[7] (Preds: 5 )
EQ_MBIN32S_MASCII_MASCII (117) 2 12 4 10 5 10 20
[8] (Preds: 6 )
BRANCH_AND (168) 37 0 0 0 2 0 2 12 (Tgt: 13)
[9]
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S (304) 2 16 4 30
-1 5 30 -1 2020 12 (Tgt: 11)
[10]
BRANCH (95) 8 (Tgt: 12)
[11] (Preds: 9 )
EQ_MBIN32S_MBIN32S_MBIN32S (36) 2 16 4 32 5 32
[12] (Preds: 10 )
BRANCH_OR (169) 10 0 0 0 2 0 2 16 (Tgt: 14)
[13] (Preds: 4 8 )
RETURN_IBIN32S (265) 0
[14] (Preds: 12 )
RETURN_IBIN32S (265) 1
Native Expr (Length: 369 bytes)
push %rbp 55
mov %rsp, %rbp 4889e5
sub $0x10, %rsp 4883ec10
mov 0x30(%rdx), %rax 488b4230
mov 0x10(%rax), %r8 4c8b4010
movzx (%r8), %eax 410fb700
mov 0x38(%rsi), %rcx 488b4e38
mov 0x10(%rcx), %r9 4c8b4910
cmp $0x0, (%r9) 6641833900
jz 0x3a 0f8413000000
mov $0x1, %esi be01000000
test %ax, %ax 6685c0
jnz 0x5f 0f852a000000
jmp 0x5d e923000000
test %ax, %ax 6685c0
jnz 0x5d 0f851a000000
mov $0x0, -0x4(%rbp) c745fc00000000
mov 0x4(%r9), %eax 418b4104
mov $0x1, %esi be01000000
cmp 0x4(%r8), %eax 413b4004
jz 0x5f 0f8402000000
xor %esi, %esi 31f6
mov %esi, -0x4(%rbp) 8975fc
mov $0x3, %eax b803000000
test %esi, %esi 85f6
jz 0x16c 0f84fd000000
movzx 0x8(%r8), %ecx 410fb74808
cmp $0x0, 0x8(%r9) 664183790800
jz 0x93 0f8413000000
mov $0x1, %esi be01000000
test %cx, %cx 6685c9
jnz 0x109 0f857b000000
jmp 0x9c e909000000
test %cx, %cx 6685c9
jz 0xa3 0f8407000000
xor %esi, %esi 31f6
jmp 0x109 e966000000
mov $0x0, -0x8(%rbp) c745f800000000
mov %rsp, %rcx 4889e1
lea -0x10(%rcx), %rsi 488d71f0
mov %rsi, %rsp 4889f4
mov $0x0, -0x10(%rcx) 48c741f000000000
xor %edi, %edi 31ff
mov 0xa(%r9,%rdi), %rcx 498b4c390a
cmp 0xa(%r8,%rdi), %rcx 493b4c380a
jnz 0xdf 0f8511000000
add $0x8, %rdi 4883c708
mov %rdi, (%rsi) 48893e
cmp $0x10, %rdi 4883ff10
jb 0xbe 0f82dfffffff
mov 0xa(%r8,%rdi), %cl 418a4c380a
mov 0xa(%r9,%rdi), %dl 418a54390a
cmp %cl, %dl 38ca
jnz 0x101 0f8510000000
inc %rdi 48ffc7
mov %rdi, (%rsi) 48893e
cmp $0x14, %rdi 4883ff14
jb 0xdf 0f82deffffff
cmp %cl, %dl 38ca
setz %cl 0f94c1
movzx %cl, %esi 0fb6f1
mov %esi, -0x8(%rbp) 8975f8
test %esi, %esi 85f6
jz 0x16c 0f8458000000
movzx 0x1e(%r8), %ecx 410fb7481e
cmp $0x0, 0x1e(%r9) 664183791e00
jz 0x138 0f8413000000
mov $0x1, %eax b801000000
test %cx, %cx 6685c9
jnz 0x15d 0f852a000000
jmp 0x15b e923000000
test %cx, %cx 6685c9
jnz 0x15b 0f851a000000
mov $0x0, -0xc(%rbp) c745f400000000
mov 0x20(%r9), %ecx 418b4920
mov $0x1, %eax b801000000
cmp 0x20(%r8), %ecx 413b4820
jz 0x15d 0f8402000000
xor %eax, %eax 31c0
mov %eax, -0xc(%rbp) 8945f4
cmp $0x1, %eax 83f801
setnz %al 0f95c0
movzx %al, %eax 0fb6c0
or $0x2, %eax 83c802
mov %rbp, %rsp 4889ec
pop %rbp 5d
ret c3
Contents of EX_TRAF_SELECT [1]:
-------------------------------
For ComTdb :
Class Version = 1, Class Size = 584
InitialQueueSizeDown = 4, InitialQueueSizeUp = 4
queueResizeLimit = 9, queueResizeFactor = 4
queueSizeDown = 2048, queueSizeUp = 2048, numBuffers = 4, bufferSize =
1048648
estimatedRowUsed = 25, estimatedRowsAccessed = 0, expressionMode = 0
Flag = 0000000000001001
For ComTdbHbaseAccess :
accessType_ = SELECT_
accessDetail_ = EX_TRAF_SELECT
tableName_ = TRAFODION.SEABASE.T022
asciiTI_ = 4, convertTI_ = 2, rowIdTI_ = 3, returnedTI_ = 3
rowIdAsciiTI_ = 5, updateTI_ = 0, mergeInsertTI_ = 0
returnedFetchedTI_ = 0, returnedUpdatedTI_ = 0, mergeInsertRowIdTI_ = 0
hbaseTimestampTI_ = 0, hbaseVersionTI_ = 0
asciiRowLen_ = 44, convertRowLen_ = 52, rowIdLen_ = 8, outputRowLen_ = 52
updateRowLen_ = 0, returnFetchedRowLen_ = 0, returnUpdateedRowLen_ = 0
mergeInsertRowLen_ = 0, keyLen_ = 0
Flag = 0000000000000100
server_ = , zkPort_ =
listOfFetchedColNames_(numEntries = 4):
Entry #1: #1:1
Entry #2: #1:2
Entry #3: #1:3
Entry #4: #1:4
listOfScanRows_(numEntries = 1):
Entry #1:
beginRowId_(incl) =
0:
endRowId_(incl) =
0:
colTS_=-1
# of Expressions = 18
Expression: Convert Expr
Expr Len: 704, Consts Len: 8
flags_ = 0000000010001000
Clause #1: ex_function_clause
OperatorTypeEnum = ITM_HEADER(2375), NumOperands = 1
ex_clause::flags_ = 0000000010000000
ex_function_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BYTE_F_ASCII(0), Length = 16, Null Flag = 0
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
RelOffset = 0, VoaOffset = -1, NullBitIdx = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 0
Text = Hdr
Clause #2: ex_conv_clause
OperatorTypeEnum = ITM_CAST(2452), NumOperands = 2
ex_clause::flags_ = 0000000010000000
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN64_SIGNED(134), Length = 8, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001001
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 16, NullIndOffset = -1, VClenIndOffset = -1
RelOffset = 0, VoaOffset = -1, NullBitIdx = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 119
Text = cast
Operand #1:
Datatype = REC_BIN64_SIGNED(134), Length = 8, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 4
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 118
Text = LARGEINT SIGNED
Clause #3: ex_conv_clause
OperatorTypeEnum = ITM_CAST(2452), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 121
Text = cast
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 4
Offset = 12, NullIndOffset = 8, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 120
Text = INTEGER SIGNED
Clause #4: ex_function_clause
OperatorTypeEnum = ITM_COMP_DECODE(2175), NumOperands = 2
ex_clause::flags_ = 0000000010100110
ex_function_clause::flags_ = 0000000000000000
PCODE = not supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001001
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 24, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 8, VoaOffset = -1, NullBitIdx = 0
NullIndLength = 0, VClenIndLength = 0
ValueId = 122
Text = comp_decode
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 121
Text = cast
Clause #5: ex_conv_clause
OperatorTypeEnum = ITM_CAST(2452), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 32, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 16, VoaOffset = -1, NullBitIdx = 1
NullIndLength = 0, VClenIndLength = 0
ValueId = 124
Text = cast
Operand #1:
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 4
Offset = 18, NullIndOffset = 16, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 123
Text = CHAR(20) CHARACTER SET ISO88591
Clause #6: ex_conv_clause
OperatorTypeEnum = ITM_CAST(2452), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 12, NullIndOffset = 8, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 126
Text = cast
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 4
Offset = 40, NullIndOffset = 38, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 125
Text = INTEGER SIGNED
Clause #7: ex_function_clause
OperatorTypeEnum = ITM_COMP_DECODE(2175), NumOperands = 2
ex_clause::flags_ = 0000000010100110
ex_function_clause::flags_ = 0000000000000000
PCODE = not supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001001
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 28, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 12, VoaOffset = -1, NullBitIdx = 2
NullIndLength = 0, VClenIndLength = 0
ValueId = 127
Text = comp_decode
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 12, NullIndOffset = 8, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 126
Text = cast
PCode:
PCode Expr Length: 404
[1]
HDR_MPTR32_IBIN32S_IBIN32S_IBIN32S_IBIN32S_IBIN32S (303) 4 0 16 16 4 8 4
MOVE_MBIN64S_MBIN64S (203) 4 16 5 0
OPDATA_MPTR32_IBIN32S (0) 4 8 0
OPDATA_MBIN16U_IBIN32S (1) 5 8 1
OPDATA_MPTR32_IBIN32S (0) 4 24 10
OPDATA_MPTR32_IBIN32S (0) 5 12 11
CLAUSE_EVAL (108) 1448711376 32524 1
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S (248) 4 8 5 16 134218758
1 -1 34 (Tgt: 3)
[2]
FILL_MEM_BYTES (115) 4 32 20 0
OPDATA_MPTR32_IBIN32S (0) 4 8 0
OPDATA_MBIN16U_IBIN32S (1) 5 38 1
OPDATA_MPTR32_IBIN32S (0) 4 28 10
OPDATA_MPTR32_IBIN32S (0) 5 40 11
CLAUSE_EVAL (108) 1448713768 32524 1
RETURN (264)
[3] (Preds: 1 )
MOVE_MBIN8_MBIN8_IBIN32S (4) 4 32 5 18 20
OPDATA_MPTR32_IBIN32S (0) 4 8 0
OPDATA_MBIN16U_IBIN32S (1) 5 38 1
OPDATA_MPTR32_IBIN32S (0) 4 28 10
OPDATA_MPTR32_IBIN32S (0) 5 40 11
CLAUSE_EVAL (108) 1448713768 32524 1
RETURN (264)
Expression: ScanExpr is NULL
Expression: RowIdExpr
Expr Len: 384, Consts Len: 8
flags_ = 0000000010001000
Clause #1: ex_conv_clause
OperatorTypeEnum = ITM_CAST(2452), NumOperands = 2
ex_clause::flags_ = 0000000010000000
ex_conv_clause::flags_ = 0000000000010000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN64_SIGNED(134), Length = 8, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 129
Text = cast
Operand #1:
Datatype = REC_BYTE_V_ASCII(64), Length = 8, Null Flag = 0
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 5
Offset = 2, NullIndOffset = -1, VClenIndOffset = 0
NullIndLength = 0, VClenIndLength = 2
ValueId = 128
Text = VARCHAR(8) CHARACTER SET ISO88591
Clause #2: ex_function_clause
OperatorTypeEnum = ITM_COMP_ENCODE(2114), NumOperands = 2
ex_clause::flags_ = 0000000010000000
ex_function_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BYTE_F_ASCII(0), Length = 8, Null Flag = 0
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 3
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 130
Text = comp_encode
Operand #1:
Datatype = REC_BIN64_SIGNED(134), Length = 8, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 129
Text = cast
PCode:
PCode Expr Length: 88
[1]
CONVVCPTR_MBIN64S_MATTR5_IBIN32S (330) 2 0 5 2 -1 8 512 8
ENCODE_MASCII_MBIN64S_IBIN32S (91) 4 0 2 0 0
RETURN (264)
Expression: UpdateExpr is NULL
Expression: MergeInsertExpr is NULL
Expression: LowKeyExpr is NULL
Expression: HighKeyExpr is NULL
Expression: ReturnFetchExpr is NULL
Expression: ReturnUpdateExpr is NULL
Expression: ReturnMergeInsertExpr is NULL
Expression: mergeUpdScanExpr is NULL
Expression: mergeInsertRowIdExpr is NULL
Expression: encodedKeyExpr is NULL
Expression: keyColValExpr is NULL
Expression: hbaseFilterExpr is NULL
Expression: preCondExpr is NULL
Expression: insConstraintExpr is NULL
Expression: updConstraintExpr is NULL
Contents of EX_TRAF_KEY_ROWSET_SELECT [3]:
------------------------------------------
For ComTdb :
Class Version = 1, Class Size = 584
InitialQueueSizeDown = 2048, InitialQueueSizeUp = 2048
queueResizeLimit = 9, queueResizeFactor = 4
queueSizeDown = 2048, queueSizeUp = 2048, numBuffers = 4, bufferSize =
1048648
estimatedRowUsed = 1, estimatedRowsAccessed = 0, expressionMode = 0
Flag = 0000000000001001
For ComTdbHbaseAccess :
accessType_ = SELECT_
accessDetail_ = EX_TRAF_KEY_ROWSET_SELECT
tableName_ = TRAFODION.SEABASE.T021
asciiTI_ = 4, convertTI_ = 2, rowIdTI_ = 3, returnedTI_ = 3
rowIdAsciiTI_ = 5, updateTI_ = 0, mergeInsertTI_ = 0
returnedFetchedTI_ = 0, returnedUpdatedTI_ = 0, mergeInsertRowIdTI_ = 0
hbaseTimestampTI_ = 0, hbaseVersionTI_ = 0
asciiRowLen_ = 32, convertRowLen_ = 40, rowIdLen_ = 0, outputRowLen_ = 40
updateRowLen_ = 0, returnFetchedRowLen_ = 0, returnUpdateedRowLen_ = 0
mergeInsertRowLen_ = 0, keyLen_ = 4
Flag = 0000001010000100
server_ = , zkPort_ =
listOfFetchedColNames_(numEntries = 3):
Entry #1: #1:1
Entry #2: #1:2
Entry #3: #1:3
# of Expressions = 18
Expression: Convert Expr
Expr Len: 648, Consts Len: 8
flags_ = 0000000010001000
Clause #1: ex_function_clause
OperatorTypeEnum = ITM_HEADER(2375), NumOperands = 1
ex_clause::flags_ = 0000000010000000
ex_function_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BYTE_F_ASCII(0), Length = 12, Null Flag = 0
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
RelOffset = 0, VoaOffset = -1, NullBitIdx = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 0
Text = Hdr
Clause #2: ex_conv_clause
OperatorTypeEnum = ITM_CAST(2452), NumOperands = 2
ex_clause::flags_ = 0000000010000000
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 163
Text = cast
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 4
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 162
Text = INTEGER SIGNED
Clause #3: ex_function_clause
OperatorTypeEnum = ITM_COMP_DECODE(2175), NumOperands = 2
ex_clause::flags_ = 0000000010100000
ex_function_clause::flags_ = 0000000000000000
PCODE = not supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001001
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 12, NullIndOffset = -1, VClenIndOffset = -1
RelOffset = 0, VoaOffset = -1, NullBitIdx = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 164
Text = comp_decode
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 163
Text = cast
Clause #4: ex_conv_clause
OperatorTypeEnum = ITM_CAST(2452), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 20, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 8, VoaOffset = -1, NullBitIdx = 0
NullIndLength = 0, VClenIndLength = 0
ValueId = 166
Text = cast
Operand #1:
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 4
Offset = 6, NullIndOffset = 4, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 165
Text = CHAR(20) CHARACTER SET ISO88591
Clause #5: ex_conv_clause
OperatorTypeEnum = ITM_CAST(2452), NumOperands = 2
ex_clause::flags_ = 0000000010000110
ex_conv_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 8, NullIndOffset = 4, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 168
Text = cast
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 4
Offset = 28, NullIndOffset = 26, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 167
Text = INTEGER SIGNED
Clause #6: ex_function_clause
OperatorTypeEnum = ITM_COMP_DECODE(2175), NumOperands = 2
ex_clause::flags_ = 0000000010100110
ex_function_clause::flags_ = 0000000000000000
PCODE = not supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001001
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 16, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 4, VoaOffset = -1, NullBitIdx = 1
NullIndLength = 0, VClenIndLength = 0
ValueId = 169
Text = comp_decode
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 8, NullIndOffset = 4, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 168
Text = cast
PCode:
PCode Expr Length: 352
[1]
HDR_MPTR32_IBIN32S_IBIN32S_IBIN32S_IBIN32S_IBIN32S (303) 4 0 12 12 4 8 4
OPDATA_MPTR32_IBIN32S (0) 4 12 10
OPDATA_MPTR32_IBIN32S (0) 5 0 11
CLAUSE_EVAL (108) 1448757280 32524 0
NOT_NULL_BRANCH_MBIN32S_MBIN32S_IATTR3_IBIN32S (248) 4 8 5 4 134218758
0 -1 34 (Tgt: 3)
[2]
FILL_MEM_BYTES (115) 4 20 20 0
OPDATA_MPTR32_IBIN32S (0) 4 8 0
OPDATA_MBIN16U_IBIN32S (1) 5 26 1
OPDATA_MPTR32_IBIN32S (0) 4 16 10
OPDATA_MPTR32_IBIN32S (0) 5 28 11
CLAUSE_EVAL (108) 1448759672 32524 1
RETURN (264)
[3] (Preds: 1 )
MOVE_MBIN8_MBIN8_IBIN32S (4) 4 20 5 6 20
OPDATA_MPTR32_IBIN32S (0) 4 8 0
OPDATA_MBIN16U_IBIN32S (1) 5 26 1
OPDATA_MPTR32_IBIN32S (0) 4 16 10
OPDATA_MPTR32_IBIN32S (0) 5 28 11
CLAUSE_EVAL (108) 1448759672 32524 1
RETURN (264)
Expression: ScanExpr
Expr Len: 856, Consts Len: 284
flags_ = 0000001110011000
Clause #1: ex_comp_clause
OperatorTypeEnum = ITM_EQUAL(2020), NumOperands = 3
ex_clause::flags_ = 0000000010000011
ex_comp_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 107
Text = =
Operand #1:
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 20, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 8, VoaOffset = -1, NullBitIdx = 0
NullIndLength = 0, VClenIndLength = 0
ValueId = 6
Text = TRAFODION.SEABASE.T021.ENAME
Operand #2:
Datatype = REC_BYTE_F_ASCII(0), Length = 20, Null Flag = 1
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 2
Offset = 10, NullIndOffset = 8, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 15
Text = TRAFODION.SEABASE.T022.ENAME
Clause #2: ex_branch_clause
OperatorTypeEnum = ITM_AND(2001), NumOperands = 2
flags_ = 0000000010000000
PCODE = supported
branch to = #4
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
Clause #3: ex_comp_clause
OperatorTypeEnum = ITM_EQUAL(2020), NumOperands = 3
ex_clause::flags_ = 0000000010000011
ex_comp_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 8, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 108
Text = =
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000001
Tuple Data Format = SQLMX_ALIGNED_FORMAT
Atp = 1, AtpIndex = 2
Offset = 16, NullIndOffset = 8, VClenIndOffset = -1
RelOffset = 4, VoaOffset = -1, NullBitIdx = 1
NullIndLength = 0, VClenIndLength = 0
ValueId = 7
Text = TRAFODION.SEABASE.T021.DNO
Operand #2:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 2
Offset = 32, NullIndOffset = 30, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 16
Text = TRAFODION.SEABASE.T022.DNO
Clause #4: ex_bool_clause
OperatorTypeEnum = ITM_AND(2001), NumOperands = 3
ex_clause::flags_ = 0000000010000000
ex_bool_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 170
Text = and
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 4, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 107
Text = =
Operand #2:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 8, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 108
Text = =
Clause #5: bool_result_clause
OperatorTypeEnum = ITM_BOOL_RESULT(2107), NumOperands = 1
ex_clause::flags_ = 0000000010000000
bool_result_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 171
Text = bool_result
PCode:
PCode Expr Length: 276
[1]
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S (304) 2 4 5 8 0
4 8 -1 2020 12 (Tgt: 3)
[2]
BRANCH (95) 9 (Tgt: 4)
[3] (Preds: 1 )
EQ_MBIN32S_MASCII_MASCII (117) 2 4 5 20 4 10 20
[4] (Preds: 2 )
BRANCH_AND (168) 37 0 0 0 2 0 2 4 (Tgt: 9)
[5]
NNB_SPECIAL_NULLS_MBIN32S_MATTR3_MATTR3_IBIN32S_IBIN32S (304) 2 8 5 8 1
4 30 -1 2020 12 (Tgt: 7)
[6]
BRANCH (95) 8 (Tgt: 8)
[7] (Preds: 5 )
EQ_MBIN32S_MBIN32S_MBIN32S (36) 2 8 5 16 4 32
[8] (Preds: 6 )
BRANCH_OR (169) 10 0 0 0 2 0 2 8 (Tgt: 10)
[9] (Preds: 4 )
RETURN_IBIN32S (265) 0
[10] (Preds: 8 )
RETURN_IBIN32S (265) 1
Native Expr (Length: 276 bytes)
push %rbp 55
mov %rsp, %rbp 4889e5
sub $0x10, %rsp 4883ec10
mov 0x30(%rsi), %rax 488b4630
mov 0x10(%rax), %r8 4c8b4010
movzx 0x8(%r8), %eax 410fb74008
mov 0x30(%rdx), %rcx 488b4a30
mov 0x10(%rcx), %rdi 488b7910
cmp $0x0, 0x8(%rdi) 807f0800
js 0x9a 0f8873000000
test %ax, %ax 6685c0
jnz 0xa8 0f8578000000
mov $0x0, -0x4(%rbp) c745fc00000000
mov %rsp, %rcx 4889e1
lea -0x10(%rcx), %rax 488d41f0
mov %rax, %rsp 4889c4
mov $0x0, -0x10(%rcx) 48c741f000000000
xor %esi, %esi 31f6
mov 0x14(%rdi,%rsi), %rcx 488b4c3714
cmp 0xa(%r8,%rsi), %rcx 493b4c300a
jnz 0x6c 0f8511000000
add $0x8, %rsi 4883c608
mov %rsi, (%rax) 488930
cmp $0x10, %rsi 4883fe10
jb 0x4b 0f82dfffffff
mov 0xa(%r8,%rsi), %cl 418a4c300a
mov 0x14(%rdi,%rsi), %dl 8a543714
cmp %cl, %dl 38ca
jnz 0x8d 0f8510000000
inc %rsi 48ffc6
mov %rsi, (%rax) 488930
cmp $0x14, %rsi 4883fe14
jb 0x6c 0f82dfffffff
cmp %cl, %dl 38ca
setz %al 0f94c0
movzx %al, %esi 0fb6f0
jmp 0xaa e910000000
mov $0x1, %esi be01000000
test %ax, %ax 6685c0
jnz 0xaa 0f8502000000
xor %esi, %esi 31f6
mov %esi, -0x4(%rbp) 8975fc
mov $0x3, %eax b803000000
test %esi, %esi 85f6
jz 0x10f 0f8455000000
movzx 0x1e(%r8), %ecx 410fb7481e
test $0x40, 0x8(%rdi) f6470840
jz 0xdc 0f8413000000
mov $0x1, %eax b801000000
test %cx, %cx 6685c9
jnz 0x100 0f8529000000
jmp 0xfe e922000000
test %cx, %cx 6685c9
jnz 0xfe 0f8519000000
mov $0x0, -0x8(%rbp) c745f800000000
mov 0x10(%rdi), %ecx 8b4f10
mov $0x1, %eax b801000000
cmp 0x20(%r8), %ecx 413b4820
jz 0x100 0f8402000000
xor %eax, %eax 31c0
mov %eax, -0x8(%rbp) 8945f8
cmp $0x1, %eax 83f801
setnz %al 0f95c0
movzx %al, %eax 0fb6c0
or $0x2, %eax 83c802
mov %rbp, %rsp 4889ec
pop %rbp 5d
ret c3
Expression: RowIdExpr is NULL
Expression: UpdateExpr is NULL
Expression: MergeInsertExpr is NULL
Expression: LowKeyExpr
Expr Len: 440, Consts Len: 8
flags_ = 0000000010001000
Clause #1: ex_conv_clause
OperatorTypeEnum = ITM_NARROW(2350), NumOperands = 3
ex_clause::flags_ = 0000000010101010
ex_conv_clause::flags_ = 0000000000000000
PCODE = not supported
Operand #0 (result):
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 160
Text = narrow
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 1
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000000000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 2
Offset = 4, NullIndOffset = 0, VClenIndOffset = -1
NullIndLength = 2, VClenIndLength = 0
ValueId = 14
Text = TRAFODION.SEABASE.T022.ENO
Operand #2:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 1, AtpIndex = 4
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 117
Text = \:_sys_dataConversionErrorFlag
Clause #2: ex_function_clause
OperatorTypeEnum = ITM_COMP_ENCODE(2114), NumOperands = 2
ex_clause::flags_ = 0000000010000000
ex_function_clause::flags_ = 0000000000000000
PCODE = supported
Operand #0 (result):
Datatype = REC_BYTE_F_ASCII(0), Length = 4, Null Flag = 0
Precision = 0, Scale = 1, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLMX_KEY_FORMAT
Atp = 1, AtpIndex = 2
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 161
Text = comp_encode
Operand #1:
Datatype = REC_BIN32_SIGNED(132), Length = 4, Null Flag = 0
Precision = 0, Scale = 0, Collation = 1, flags_ = 0000001000001000
Tuple Data Format = SQLARK_EXPLODED_FORMAT
Atp = 0, AtpIndex = 1 (Temporary)
Offset = 0, NullIndOffset = -1, VClenIndOffset = -1
NullIndLength = 0, VClenIndLength = 0
ValueId = 160
Text = narrow
PCode:
PCode Expr Length: 140
[1]
OPDATA_MBIN16U_IBIN32S (1) 4 0 1
OPDATA_MPTR32_IBIN32S (0) 2 0 10
OPDATA_MPTR32_IBIN32S (0) 4 4 11
OPDATA_MPTR32_IBIN32S (0) 6 0 12
CLAUSE_EVAL (108) 1448752192 32524 1
ENCODE_MASCII_MBIN32S_IBIN32S (89) 5 0 2 0 0
RETURN (264)
Expression: HighKeyExpr is NULL
Expression: ReturnFetchExpr is NULL
Expression: ReturnUpdateExpr is NULL
Expression: ReturnMergeInsertExpr is NULL
Expression: mergeUpdScanExpr is NULL
Expression: mergeInsertRowIdExpr is NULL
Expression: encodedKeyExpr is NULL
Expression: keyColValExpr is NULL
Expression: hbaseFilterExpr is NULL
Expression: preCondExpr is NULL
Expression: insConstraintExpr is NULL
Expression: updConstraintExpr is NULL
--- SQL operation complete.
>>
> add SQL syntax support to INTERSECT
> -----------------------------------
>
> Key: TRAFODION-2047
> URL: https://issues.apache.org/jira/browse/TRAFODION-2047
> Project: Apache Trafodion
> Issue Type: New Feature
> Reporter: liu ming
> Assignee: liu ming
> Fix For: 2.1-incubating
>
>
> INTERSECT is a common SQL syntax.
> Trafodion should support it.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
