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