Modify

Opened 12 years ago

Closed 12 years ago

#9510 closed defect (fixed)

TestStats for single Testplans at 1.4.8 not working - patched

Reported by: podskalsky Owned by: Roberto Longobardi
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 (1)

stats.zip (4.4 KB) - added by podskalsky 12 years ago.

Download all attachments as: .zip

Change History (5)

Changed 12 years ago by podskalsky

Attachment: stats.zip added

comment:1 Changed 12 years ago 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

comment:2 Changed 12 years ago by Roberto Longobardi

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

comment:3 Changed 12 years ago 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")

comment:4 Changed 12 years ago by anonymous

Resolution: fixed
Status: newclosed

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Roberto Longobardi.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.