[
https://issues.apache.org/jira/browse/TRAFODION-1449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14716055#comment-14716055
]
Qifan Chen commented on TRAFODION-1449:
---------------------------------------
The fix has been reviewed by Hans with the following final comments.
Hans Zeller <[email protected]>
Aug 25 (1 day ago)
Hi Qifan,
That looks like a good, safe, conservative fix to me.
Thanks for investigating and fixing this hairy problem,
Hans
> End-key is not specified for a scan node when range spec feature is on.
> ------------------------------------------------------------------------
>
> Key: TRAFODION-1449
> URL: https://issues.apache.org/jira/browse/TRAFODION-1449
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 1.1 (pre-incubation)
> Reporter: Qifan Chen
> Assignee: Qifan Chen
> Labels: performance
>
> 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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
