WRONG QUERY_STATUS/QUERY_SUB_STATUS for canceled queries in METRIC_QUERY_TABLE

[Feng, Qiang]

Two scenarios for this issue

1. Cancel a running query with sql command control query cancel qid "MXID11000013602212294668646838350000000000906U3333300_32053_XX".
In "_REPOS_".METRIC_QUERY_TABLE, it has value for EXEC_END_UTC_TS. But QUERY_STATUS is COMPLETED and no value for QUERY_SUB_STATUS. Should either of the status tells that the query was canceled?

2. Kill the trafci client while a select query is still running.
In "_REPOS_".METRIC_QUERY_TABLE, it has value for EXEC_END_UTC_TS. But QUERY_STATUS remains 'EXECUTING' and no value for QUERY_SUB_STATUS. Should either of the status tells that the query was canceled?

[jiegao (jie-gao)]

i have reproduced this bug. yes, the query status sounds not updated timely. i am working on reading the code logic and trying to find out a good solution on this bug.

[jiegao (jie-gao)]

i am updating my status: i have completed unit testing for scenario one and i also found that scenario two may not as difficult as i thought before after i talked to QAer this afternoon. i will be working on scenario 2 in the following days.