http://dev.helma.org/bugs/show_bug.cgi?id=667 Summary: limit / offset break collection
Product: Helma
Version: CVS trunk
Platform: Other
OS/Version: Linux
Status: NEW
Severity: enhancement
Priority: P5
Component: Database Layer
AssignedTo:
helma-dev@...
ReportedBy:
nostalgiker@...
when i set limit and offset on a normal collection helma never loads the
collections items - the collection stays empty. i can add things to it, that
works. but the items already in db don't get loaded.
this is most likly due to this broken COUNT sql issued by helma when i first
access the colleciton:
SQL SELECT_COUNT T_STORY 22: SELECT * FROM ( SELECT /*+ FIRST_ROWS(n) */ a.*,
ROWNUM rnum FROM (SELECT count(*) FROM T_STORY WHERE
T_STORY.STO_F_SIT_PARENTSITE = 1600000) a WHERE ROWNUM <= 15) WHERE rnum > 5
released = collection (Story)
released.local = SIT_ID
released.foreign = STO_F_SIT_PARENTSITE
released.order = STO_CREATETIME desc
released.limit = 10
released.offset = 5
--
Configure bugmail:
http://dev.helma.org/bugs/userprefs.cgi?tab=email------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Helma-dev mailing list
Helma-dev@...
http://helma.org/mailman/listinfo/helma-dev
