MantisBT - CDash |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0014589 | CDash | (No Category) | public | 2013-11-21 10:08 | 2013-11-25 15:15 |
|
| Reporter | Igor | |
| Assigned To | Julien Jomier | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | |
| Platform | | OS | | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 2.2 | |
|
| Summary | 0014589: [PATCH] BUG: Fix a PostgreSQL incompatibility. |
| Description | Fixes the following PostgreSQL error:
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list at character 598
STATEMENT: SELECT DISTINCT up.userid FROM user2project AS up,
user2repository AS ur,dailyupdatefile,dailyupdate
WHERE dailyupdatefile.dailyupdateid=dailyupdate.id
AND dailyupdate.projectid=up.projectid
AND ur.credential=dailyupdatefile.author
AND up.projectid=5
AND up.userid=ur.userid
AND (ur.projectid=0 OR ur.projectid=5)
AND dailyupdatefile.filename LIKE '%simple.cxx' ORDER BY dailyupdate.id DESC LIMIT 1; |
| Steps To Reproduce | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  0001-BUG-Fix-a-PostgreSQL-incompatibility.patch (1,702) 2013-11-21 10:08
https://public.kitware.com/Bug/file/4959/0001-BUG-Fix-a-PostgreSQL-incompatibility.patch |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2013-11-21 10:08 | Igor | New Issue | |
| 2013-11-21 10:08 | Igor | File Added: 0001-BUG-Fix-a-PostgreSQL-incompatibility.patch | |
| 2013-11-25 15:15 | Julien Jomier | Assigned To | => Julien Jomier |
| 2013-11-25 15:15 | Julien Jomier | Status | new => assigned |
| 2013-11-25 15:15 | Julien Jomier | Status | assigned => resolved |
| 2013-11-25 15:15 | Julien Jomier | Fixed in Version | => 2.2 |
| 2013-11-25 15:15 | Julien Jomier | Resolution | open => fixed |