View Issue Details [ Jump to Notes ] | [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
0015265 | CDash | (No Category) | public | 2014-11-26 09:04 | 2014-12-01 04:36 | ||||
Reporter | Nils Gladitz | ||||||||
Assigned To | Julien Jomier | ||||||||
Priority | normal | Severity | minor | Reproducibility | always | ||||
Status | closed | Resolution | fixed | ||||||
Platform | OS | OS Version | |||||||
Product Version | |||||||||
Target Version | Fixed in Version | 2.4 | |||||||
Summary | 0015265: Broken PostgreSQL queries | ||||||||
Description | I have attached a patch to fix two SQL queries with postgresql. The first: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list at character 341 STATEMENT: SELECT DISTINCT build.id AS id FROM build, build2uploadfile, uploadfile WHERE build.projectid=1 AND build.id=build2uploadfile.buildid AND build2uploadfile.fileid=uploadfile.id ORDER BY build.starttime ASC The second: ERROR: column "project.name" must appear in the GROUP BY clause or be used in an aggregate function at character 8 STATEMENT: SELECT project.name, project.id, COUNT(submission.id) AS c FROM "project", "submission" WHERE project.id = submission.projectid AND status = 0 GROUP BY project.id | ||||||||
Tags | No tags attached. | ||||||||
Attached Files | fix_pgsql_queries.patch [^] (1,035 bytes) 2014-11-26 09:04 [Show Content] | ||||||||
Relationships | |
Relationships |
Notes | |
(0037311) Julien Jomier (manager) 2014-11-28 11:31 |
Pushed into the CDash git repository. Thanks for the report and patch! |
(0037318) Nils Gladitz (reporter) 2014-12-01 04:36 |
Thanks! |
Notes |
Issue History | |||
Date Modified | Username | Field | Change |
2014-11-26 09:04 | Nils Gladitz | New Issue | |
2014-11-26 09:04 | Nils Gladitz | File Added: fix_pgsql_queries.patch | |
2014-11-28 11:28 | Julien Jomier | Assigned To | => Julien Jomier |
2014-11-28 11:28 | Julien Jomier | Status | new => assigned |
2014-11-28 11:31 | Julien Jomier | Note Added: 0037311 | |
2014-11-28 11:31 | Julien Jomier | Status | assigned => resolved |
2014-11-28 11:31 | Julien Jomier | Fixed in Version | => 2.4 |
2014-11-28 11:31 | Julien Jomier | Resolution | open => fixed |
2014-12-01 04:36 | Nils Gladitz | Note Added: 0037318 | |
2014-12-01 04:36 | Nils Gladitz | Status | resolved => closed |
Issue History |
Copyright © 2000 - 2018 MantisBT Team |