[TRAFODION-1449] End-key is not specified for a scan node when range spec feature is on.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1 (pre-incubation)
• Fix Version/s: 1.1 (pre-incubation)
• Component/s: sql-cmp
• Labels: performance
• Assignee: Qifan Chen
• Reporter: Qifan Chen
• Created: 12/Aug/15 19:49
• Updated: 15/Sep/18 07:32
• Resolved: 27/Aug/15 04:09

Description

Problem: the end key is not specified for the scan operator and is evaluated in the executor predicate.

MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
PLAN_ID .................. 212306167959521210
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
from foo << + cardinality 10e8 >>
where uniq > 2 and uniq < 5;

TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
TABLE_NAME ............... FOO
REQUESTS_IN .............. 1
ROWS_OUT ................ 11
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est .......... 11
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
scan_type .............. subset scan of table TRAFODION.SEABASE.FOO
object_type ............ Trafodion
columns ................ all
begin_keys(excl) ....... 2
end_keys(incl)
cache_size ........... 100
probes ................. 1
rows_accessed ......... 11
key_columns ............ UNIQ
executor_predicates .... (UNIQ < 5) and (UNIQ > 2) and (UNIQ < 5)