Public bug reported:
If improper data is passed to these fields, or they are left blank while
set to NOT NULL, MySQL will force their fields all to zero. The type
handling code for 'fetchone' is not set up for this possibility, and the
datetime module cannot handle such nonsensical dates, so the fetch
fails. The old behavior for the MySQLdb module was to return None.
Attached patch emulates that behavior.
** Affects: oursql
Importance: Undecided
Status: New
--
Improper handling of DATE, DATETIME, and TIMESTAMP fields
https://bugs.launchpad.net/bugs/672059
You received this bug notification because you are a member of Agesys
Team, which is subscribed to oursql.
Status in oursql python bindings for mysql: New
Bug description:
If improper data is passed to these fields, or they are left blank while set to
NOT NULL, MySQL will force their fields all to zero. The type handling code
for 'fetchone' is not set up for this possibility, and the datetime module
cannot handle such nonsensical dates, so the fetch fails. The old behavior for
the MySQLdb module was to return None. Attached patch emulates that behavior.
_______________________________________________
Mailing list: https://launchpad.net/~agesys-dev
Post to : [email protected]
Unsubscribe : https://launchpad.net/~agesys-dev
More help : https://help.launchpad.net/ListHelp
