Bug 27396 - Invalid SQL statement in StandardRDBMSAdapter.java's retrieveObject()
Summary: Invalid SQL statement in StandardRDBMSAdapter.java's retrieveObject()
Status: RESOLVED FIXED
Alias: None
Product: Slide
Classification: Unclassified
Component: Stores (show other bugs)
Version: 2.0
Hardware: Other other
: P3 normal (vote)
Target Milestone: ---
Assignee: Slide Developer List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-03-03 06:41 UTC by Willie Vu
Modified: 2004-11-16 19:05 UTC (History)
0 users



Attachments
Patch (986 bytes, patch)
2004-03-03 06:42 UTC, Willie Vu
Details | Diff
correct patch (998 bytes, patch)
2004-03-03 11:43 UTC, Willie Vu
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Willie Vu 2004-03-03 06:41:36 UTC
Revision 1.14.2.1, line 331,

statement =
                        connection.prepareStatement(
                            "SELECT lu.URI_STRING URI lu, LINKS l WHERE
lu.URI_ID = l.LINK_TO_ID AND l.URI_ID = u.URI_ID and u.URI_STRING = ?");

The SQL should be:

statement =
                        connection.prepareStatement(
                            "SELECT lu.URI_STRING FROM URI u, URI lu, LINKS l
WHERE lu.URI_ID = l.LINK_TO_ID AND l.URI_ID = u.URI_ID and u.URI_STRING = ?");
Comment 1 Willie Vu 2004-03-03 06:42:12 UTC
Created attachment 10645 [details]
Patch
Comment 2 Oliver Zeigermann 2004-03-03 10:09:53 UTC
Applied patch
Comment 3 Willie Vu 2004-03-03 11:42:49 UTC
Oliver, something wrong with the previous patch attachment.  It doesn't fix the
problem.  I'll upload a correct patch.  Sorry about that.
Comment 4 Willie Vu 2004-03-03 11:43:36 UTC
Created attachment 10647 [details]
correct patch
Comment 5 Oliver Zeigermann 2004-03-23 15:03:11 UTC
Should be fixed