[ https://issues.apache.org/jira/browse/TRAFODION-1449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Qifan Chen resolved TRAFODION-1449. ----------------------------------- Resolution: Fixed Fix Version/s: 1.1 (pre-incubation) These files are modified. core/sql/generator/GenPreCode.cpp core/sql/optimizer/SearchKey.cpp core/sql/optimizer/SearchKey.h core/sql/optimizer/SimpleScanOptimizer.cpp core/sql/optimizer/disjuncts.h core/sql/optimizer/mdam.cpp core/sql/regress/seabase/EXPECTED010 > 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)