+1
On Jan 7, 2010, at 8:53 PM, Mike Kienenberger wrote:
I'd say a static list with a note to check the jira system for
updates.
But for any given release, the bugs aren't going to go away :)
On Thu, Jan 7, 2010 at 3:58 AM, Aristedes Maniatis
<[email protected]> wrote:
How do we want to deal with this? A list of known issues at the top
of the
release notes file? Or else just a link to the Jira with a search
for issues
still open and reported in 3.0 (which means it is dynamic and
constantly
updated as new issues are found). If the later, we need to do more
triage to
separate out real bugs from support requests and feature requests
and also
some really old 1.2 bugs which aren't relevant.
Ari
On 7/01/10 6:47 PM, Andrey Razumovsky (JIRA) wrote:
[
https://issues.apache.org/jira/browse/CAY-1266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrey Razumovsky updated CAY-1266:
-----------------------------------
Priority: Critical (was: Blocker)
Summary: Joint prefetches with fetch limit and offset do not
work on
Oracle (was: Joint prefetches do not work on Oracle)
This issue is nasty, but I'm afraid it cannot be fixed easily
since nested
SQL statements are *required* for Oracle fetch limit/offset. So
let's
release without it
Joint prefetches with fetch limit and offset do not work on Oracle
------------------------------------------------------------------
Key: CAY-1266
URL: https://issues.apache.org/jira/browse/CAY-1266
Project: Cayenne
Issue Type: Bug
Components: Database integration
Affects Versions: 3.0M6
Reporter: Andrey Razumovsky
Priority: Critical
Fix For: 3.0RC2
Joint prefetches do not work on Oracle(when at least one column
name in
root and prefetched tables has the same name (this is the most
common case -
source and target join columns have the same name). Example of
invalid SQL:
select * from ( select tid.*, ROWNUM rnum from (SELECT DISTINCT
t0.DOCID,
t0.DOCTYPEID, t0.DOCDATE, t0.TIMESTAMP, t0.DOCDATEBEGIN,
t0.DOCDESC,
t0.DOCNAME, t0.DOCEND, t0.DOCDATEEND, t0.DOCSTATUSID, t0.LABELID,
t0.DOCNUMBER, t0.DELETED, t0.DBUSER, t0.FOLDERID, t0.DOCDATEAGREE,
t1.DBUSER, t1.DELETED, t1.TIMESTAMP, t1.CUSTOMERID, t1.DOCID,
t1.KCADOCID,
t1.KCADOCTYPEID, t1.KCAID, t1.ORGSID FROM DOC t0 LEFT JOIN
KCA_DOC t1 ON
(t0.DOCID = t1.DOCID) WHERE t0.DOCTYPEID = ?) tid where
ROWNUM<=30) where
rnum> 0
--
-------------------------->
Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
