View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0014589CDash(No Category)public2013-11-21 10:082013-11-25 15:15
ReporterIgor 
Assigned ToJulien Jomier 
PrioritynormalSeverityminorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version2.2 
Summary0014589: [PATCH] BUG: Fix a PostgreSQL incompatibility.
DescriptionFixes 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;
TagsNo tags attached.
Attached Filespatch file icon 0001-BUG-Fix-a-PostgreSQL-incompatibility.patch [^] (1,702 bytes) 2013-11-21 10:08 [Show Content]

 Relationships

  Notes
There are no notes attached to this issue.

 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


Copyright © 2000 - 2018 MantisBT Team