Modify ↓
#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)
Change History (3)
Changed 19 years ago by florian.vogler@…
comment:1 Changed 19 years ago by cmlenz
- Resolution set to fixed
- Status changed from new to closed
comment:2 Changed 19 years ago by cmlenz
- Component changed from General to Trac plugin
Note: See
TracTickets for help on using
tickets.
patch to fix this to problems