Menu

#158 server - RPCS query may not work with timeuntil 9999-12-31

open
nobody
jaws (77)
5
2007-03-29
2007-03-29
No

The server returns always zero results back, if a GetRPCS query with date 9999-12-31 in timeuntil field is sended over XMLRPC. This is a bug in MySQL:
it parses this date to NULL ('0000-00-00') if the datetime field is indexed.

Countermeasures:
* upgrade MySQL to at least 5.0.24 (5.0.22 known to not work, 5.0.26 known to work)
* delete index over datetime columns (for dsnconinfo and dsnrpcs)
* use rather the current datetime instead of 9999-12-31

Discussion

MongoDB Logo MongoDB