agesys-dev team mailing list archive

[Aaron Gallagher <habnabit@xxxxxxxxx>]

** Changed in: oursql
   Importance: Undecided => High

** Changed in: oursql
       Status: New => In Progress

** Changed in: oursql
    Milestone: None => 0.9.3

-- 
You received this bug notification because you are a member of Agesys
Team, which is subscribed to oursql.
https://bugs.launchpad.net/bugs/672059

Title:
  Improper handling of DATE, DATETIME, and TIMESTAMP fields

Status in oursql:
  In Progress

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.