Repos - METRIC_QUERY_TABLE - submit time is after exec start time for some queries

[Aruna Sadashiva]

METRIC_QUERY_TABLE : SUBMIT_UTC_TS > EXEC_START_UTC_TS for some queries like 'insert into BATCHTBL values(?,?,?,?)' - Should submit ts be prior to exec start ts?

According to Rao, SUBMIT SHOULD BE SAME AS EXEC_START

[Judy Zhao (hongxia-zhao)]

I got following result by trafci :

SQL>select SUBMIT_UTC_TS-EXEC_START_UTC_TS as "SUB-START",SUBMIT_UTC_TS,EXEC_START_UTC_TS from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;

SUB-START SUBMIT_UTC_TS EXEC_START_UTC_TS
-------------------- -------------------------- --------------------------
           0.012160 2015-01-15 06:37:16.516158 2015-01-15 06:37:16.503998
           0.002414 2015-01-15 06:37:17.108331 2015-01-15 06:37:17.105917
           … …
          0.000000 2015-01-16 06:56:36.063327 2015-01-16 06:56:36.063327
           0.000000 2015-01-16 06:57:02.699691 2015-01-16 06:57:02.699691
           … …

Here SUBMIT_UTC_TS is always larger or equal to EXEC_START_UTC_TS .

Then I checked the source and found that:
1.pQuery_info->m_submit_utc_ts = statementStartTime
2.statementStartTime = JULIANTIMESTAMP(); which is set at ResStatisticsStatement::start.
So this is the reason why the submit_utc is different with exec_start_utc.

My question is : The submit_utc should equal to exec_start_utc or not ? Is this a bug ?

[Judy Zhao (hongxia-zhao)]

This change has been commited with the fix of 1409225 ,please QA verified that.

[Judy Zhao (hongxia-zhao)]

This change has been commited with the fix of 1409225.