MantisBT - CDash
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008318CDashpublic2008-12-18 16:492009-03-09 13:14
ReporterJulien Jomier 
Assigned ToJulien Jomier 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version1.2.2 
Target VersionFixed in Version1.4 
Summary0008318: viewUpdate.php with PosgreSQL fails
DescriptionChris Garrett on the mailing list reported a bug in viewUpdate.php when using Postgres. The query is using MySQL specific functions. The simple work around for me was to write/copy the equivalent functions. Maybe you can add them to the install step or something...

CREATE OR REPLACE FUNCTION REVERSE(text) RETURNS TEXT AS
'
DECLARE reversed_string text;
incoming alias for $1;
BEGIN
reversed_string = '''';
for i in reverse char_length(incoming)..1 loop
reversed_string = reversed_string || substring(incoming from i for 1);
end loop;
return reversed_string;
END'
LANGUAGE PLPGSQL;

CREATE OR REPLACE FUNCTION LOCATE(text,text) RETURNS INT AS
'SELECT STRPOS($2, $1)'
LANGUAGE SQL;

CREATE OR REPLACE FUNCTION RIGHT(text,int) RETURNS TEXT AS
'SELECT SUBSTR($1, LENGTH($1)-$2+1)'
LANGUAGE SQL;
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-18 16:49Julien JomierNew Issue
2008-12-18 16:49Julien JomierStatusnew => assigned
2008-12-18 16:49Julien JomierAssigned To => Julien Jomier
2009-03-09 13:14Julien JomierNote Added: 0015610
2009-03-09 13:14Julien JomierStatusassigned => closed
2009-03-09 13:14Julien JomierResolutionopen => fixed
2009-03-09 13:14Julien JomierFixed in Version => 1.4

Notes
(0015610)
Julien Jomier   
2009-03-09 13:14   
Thanks for the report!