[
https://issues.apache.org/jira/browse/TRAFODION-1449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14717272#comment-14717272
]
Qifan Chen commented on TRAFODION-1449:
---------------------------------------
Hi Dave,
I think we need some time to verify what Suresh was pointing out (i.e., if the
ELSE branch is incorrect). Since the same code is present in another method,
my thinking is that we can do it after the code merge.
I am not sure my replies this morning have addressed all the comments from you,
Suresh and Hans.
By the way, Hans has reviewed the code on Monday.
Thanks --Qifan
> 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
> Fix For: 1.1 (pre-incubation)
>
>
> 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)
