[jira] [Created] (TRAFODION-834) LP Bug: 1403953 - full scan indicator in the CompilerStatsInfo is not set

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-834:
------------------------------------

             Summary: LP Bug: 1403953 - full scan indicator in the CompilerStatsInfo is not set
                 Key: TRAFODION-834
                 URL: https://issues.apache.org/jira/browse/TRAFODION-834
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Qifan Chen
            Assignee: Ravisha Neelakanthappa


In traf, the full scan indicator in the CompilerStatsInfo is not set. On Seaquest we set this in FileScan::preCodeGen(). 

>From Arvind:

The select you did should result in a full scan. CCg Mike and Selva to confirm if the flag gets set in Trafodion and whether we should be looking at that in INFOSTATS. We get this compile stat info as an output from SQL_EXEC_Prepare2() and the same is displayed via INFOSTATS

Since ‘cs’ option is not returning the compile stats debugged sqlci - 


(gdb) p *cmpStatsInfo
$8 = {totalOps_ = 2, exchangeOps_ = 0, dp2Ops_ = 0, hj_ = 0, mj_ = 0, nj_ = 0, 
  espTotal_ = 0, espLevels_ = 0, dop_ = 0, collectStatsType_ = 5, 
  affinityNumber_ = 0, totalFragmentSize_ = 16, masterFragmentSize_ = 16, 
  espFragmentSize_ = 0, dp2FragmentSize_ = 0, dp2RowsAccessed_ = 0, 
  dp2RowsUsed_ = 0, dp2RowsAccessedForFullScan_ = -1, flags_ = 0, bmo_ = 0, 
  udr_ = 0, ofSize_ = 0, ofMode_ = 2, queryType_ = 2, subqueryType_ = 0, 
  filler_ = '\000' <repeats 47 times>}

Regards
Arvind

=======================  how to verify 


SQL>PREPARE S1 from select * from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;

--- SQL command prepared.

SQL>INFOSTATS S1;

QueryID         CPUTime     IOTime    MsgTime     IdleTime TotalTime Cardinality ResourceUsage AffinityNumber Dop  XnNeeded MandatoryCrossProduct MissingStats NumOfJoins FullScanOnTable HighDp2MxBufferUsage RowsAccessedForFullScan Dp2RowsAccessed Dp2RowsUsed
------------------------------------------------------------ ----------- --------- ----------- -------- --------- ----------- ------------- -------------- ---- -------- --------------------- ------------ ---------- --------------- -------------------- ----------------------- --------------- -----------
MXID11000024022212285042097397025000000000406U3333300_237_S1  0.00521141  0.544427  0.00372297        0  0.553361         319             0              0    0        0         0            0          0               0              0            -1               0           0

--- SQL operation complete.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)