[
https://issues.apache.org/jira/browse/TRAFODION-790?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14714403#comment-14714403
]
Suresh Subbiah commented on TRAFODION-790:
------------------------------------------
Selvaganesan Govindarajan (selva-ganesan) wrote on 2015-05-23:
It looks like the plan is missing key expressions for the index delete.
The plan is ok when the object_uid is parameterized.
When the object_uid is given a value, both vsbb_delete and delete seems to have
problem.
Trafodion Conversational Interface 1.2.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>set parserflags 131072 ;
--- SQL operation complete.
>>prepare s1 from
>>update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH',
>>object_name = 'OBJECT1' where object_uid = ?
..
>>;
..
--- SQL command prepared.
>>explain options 'f' s1 ;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
8 . 9 root x 1.00E+000
6 7 8 nested_join 1.00E+000
. . 7 trafodion_insert OBJECTS_UNIQ_IDX 1.00E+000
4 5 6 nested_join 1.00E+000
. . 5 trafodion_insert OBJECTS 1.00E+000
3 . 4 sort 1.00E+000
1 2 3 nested_anti_semi_joi 1.00E+000
. . 2 trafodion_vsbb_delet OBJECTS_UNIQ_IDX 1.00E+000
. . 1 trafodion_delete OBJECTS 1.00E+000
--- SQL operation complete.
>>explain s1;
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... S1
PLAN_ID .................. 212299007795473919
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ update "_MD_".objects
set catalog_name = 'TRAFODION', schema_name = 'SCH',
object_name = 'OBJECT1'
where object_uid = ? ;
------------------------------------------------------------------ NODE LISTING
ROOT ====================================== SEQ_NO 9 ONLY CHILD 8
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est ........... 1
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
statement_index ........ 0
affinity_value ......... 0
max_max_cardinality .... 1
total_overflow_size .... 0.00 KB
upd_action_on_error .... xn_rollback
xn_access_mode ......... read_only
xn_autoabort_interval 0
auto_query_retry ....... enabled for privilege checks
plan_version ....... 2,600
embedded_arkcmp ........ used
self_referencing_update forced_sort
IS_SQLCI ............... ON
LDAP_USERNAME
input_variables ........ ?, %('TRAFODION'), %('SCH'), %('OBJECT1'),
%('TRAFODION'), %('SCH'), %('OBJECT1')
NESTED_JOIN =============================== SEQ_NO 8 CHILDREN 6, 7
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est ........... 1
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
join_type .............. inner
join_method ............ nested
TRAFODION_INSERT ========================== SEQ_NO 7 NO CHILDREN
TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
max_card_est ........... 1
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
iud_type ............... index_trafodion_insert TRAFODION."_MD_".OBJECTS_UNIQ
_IDX
new_rec_expr ........... (TRAFODION."_MD_".OBJECTS_UNIQ_IDX."OBJECT_UID@"
assign ?), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.CATA
LOG_NAME assign TRAFODION."_MD_".OBJECTS.CATALOG_N
AME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.SCHEMA_NA
ME assign TRAFODION."_MD_".OBJECTS.SCHEMA_NAME),
(TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_NAME
assign TRAFODION."_MD_".OBJECTS.OBJECT_NAME),
(TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_TYPE
assign TRAFODION."_MD_".OBJECTS.OBJECT_TYPE)
NESTED_JOIN =============================== SEQ_NO 6 CHILDREN 4, 5
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est ........... 1
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
join_type .............. inner
join_method ............ in-order nested
TRAFODION_INSERT ========================== SEQ_NO 5 NO CHILDREN
TABLE_NAME ............... TRAFODION._MD_.OBJECTS
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
max_card_est ........... 1
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
iud_type ............... trafodion_insert TRAFODION._MD_.OBJECTS (implements
update of clustering key or unique index key)
new_rec_expr ........... (TRAFODION."_MD_".OBJECTS.CATALOG_NAME assign
%('TRAFODION')), (TRAFODION."_MD_".OBJECTS.SCHEMA_
NAME assign %('SCH')), (TRAFODION."_MD_".OBJECTS.O
BJECT_NAME assign %('OBJECT1')),
(TRAFODION."_MD_".OBJECTS.OBJECT_TYPE assign
TRAFODION."_MD_".OBJECTS.OBJECT_TYPE),
(TRAFODION."_MD_".OBJECTS.OBJECT_UID assign ?),
(TRAFODION."_MD_".OBJECTS.CREATE_TIME assign
TRAFODION."_MD_".OBJECTS.CREATE_TIME),
(TRAFODION."_MD_".OBJECTS.REDEF_TIME assign
TRAFODION."_MD_".OBJECTS.REDEF_TIME),
(TRAFODION."_MD_".OBJECTS.VALID_DEF assign
TRAFODION."_MD_".OBJECTS.VALID_DEF),
(TRAFODION."_MD_".OBJECTS.DROPPABLE assign
TRAFODION."_MD_".OBJECTS.DROPPABLE),
(TRAFODION."_MD_".OBJECTS.OBJECT_OWNER assign
TRAFODION."_MD_".OBJECTS.OBJECT_OWNER),
(TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER assign
TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER),
(TRAFODION."_MD_".OBJECTS.FLAGS assign
TRAFODION."_MD_".OBJECTS.FLAGS)
SORT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
memory_quota ........... 0 MB
max_card_est ........... 1
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
sort_type .............. full
self_referencing_update forced_sort
sort_key ............... TRAFODION."_MD_".OBJECTS.OBJECT_TYPE
NESTED_ANTI_SEMI_JOIN ===================== SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est ........... 1
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
join_type .............. inner anti-semi
join_method ............ nested
TRAFODION_VSBB_DELETE ===================== SEQ_NO 2 NO CHILDREN
TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
max_card_est ........... 1
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
iud_type ............... index_trafodion_vsbb_delete
TRAFODION."_MD_".OBJECTS_UNIQ_IDX
begin_key .............. (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_UID@ = ?)
end_key ................ (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_UID@ = ?)
TRAFODION_DELETE ========================== SEQ_NO 1 NO CHILDREN
TABLE_NAME ............... TRAFODION._MD_.OBJECTS
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
max_card_est ........... 1
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
iud_type ............... trafodion_delete TRAFODION._MD_.OBJECTS (implements
update of clustering key or unique index key)
columns ................ all
begin_keys(incl)
end_keys(incl)
predicate .............. (cast((cast(TRAFODION."_MD_".OBJECTS.OBJECT_UID) *
cast(1000000))) = cast(?))
--- SQL operation complete.
>>fc pre
>>prepare s1 from
..
>>update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH',
>>object_name = 'OBJECT1' where object_uid = ?
..
12344
>>update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH',
>>object_name = 'OBJECT1' where object_uid = 12344
..
>>;
..
--- SQL command prepared.
>>cqd query_cache '0' ;
--- SQL operation complete.
>>fc pre
>>prepare s1 from
..
>>update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH',
>>object_name = 'OBJECT1' where object_uid = 12344
..
>>;
..
--- SQL command prepared.
>>explain options 'f' s1 ;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
8 . 9 root x 1.00E+001
6 7 8 nested_join 1.00E+001
. . 7 trafodion_insert OBJECTS_UNIQ_IDX 1.00E+000
4 5 6 nested_join 1.00E+001
. . 5 trafodion_insert OBJECTS 1.00E+000
3 . 4 sort 1.00E+001
1 2 3 nested_anti_semi_joi 1.00E+001
. . 2 trafodion_vsbb_delet OBJECTS_UNIQ_IDX 1.00E+000
. . 1 trafodion_delete OBJECTS 1.00E+001
--- SQL operation complete.
>>fc expl
>>explain options 'f' s1 ;
.. ddddddddddd
>>explain s1 ;
..
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... S1
PLAN_ID .................. 212299010512379427
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ update "_MD_".objects
set catalog_name = 'TRAFODION', schema_name = 'SCH',
object_name = 'OBJECT1'
where object_uid = 12344 ;
------------------------------------------------------------------ NODE LISTING
ROOT ====================================== SEQ_NO 9 ONLY CHILD 8
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
statement_index ........ 0
affinity_value ......... 0
max_max_cardinality ... 10
total_overflow_size .... 0.00 KB
upd_action_on_error .... xn_rollback
xn_access_mode ......... read_only
xn_autoabort_interval 0
auto_query_retry ....... enabled for privilege checks
plan_version ....... 2,600
embedded_arkcmp ........ used
self_referencing_update forced_sort
IS_SQLCI ............... ON
LDAP_USERNAME
QUERY_CACHE ............ 0
NESTED_JOIN =============================== SEQ_NO 8 CHILDREN 6, 7
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
join_type .............. inner
join_method ............ nested
TRAFODION_INSERT ========================== SEQ_NO 7 NO CHILDREN
TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
iud_type ............... index_trafodion_insert TRAFODION."_MD_".OBJECTS_UNIQ
_IDX
new_rec_expr ........... (TRAFODION."_MD_".OBJECTS_UNIQ_IDX."OBJECT_UID@"
assign 12344), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.
CATALOG_NAME assign TRAFODION."_MD_".OBJECTS.CATAL
OG_NAME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.SCHEM
A_NAME assign TRAFODION."_MD_".OBJECTS.SCHEMA_NAME
), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_NAME
assign TRAFODION."_MD_".OBJECTS.OBJECT_NAME),
(TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_TYPE
assign TRAFODION."_MD_".OBJECTS.OBJECT_TYPE)
NESTED_JOIN =============================== SEQ_NO 6 CHILDREN 4, 5
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
join_type .............. inner
join_method ............ in-order nested
TRAFODION_INSERT ========================== SEQ_NO 5 NO CHILDREN
TABLE_NAME ............... TRAFODION._MD_.OBJECTS
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
iud_type ............... trafodion_insert TRAFODION._MD_.OBJECTS (implements
update of clustering key or unique index key)
new_rec_expr ........... (TRAFODION."_MD_".OBJECTS.CATALOG_NAME assign
'TRAFODION'), (TRAFODION."_MD_".OBJECTS.SCHEMA_NAM
E assign 'SCH'), (TRAFODION."_MD_".OBJECTS.OBJECT_
NAME assign 'OBJECT1'),
(TRAFODION."_MD_".OBJECTS.OBJECT_TYPE assign
TRAFODION."_MD_".OBJECTS.OBJECT_TYPE),
(TRAFODION."_MD_".OBJECTS.OBJECT_UID assign
12344), (TRAFODION."_MD_".OBJECTS.CREATE_TIME
assign TRAFODION."_MD_".OBJECTS.CREATE_TIME),
(TRAFODION."_MD_".OBJECTS.REDEF_TIME assign
TRAFODION."_MD_".OBJECTS.REDEF_TIME),
(TRAFODION."_MD_".OBJECTS.VALID_DEF assign
TRAFODION."_MD_".OBJECTS.VALID_DEF),
(TRAFODION."_MD_".OBJECTS.DROPPABLE assign
TRAFODION."_MD_".OBJECTS.DROPPABLE),
(TRAFODION."_MD_".OBJECTS.OBJECT_OWNER assign
TRAFODION."_MD_".OBJECTS.OBJECT_OWNER),
(TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER assign
TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER),
(TRAFODION."_MD_".OBJECTS.FLAGS assign
TRAFODION."_MD_".OBJECTS.FLAGS)
SORT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
memory_quota ........... 0 MB
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
sort_type .............. full
self_referencing_update forced_sort
sort_key ............... TRAFODION."_MD_".OBJECTS.OBJECT_TYPE
NESTED_ANTI_SEMI_JOIN ===================== SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
join_type .............. inner anti-semi
join_method ............ nested
TRAFODION_VSBB_DELETE ===================== SEQ_NO 2 NO CHILDREN
TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
iud_type ............... index_trafodion_vsbb_delete
TRAFODION."_MD_".OBJECTS_UNIQ_IDX
columns ................ all
unique_rows ....... 12,344
TRAFODION_DELETE ========================== SEQ_NO 1 NO CHILDREN
TABLE_NAME ............... TRAFODION._MD_.OBJECTS
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
iud_type ............... trafodion_delete TRAFODION._MD_.OBJECTS (implements
update of clustering key or unique index key)
columns ................ all
begin_keys(incl)
end_keys(incl)
predicate .............. (TRAFODION."_MD_".OBJECTS.OBJECT_UID = cast(12344))
--- SQL operation complete.
>>cqd hbase_rowset_vsbb_opt 'off' ;
--- SQL operation complete.
>>fc pre
>>prepare s1 from
..
>>update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH',
>>object_name = 'OBJECT1' where object_uid = 12344
..
>>;
..
--- SQL command prepared.
>>
>>fc expl
>>explain s1 ;
..
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... S1
PLAN_ID .................. 212299010813162386
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ update "_MD_".objects
set catalog_name = 'TRAFODION', schema_name = 'SCH',
object_name = 'OBJECT1'
where object_uid = 12344 ;
------------------------------------------------------------------ NODE LISTING
ROOT ====================================== SEQ_NO 9 ONLY CHILD 8
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
statement_index ........ 0
affinity_value ......... 0
max_max_cardinality ... 10
total_overflow_size .... 0.00 KB
upd_action_on_error .... xn_rollback
xn_access_mode ......... read_only
xn_autoabort_interval 0
auto_query_retry ....... enabled for privilege checks
plan_version ....... 2,600
embedded_arkcmp ........ used
self_referencing_update forced_sort
IS_SQLCI ............... ON
LDAP_USERNAME
QUERY_CACHE ............ 0
HBASE_ROWSET_VSBB_OPT OFF
NESTED_JOIN =============================== SEQ_NO 8 CHILDREN 6, 7
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
join_type .............. inner
join_method ............ nested
TRAFODION_INSERT ========================== SEQ_NO 7 NO CHILDREN
TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
iud_type ............... index_trafodion_insert TRAFODION."_MD_".OBJECTS_UNIQ
_IDX
new_rec_expr ........... (TRAFODION."_MD_".OBJECTS_UNIQ_IDX."OBJECT_UID@"
assign 12344), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.
CATALOG_NAME assign TRAFODION."_MD_".OBJECTS.CATAL
OG_NAME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.SCHEM
A_NAME assign TRAFODION."_MD_".OBJECTS.SCHEMA_NAME
), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_NAME
assign TRAFODION."_MD_".OBJECTS.OBJECT_NAME),
(TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_TYPE
assign TRAFODION."_MD_".OBJECTS.OBJECT_TYPE)
NESTED_JOIN =============================== SEQ_NO 6 CHILDREN 4, 5
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
join_type .............. inner
join_method ............ in-order nested
TRAFODION_INSERT ========================== SEQ_NO 5 NO CHILDREN
TABLE_NAME ............... TRAFODION._MD_.OBJECTS
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
iud_type ............... trafodion_insert TRAFODION._MD_.OBJECTS (implements
update of clustering key or unique index key)
new_rec_expr ........... (TRAFODION."_MD_".OBJECTS.CATALOG_NAME assign
'TRAFODION'), (TRAFODION."_MD_".OBJECTS.SCHEMA_NAM
E assign 'SCH'), (TRAFODION."_MD_".OBJECTS.OBJECT_
NAME assign 'OBJECT1'),
(TRAFODION."_MD_".OBJECTS.OBJECT_TYPE assign
TRAFODION."_MD_".OBJECTS.OBJECT_TYPE),
(TRAFODION."_MD_".OBJECTS.OBJECT_UID assign
12344), (TRAFODION."_MD_".OBJECTS.CREATE_TIME
assign TRAFODION."_MD_".OBJECTS.CREATE_TIME),
(TRAFODION."_MD_".OBJECTS.REDEF_TIME assign
TRAFODION."_MD_".OBJECTS.REDEF_TIME),
(TRAFODION."_MD_".OBJECTS.VALID_DEF assign
TRAFODION."_MD_".OBJECTS.VALID_DEF),
(TRAFODION."_MD_".OBJECTS.DROPPABLE assign
TRAFODION."_MD_".OBJECTS.DROPPABLE),
(TRAFODION."_MD_".OBJECTS.OBJECT_OWNER assign
TRAFODION."_MD_".OBJECTS.OBJECT_OWNER),
(TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER assign
TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER),
(TRAFODION."_MD_".OBJECTS.FLAGS assign
TRAFODION."_MD_".OBJECTS.FLAGS)
SORT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
memory_quota ........... 0 MB
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
sort_type .............. full
self_referencing_update forced_sort
sort_key ............... TRAFODION."_MD_".OBJECTS.OBJECT_TYPE
NESTED_ANTI_SEMI_JOIN ===================== SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
join_type .............. inner anti-semi
join_method ............ nested
TRAFODION_DELETE ========================== SEQ_NO 2 NO CHILDREN
TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
iud_type ............... index_trafodion_delete TRAFODION."_MD_".OBJECTS_UNIQ
_IDX
columns ................ all
unique_rows ....... 12,344
TRAFODION_DELETE ========================== SEQ_NO 1 NO CHILDREN
TABLE_NAME ............... TRAFODION._MD_.OBJECTS
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
max_card_est .......... 10
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
iud_type ............... trafodion_delete TRAFODION._MD_.OBJECTS (implements
update of clustering key or unique index key)
columns ................ all
begin_keys(incl)
end_keys(incl)
predicate .............. (TRAFODION."_MD_".OBJECTS.OBJECT_UID = cast(12344))
--- SQL operation complete.
>>log e
Changed in trafodion:
assignee: Selvaganesan Govindarajan (selva-ganesan) → Suresh Subbiah
(suresh-subbiah)
> LP Bug: 1395840 - Alter rename cores mxosrvr at
> ExHbaseAccessTcb::setupUniqueKeyAndCols()
> -----------------------------------------------------------------------------------------
>
> Key: TRAFODION-790
> URL: https://issues.apache.org/jira/browse/TRAFODION-790
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Weishiun Tsai
> Assignee: Suresh Subbiah
> Priority: Blocker
> Fix For: 2.0-incubating
>
>
> This core was seen several times when running the following sequence of
> commands. This problem can’t always be reproduced, but when it occurred, it
> always happened with the same statement and the cores all showed the same
> stack.
> This is seen on the v1119_0830 build installed on a 4-node cluster. It is a
> regression introduced between the v1108_0830 build and the v1119_0830 build.
> ------------------------------------------------------------------------------------------------------------------
> Here is the stack of the core files:
> #0 0x00007ffff527f8a5 in raise () from /lib64/libc.so.6
> #1 0x00007ffff528100d in abort () from /lib64/libc.so.6
> #2 0x00007ffff6388a55 in os::abort(bool) ()
> from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
> #3 0x00007ffff6508f87 in VMError::report_and_die() ()
> from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
> #4 0x00007ffff638d96f in JVM_handle_linux_signal ()
> from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
> #5 <signal handler called>
> #6 0x00007ffff3743a61 in ExHbaseAccessTcb::setupUniqueKeyAndCols (
> this=0x7fffce17ac50, doInit=0) at ../executor/ExHbaseAccess.cpp:1682
> #7 0x00007ffff374ee5b in ExHbaseAccessSQRowsetTcb::work (this=0x7fffce17ac50)
> at ../executor/ExHbaseIUD.cpp:3759
> #8 0x00007ffff37613c3 in ExScheduler::work (this=0x7fffce179758,
> prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
> #9 0x00007ffff36d3542 in ex_root_tcb::execute (this=0x7fffce17ebd8,
> cliGlobals=0xf40b30, glob=0x7fffd029e780, input_desc=0x7fffd16bb090,
> diagsArea=@0x7fffe4646a00, reExecute=0) at ../executor/ex_root.cpp:1029
> #10 0x00007ffff49c991c in CliStatement::execute (this=0x7fffce1bca38,
> cliGlobals=0xf40b30, input_desc=0x7fffd16bb090,
> diagsArea=<value optimized out>, execute_state=<value optimized out>,
> fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4779
> #11 0x00007ffff498c22a in SQLCLI_PerformTasks(CliGlobals *, ULng32,
> SQLSTMT_ID *
> , SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, typedef __va_list_tag
> __va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *)
> (cliGlobals=0xf40b30, tasks=4882,
> statement_id=0x7fffcf38fe90, input_descriptor=0x7fffcf38ff00,
> output_descriptor=0x0, num_input_ptr_pairs=0, num_output_ptr_pairs=0,
> ap=0x7fffe4646ba0, input_ptr_pairs=0x0, output_ptr_pairs=0x0)
> at ../cli/Cli.cpp:3278
> #12 0x00007ffff498cf52 in SQLCLI_Exec(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID
> *, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *) (
> cliGlobals=<value optimized out>, statement_id=<value optimized out>,
> input_descriptor=<value optimized out>,
> num_ptr_pairs=<value optimized out>, ap=<value optimized out>,
> ptr_pairs=<value optimized out>) at ../cli/Cli.cpp:3525
> #13 0x00007ffff49d5ca5 in SQL_EXEC_Exec (statement_id=0x7fffcf38fe90,
> input_descriptor=0x7fffcf38ff00, num_ptr_pairs=0)
> at ../cli/CliExtern.cpp:2062
> #14 0x00007ffff3710bd1 in ExeCliInterface::exec (this=0x7fffe4648fc0,
> inputBuf=<value optimized out>, inputBufLen=<value optimized out>)
> at ../executor/ExExeUtilCli.cpp:599
> #15 0x00007ffff37144c5 in ExeCliInterface::executeImmediateExec (
> this=0x7fffe4648fc0, stmtStr=<value optimized out>, outputBuf=0x0,
> outputBufLen=0x0, nullTerminate=1, rowsAffected=0x0)
> at ../executor/ExExeUtilCli.cpp:898
> #16 0x00007ffff371744c in ExeCliInterface::executeImmediate (
> this=0x7fffe4648fc0,
> stmtStr=0x7fffe4646e00 "update TRAFODION.\"_MD_\".OBJECTS set
> catalog_name = 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21',
> object_name = 'TAB_EMP_NEW_01' where object_uid = 103071044763640121 ",
> outputBuf=0x0, outputBufLen=0x0,
> nullTerminate=1, rowsAffected=0x0, monitorThis=0, globalDiags=0x0)
> at ../executor/ExExeUtilCli.cpp:993
> #17 0x00007ffff01b9264 in CmpSeabaseDDL::updateObjectName (
> this=0x7fffe464ae30, cliInterface=0x7fffe4648fc0,
> objUID=103071044763640121, catName=0x7fffe4649848 "TRAFODION",
> schName=<value optimized out>, objName=<value optimized out>)
> at ../sqlcomp/CmpSeabaseDDLcommon.cpp:3636
> #18 0x00007ffff01e9a1f in CmpSeabaseDDL::renameSeabaseTable (
> this=0x7fffe464ae30, renameTableNode=0x7fffe46488c0,
> currCatName=<value optimized out>, currSchName=<value optimized out>)
> at ../sqlcomp/CmpSeabaseDDLtable.cpp:2631
> #19 0x00007ffff01daade in CmpSeabaseDDL::executeSeabaseDDL (
> this=0x7fffe464ae30, ddlExpr=0x7fffd199c520, ddlNode=0x7fffd199c338,
> currCatName=..., currSchName=...)
> at ../sqlcomp/CmpSeabaseDDLcommon.cpp:5696
> #20 0x00007fffedfb240a in CmpStatement::process (this=<value optimized out>,
> statement=<value optimized out>) at ../arkcmp/CmpStatement.cpp:911
> #21 0x00007fffedfa82d8 in CmpContext::compileDirect (this=0x7fffe25dd090,
> data=0x7fffd01abef8 "\200", data_len=224, outHeap=0x7fffe3be60f0,
> charset=15, op=CmpMessageObj::PROCESSDDL, gen_code=@0x7fffe464b6f0,
> gen_code_len=@0x7fffe464b6fc, parserFlags=4194304,
> diagsArea=0x7fffd01abfe0) at ../arkcmp/CmpContext.cpp:718
> #22 0x00007ffff36954f0 in ExDDLTcb::work (this=0x7fffe316d0a8)
> at ../executor/ex_ddl.cpp:265
> #23 0x00007ffff37613c3 in ExScheduler::work (this=0x7fffe316cc10,
> prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
> #24 0x00007ffff36d3542 in ex_root_tcb::execute (this=0x7fffe316d680,
> cliGlobals=0xf40b30, glob=0x7fffd01ab8c0, input_desc=0x7fffe3180a40,
> diagsArea=@0x7fffe464ce10, reExecute=0) at ../executor/ex_root.cpp:1029
> #25 0x00007ffff49c991c in CliStatement::execute (this=0x7fffd16ecd08,
> cliGlobals=0xf40b30, input_desc=0x7fffe3180a40,
> diagsArea=<value optimized out>, execute_state=<value optimized out>,
> fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4779
> #26 0x00007ffff498c22a in SQLCLI_PerformTasks(CliGlobals *, ULng32,
> SQLSTMT_ID *, SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, typedef __va_list_tag
> __va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *)
> (cliGlobals=0xf40b30, tasks=8063,
> statement_id=0x2deb558, input_descriptor=0x2deb588, output_descriptor=0x0,
> num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffe464cfb0,
> input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3278
> #27 0x00007ffff49d4f55 in SQL_EXEC_ClearExecFetchClose (
> statement_id=0x2deb558, input_descriptor=0x2deb588, output_descriptor=0x0,
> num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0)
> at ../cli/CliExtern.cpp:2618
> #28 0x00007ffff6e79b0f in SRVR::WSQL_EXEC_ClearExecFetchClose (
> statement_id=0x2deb558, input_descriptor=<value optimized out>,
> output_descriptor=<value optimized out>,
> num_input_ptr_pairs=<value optimized out>,
> num_output_ptr_pairs=<value optimized out>,
> num_total_ptr_pairs=<value optimized out>) at SQLWrapper.cpp:459
> #29 0x00007ffff6e7044f in SRVR::EXECUTE2 (pSrvrStmt=0x2deaf40)
> at sqlinterface.cpp:5521
> #30 0x00007ffff6ea0a45 in odbc_SQLSvc_Execute2_sme_ (
> objtag_=<value optimized out>, call_id_=<value optimized out>,
> dialogueId=<value optimized out>, sqlAsyncEnable=<value optimized out>,
> queryTimeout=<value optimized out>, inputRowCnt=<value optimized out>,
> sqlStmtType=0, stmtHandle=48148288, cursorLength=0, cursorName=0x0,
> cursorCharset=1, holdableCursor=0, inValuesLength=0, inValues=0x0,
> returnCode=0x7fffe464d8a8, sqlWarningOrErrorLength=0x7fffe464d8a4,
> sqlWarningOrError=@0x7fffe464d880, rowsAffected=0x7fffe464d8a0,
> outValuesLength=0x7fffe464d894, outValues=@0x7fffe464d878)
> at srvrothers.cpp:1514
> #31 0x00000000004d2685 in odbc_SQLSrvr_ExecDirect_ame_ (objtag_=0x31c8ce0,
> call_id_=0x31c8d38, dialogueId=1676333437,
> stmtLabel=<value optimized out>, cursorName=0x0,
> stmtExplainLabel=<value optimized out>, stmtType=0, sqlStmtType=0,
> sqlString=0x379d794 "alter table tab_emp_original_01 rename to
> tab_emp_new_01", sqlAsyncEnable=0, queryTimeout=0, inputRowCnt=0, txnID=0,
> holdableCursor=0)
> at SrvrConnect.cpp:7018
> #32 0x00000000004a1a36 in SQLEXECUTE_IOMessage (objtag_=0x31c8ce0,
> call_id_=0x31c8d38, operation_id=3012) at Interface/odbcs_srvr.cpp:1734
> #33 0x00000000004a1ae4 in DISPATCH_TCPIPRequest (objtag_=0x31c8ce0,
> call_id_=0x31c8d38, operation_id=<value optimized out>)
> at Interface/odbcs_srvr.cpp:1799
> #34 0x0000000000432a02 in BUILD_TCPIP_REQUEST (pnode=0x31c8ce0)
> at ../Common/TCPIPSystemSrvr.cpp:603
> #35 0x000000000043339d in PROCESS_TCPIP_REQUEST (pnode=0x31c8ce0)
> at ../Common/TCPIPSystemSrvr.cpp:581
> #36 0x0000000000470ad6 in CNSKListenerSrvr::tcpip_listener (arg=0xde0f40)
> at Interface/linux/Listener_srvr_ps.cpp:397
> #37 0x00007ffff50329f0 in sb_thread_sthr_disp (pp_arg=0xf13020)
> at threadl.cpp:253
> #38 0x00007ffff4bf9851 in start_thread () from /lib64/libpthread.so.0
> #39 0x00007ffff533590d in clone () from /lib64/libc.so.6
> ------------------------------------------------------------------------------------------------------------------
> Here is the execution output from trafci. The last ‘alter table
> tab_emp_original_01 rename to tab_emp_new_01;’ statement cored mxosrvr and
> caused trafci to lose its connection whenever the problem was seen:
> SQL>drop schema trafodion.alter_rename_rename21 cascade;
> --- SQL operation complete.
> SQL>create schema trafodion.alter_rename_rename21;
> --- SQL operation complete.
> SQL>set schema trafodion.alter_rename_rename21;
> --- SQL operation complete.
> SQL>set nametype ansi;
> --- SQL operation complete.
> SQL>create table tab_emp_original_01
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_emp_original_02
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_ten_original_03
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_ten_original_04
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_lrg_original_05
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_lrg_original_06
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>insert into tab_ten_original_03 values
> (1,'ABCDEFGH',1001,1001,11,'IJKLMNOPQRSTUVWX','YZABCDEF',1001,11,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (2,'ABCDEFGH',1002,1002,12,'IJKLMNOPQRSTUVWX','YZABCDEF',1002,12,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (3,'ABCDEFGH',1003,1003,13,'IJKLMNOPQRSTUVWX','YZABCDEF',1003,13,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (4,'ABCDEFGH',1004,1004,14,'IJKLMNOPQRSTUVWX','YZABCDEF',1004,14,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (5,'ABCDEFGH',1005,1005,15,'IJKLMNOPQRSTUVWX','YZABCDEF',1005,15,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (6,'ABCDEFGH',1006,1006,16,'IJKLMNOPQRSTUVWX','YZABCDEF',1006,16,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (7,'ABCDEFGH',1007,1007,17,'IJKLMNOPQRSTUVWX','YZABCDEF',1007,17,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (8,'ABCDEFGH',1008,1008,18,'IJKLMNOPQRSTUVWX','YZABCDEF',1008,18,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (9,'ABCDEFGH',1009,1009,19,'IJKLMNOPQRSTUVWX','YZABCDEF',1009,19,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (10,'ABCDEFGH',1010,1010,20,'IJKLMNOPQRSTUVWX','YZABCDEF',1010,20,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (1,'ABCDEFGH',1001,1001,11,'IJKLMNOPQRSTUVWX','YZABCDEF',1001,11,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (2,'ABCDEFGH',1002,1002,12,'IJKLMNOPQRSTUVWX','YZABCDEF',1002,12,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (3,'ABCDEFGH',1003,1003,13,'IJKLMNOPQRSTUVWX','YZABCDEF',1003,13,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (4,'ABCDEFGH',1004,1004,14,'IJKLMNOPQRSTUVWX','YZABCDEF',1004,14,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (5,'ABCDEFGH',1005,1005,15,'IJKLMNOPQRSTUVWX','YZABCDEF',1005,15,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (6,'ABCDEFGH',1006,1006,16,'IJKLMNOPQRSTUVWX','YZABCDEF',1006,16,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (7,'ABCDEFGH',1007,1007,17,'IJKLMNOPQRSTUVWX','YZABCDEF',1007,17,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (8,'ABCDEFGH',1008,1008,18,'IJKLMNOPQRSTUVWX','YZABCDEF',1008,18,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (9,'ABCDEFGH',1009,1009,19,'IJKLMNOPQRSTUVWX','YZABCDEF',1009,19,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (10,'ABCDEFGH',1010,1010,20,'IJKLMNOPQRSTUVWX','YZABCDEF',1010,20,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>upsert using load into
> trafodion.alter_rename_rename21.tab_lrg_original_05 select * from
> trafodion.g_cmureg.btpnl17a;
> --- SQL operation complete.
> SQL>select count(*) from tab_lrg_original_05;
> (EXPR)
> --------------------
> 2000
> --- 1 row(s) selected.
> SQL>update statistics for table tab_lrg_original_05 on every column;
> --- SQL operation complete.
> SQL>upsert using load into
> trafodion.alter_rename_rename21.tab_lrg_original_06 select * from
> trafodion.g_cmureg.btpnl17a;
> --- SQL operation complete.
> SQL>select count(*) from tab_lrg_original_06;
> (EXPR)
> --------------------
> 2000
> --- 1 row(s) selected.
> SQL>update statistics for table tab_lrg_original_06 on every column;
> --- SQL operation complete.
> -------------------------------------------------------------------------------
> == TEST: tcase.test001
> -------------------------------------------------------------------------------
> SQL>select * from tab_emp_original_01;
> --- 0 row(s) selected.
> SQL>showddl tab_emp_original_01;
> CREATE TABLE TRAFODION.ALTER_RENAME_RENAME21.TAB_EMP_ORIGINAL_01
> (
> SBIN0_10 NUMERIC(18, 0) DEFAULT NULL
> , CHAR0_2 CHAR(8) CHARACTER SET ISO88591 COLLATE
> DEFAULT DEFAULT NULL
> , UDEC0_UNIQ DECIMAL(9, 0) UNSIGNED DEFAULT NULL
> , UBIN0_UNIQ NUMERIC(9, 0) UNSIGNED DEFAULT NULL
> , SDEC0_500 DECIMAL(9, 0) DEFAULT NULL
> , VARCHAR0_10 VARCHAR(16) CHARACTER SET ISO88591
> COLLATE
> DEFAULT DEFAULT NULL
> , VARCHAR1_20 VARCHAR(8) CHARACTER SET ISO88591 COLLATE
> DEFAULT DEFAULT NULL
> , SBIN1_5000 NUMERIC(4, 0) DEFAULT NULL
> , SDEC1_4 DECIMAL(18, 0) DEFAULT NULL
> , CHAR1_4 CHAR(8) CHARACTER SET ISO88591 COLLATE
> DEFAULT DEFAULT NULL
> )
> ;
> --- SQL operation complete.
> SQL>alter table tab_emp_original_01 rename to tab_emp_new_01;
> *** ERROR[1] The message id: problem_with_server_read
> *** ERROR[1] The message id: header_not_long_enough
> *** ERROR[1] The message id: problem_with_server_read
> *** ERROR[1] The message id: header_not_long_enough
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
