Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-1449

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

    XMLWordPrintableJSON

    Details

      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)

        Attachments

          Activity

            People

            • Assignee:
              qfc Qifan Chen
              Reporter:
              qfc Qifan Chen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: