[322067] Audit mapping creates illegal SQL for XRefs

https://bugs.eclipse.org/bugs/show_bug.cgi?id=322067

1 files changed, 2 insertions, 4 deletions

diff --git a/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/HorizontalAuditClassMapping.java b/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/HorizontalAuditClassMapping.java
index eb35bfd10a..f785e5154b 100644
--- a/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/HorizontalAuditClassMapping.java
+++ b/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/HorizontalAuditClassMapping.java
@@ -573,13 +573,11 @@ public class HorizontalAuditClassMapping extends AbstractHorizontalClassMapping
     }
 
     StringBuilder builder = new StringBuilder();
-    builder.append("(");
-
     long timeStamp = context.getTimeStamp();
     if (timeStamp == CDORevision.UNSPECIFIED_DATE)
     {
       builder.append(CDODBSchema.ATTRIBUTES_REVISED);
-      builder.append("=0)"); //$NON-NLS-1$
+      builder.append("=0"); //$NON-NLS-1$
     }
     else
     {
@@ -592,7 +590,7 @@ public class HorizontalAuditClassMapping extends AbstractHorizontalClassMapping
       builder.append(CDODBSchema.ATTRIBUTES_REVISED);
       builder.append(">=");
       builder.append(timeStamp);
-      builder.append("))"); //$NON-NLS-1$
+      builder.append(")"); //$NON-NLS-1$
     }
 
     return builder.toString();