core/TESTRTS failed with bad Oper CPU Time in explain

Bug #1461699 reported by Dave Birdsall
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Fix Committed
Undecided
Selvaganesan Govindarajan

Bug Description

During gate tests for change https://review.trafodion.org/#/c/1716/, test core/TESTRTS failed because in an Explain plan, Oper CPU Time was reported as 3 for EX_TRAF_KEY_SELECT tcbs. The expected file shows 0 instead.

This failure did not occur during check jobs; instead the expected value of 0 occured.

I doubt this code change had anything to do with the failure; the code change is entirely in DDL logic, not in query plan costing. So I suspect an intermittent failure. Hence this case to record this suspicion.

Revision history for this message
Dave Birdsall (dave-birdsall) wrote :

The description is incorrect. The mismatching Oper CPU Time value was in a "display statistics for <query ID>" command, not an explain.

Revision history for this message
Selvaganesan Govindarajan (selva-ganesan) wrote :

Fixed. See https://review.trafodion.org/1756 for details

Changed in trafodion:
assignee: nobody → Selvaganesan Govindarajan (selva-ganesan)
status: New → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.