cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Known issues
Date Sun, 10 Jan 2010 10:44:45 GMT
+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  
> <ari@maniatis.org> 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
>>
>


Mime
View raw message