[Zope-CMF] Optimizing catalog queries

[Chris McDonough]

DateRangeIndexes and DateIndexes are broken for dates past Y2038 (see
http://www.dewtronics.com/y2038.html).  I think CMF's DublinCore
CEILING_DATE needs to change to one second before the Y2038 cutoff.  You
could try this in your own copy, leaving the date/daterange indexes the
way they are...

- C


On Mon, 2003-11-10 at 12:48, Seb Bacon wrote:
> Gitte Wange wrote:
> >>Okay :-)
> >>I have changed the indexes now but couldn't change the index for 'expires'.
> >>I simply got an Overflow Error, because the date it tried to index is
> >>9998/12/31 and the _convert method raised an overflow error. I can see that
> >>there is a long time untill year 9998 but shouldn't it be able to handle
> >>such a date ?
> >>Will try an Google for answers.
> > 
> > 
> > Google found the answer for me - a collector issue #710 from december last 
> > year :-(
> > Doesn't look like there's a fix for this comming up ...
> 
> A quick hack which would almost certainly work for you: try changing the 
> line which raises an OverflowError to "return sys.maxint".
> 
> 
> 
> _______________________________________________
> Zope-CMF maillist  -  Zope-CMF at zope.org
> http://mail.zope.org/mailman/listinfo/zope-cmf
> 
> See http://collector.zope.org/CMF for bug reports and feature requests