Edgewall Software
Modify

Opened 19 years ago

Closed 19 years ago

Last modified 18 years ago

#71 closed defect (fixed)

Failure in sql statement (postgres) and incorrect total count in test chart

Reported by: florian.vogler@… Owned by: cmlenz
Priority: minor Milestone: 0.5.1
Component: Trac plugin Version: dev
Keywords: charts.py total count sql select Cc:
Operating System:

Description

Failures in charts.py

  • Select statement for test informations didn´t work on postgresql.
    ERROR:  column "build.rev_time" must appear in the GROUP BY clause or be used in an aggregate function
    
    Solution:
    Add build.rev_time to GROUP BY clause

  • Incorrect total count in test chart. Failure count was added to total count. Incorrect counting with different platforms.

Solution:
total = max(total_platform)
failure = max(failure_platform)

Change sql statement to get platform informations

Attachments (1)

charts.py.patch (2.1 KB) - added by florian.vogler@… 19 years ago.
patch to fix this to problems

Download all attachments as: .zip

Change History (3)

Changed 19 years ago by florian.vogler@…

patch to fix this to problems

comment:1 Changed 19 years ago by cmlenz

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

Fixed in [310] and [311], based on your patch. Thanks a lot!

comment:2 Changed 19 years ago by cmlenz

  • Component changed from General to Trac plugin

Add Comment

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain cmlenz.
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.