Ticket #9510 (closed defect: fixed)

Opened 2 years ago

Last modified 1 year ago

TestStats for single Testplans at 1.4.8 not working - patched

Reported by: podskalsky Assigned to: seccanj
Priority: highest Component: TestManagerForTracPlugin
Severity: blocker Keywords:
Cc: Trac Release: 0.12

Description

There is a bug in your SQL statement! Single TestPlan? statistics are not running at 1.4.8!

patched line 115 at stats.py:

sql = "SELECT COUNT(*) FROM testcasehistory th1, (SELECT id, planid, max(time) as maxtime FROM testcasehistory WHERE planid = '%s' AND time > %s AND time <= %s GROUP BY planid, id) th2 WHERE th1.time = th2.maxtime AND th1.id = th2.id AND th1.planid = th2.planid AND th1.status = '%s'" % (testplan, to_any_timestamp(from_date), to_any_timestamp(at_date), status)

Regards, Andreas

Attachments

stats.zip (4.4 kB) - added by podskalsky on 11/02/11 11:25:40.

Change History

11/02/11 11:25:40 changed by podskalsky

  • attachment stats.zip added.

11/02/11 14:34:09 changed by anonymous

Ciao Andreas, well, thanks for catching this one!

I'll try to take a look at this tonight, in the meantime, would you take a look at the development version of 1.4.9 attached to ticket #8958 and let me know what you think?

Ciao, Roberto

01/04/12 00:41:45 changed by seccanj

Hi, the fix to this ticket is in the latest BETA 1.4.9 release, attached to #9287.

Actually there also is the need for updating the language catalogs. I have uploaded the modified versions on Transflex for anyone to contribute.

Refer to the forum post for details.

It would be great if you could take a tour and, besides looking at the new stuff, make sure nothing (big) is broken.

Thanks, ciao. Roberto

01/04/12 15:11:22 changed by podskalsky

can't find this "bug" at BETA 1.4.9 release :-)

But: At "test activity trend" there is nothing displayed for test plans with "selected" test cases ("Only the Test Cases selected before")

03/05/12 09:27:57 changed by anonymous

  • status changed from new to closed.
  • resolution set to fixed.

Add/Change #9510 (TestStats for single Testplans at 1.4.8 not working - patched)




Change Properties
Action