Bug 38273 - method "retrieveRevisionDescriptors" of "StandardRDBMSAdapter"
Summary: method "retrieveRevisionDescriptors" of "StandardRDBMSAdapter"
Status: NEW
Alias: None
Product: Slide
Classification: Unclassified
Component: Stores (show other bugs)
Version: 2.1
Hardware: All All
: P1 normal (vote)
Target Milestone: ---
Assignee: Slide Developer List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-01-14 15:40 UTC by xiao pengcheng
Modified: 2006-01-14 06:40 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description xiao pengcheng 2006-01-14 15:40:13 UTC
In the method "retrieveRevisionDescriptors" of "StandardRDBMSAdapter", the sql 
for selecting successor "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 = ?" is wrong, I think it should 
be "select distinct pvh.REVISION_NO from VERSION_HISTORY vh, VERSION_HISTORY 
pvh, VERSION_PREDS vp, URI u where pvh.VERSION_ID = vp.PREDECESSOR_ID and 
vp.VERSION_ID = vh.VERSION_ID and vh.URI_ID = u.URI_ID and u.URI_STRING = ? 
and vh.REVISION_NO = ?"; and the column name "VERSION_ID" and "PREDECESSOR_ID" 
of table "VERSION_PREDS" should be exchanged, they are confusable!