wburrows 2004/12/07 13:15:18
Modified: src/stores/org/apache/slide/store/impl/rdbms
StandardRDBMSAdapter.java
Log:
Defect 32072: use DISTINCT keyword in revision selection statement to weed
out dupes.
Revision Changes Path
1.40 +5 -5
jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms/StandardRDBMSAdapter.java
Index: StandardRDBMSAdapter.java
===================================================================
RCS file:
/home/cvs/jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms/StandardRDBMSAdapter.java,v
retrieving revision 1.39
retrieving revision 1.40
diff -u -r1.39 -r1.40
--- StandardRDBMSAdapter.java 11 Nov 2004 17:15:35 -0000 1.39
+++ StandardRDBMSAdapter.java 7 Dec 2004 21:15:18 -0000 1.40
@@ -899,7 +899,7 @@
try {
statement =
connection.prepareStatement(
- "select pvh.REVISION_NO from VERSION_HISTORY vh,
VERSION_HISTORY pvh, VERSION_PREDS vp, URI u where pvh.VERSION_ID =
vp.VERSION_ID and vp.VERSION_ID = vh.VERSION_ID and vh.URI_ID = u.URI_ID and
u.URI_STRING = ? and vh.REVISION_NO = ?");
+ "select distinct pvh.REVISION_NO from
VERSION_HISTORY vh, VERSION_HISTORY pvh, VERSION_PREDS vp, URI u where
pvh.VERSION_ID = vp.VERSION_ID and vp.VERSION_ID = vh.VERSION_ID and vh.URI_ID
= u.URI_ID and u.URI_STRING = ? and vh.REVISION_NO = ?");
statement.setString(1, uri.toString());
statement.setString(2, revisionNumber.toString());
res = statement.executeQuery();
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
