View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0015265CDash(No Category)public2014-11-26 09:042014-12-01 04:36
ReporterNils Gladitz 
Assigned ToJulien Jomier 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version2.4 
Summary0015265: Broken PostgreSQL queries
DescriptionI 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
TagsNo tags attached.
Attached Filespatch file icon fix_pgsql_queries.patch [^] (1,035 bytes) 2014-11-26 09:04 [Show Content]

 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!

 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


Copyright © 2000 - 2018 MantisBT Team