Modify

Opened 3 years ago

Closed 2 years ago

#9510 closed defect (fixed)

TestStats for single Testplans at 1.4.8 not working - patched

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

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

Download all attachments as: .zip

Change History (5)

Changed 3 years ago by podskalsky

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

comment:3 Changed 3 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 2 years ago by anonymous

  • Resolution set to fixed
  • Status changed from new to closed

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.