Scarab commit: svn commit: r10141 - trunk/src/java/org/tigris/scarab/util/word/IssueSearch.java

Author: pledbrook
Date: 2006-06-05 01:15:19-0700
New Revision: 10141

Modified:
   trunk/src/java/org/tigris/scarab/util/word/IssueSearch.java

Log:
Minor fix to some SELECT statements in IssueSearch so the queries work with PostgreSQL.

Modified: trunk/src/java/org/tigris/scarab/util/word/IssueSearch.java
Url: http://scarab.tigris.org/source/browse/scarab/trunk/src/java/org/tigris/scarab/util/word/IssueSearch.java?view=diff&rev=10141&p1=trunk/src/java/org/tigris/scarab/util/word/IssueSearch.java&p2=trunk/src/java/org/tigris/scarab/util/word/IssueSearch.java&r1=10140&r2=10141
==============================================================================
--- trunk/src/java/org/tigris/scarab/util/word/IssueSearch.java	(original)
+++ trunk/src/java/org/tigris/scarab/util/word/IssueSearch.java	2006-06-05 01:15:19-0700
@@ -172,10 +172,10 @@
         ActivitySetPeer.CREATED_DATE.indexOf('.')+1);
     private static final String ACTSET_MODIFIED_BY = 
         ActivitySetPeer.CREATED_BY.substring(
-        ActivitySetPeer.CREATED_BY.indexOf('.')+1) + " MODIFIED_BY";
+        ActivitySetPeer.CREATED_BY.indexOf('.')+1) + " as MODIFIED_BY";
     private static final String ACTSET_MODIFIED_DATE = 
         ActivitySetPeer.CREATED_DATE.substring(
-        ActivitySetPeer.CREATED_DATE.indexOf('.')+1) + " MODIFIED_DATE";
+        ActivitySetPeer.CREATED_DATE.indexOf('.')+1) + " as MODIFIED_DATE";
     private static final String ACT_ISSUE_ID = 
         ActivityPeer.ISSUE_ID.substring(ActivityPeer.ISSUE_ID.indexOf('.')+1);
     private static final String ACTIVITYALIAS_ISSUE_ID =