You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Yuan Liu (JIRA)" <ji...@apache.org> on 2018/01/18 01:17:00 UTC
[jira] [Created] (TRAFODION-2915) Delete with no rollback chooses
traf_delete rather than vsbb_delete
Yuan Liu created TRAFODION-2915:
-----------------------------------
Summary: Delete with no rollback chooses traf_delete rather than vsbb_delete
Key: TRAFODION-2915
URL: https://issues.apache.org/jira/browse/TRAFODION-2915
Project: Apache Trafodion
Issue Type: Bug
Components: sql-general
Affects Versions: any
Reporter: Yuan Liu
Fix For: any
If the key column is not defined with “not null”, then the plan will choose “traf_delete”
If the key column is defined with “not null”, then the plan will choose “vsbb_delete”.
Below are my test case,
---------------1
SQL>cqd allow_nullable_unique_key_constraint 'on';
SQL>create table test_1(a int, b int) store by (a);
SQL>explain options 'f' delete with no rollback from test_1;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
3 . 4 root 1.00E+002
1 2 3 tuple_flow 1.00E+002
. . 2 trafodion_delete h TEST_1 1.00E+000
. . 1 trafodion_scan TEST_1 1.00E+002
---------------2
SQL>create table test_2(a int not null, b int) store by(a);
SQL>explain options 'f' delete with no rollback from test_2;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
3 . 4 root 1.00E+002
1 2 3 tuple_flow 1.00E+002
. . 2 trafodion_vsbb_delet TEST_2 1.00E+000
. . 1 trafodion_scan TEST_2 1.00E+002
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)