reading invalid dates from mysql db raises exception
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
oursql |
New
|
Undecided
|
Unassigned |
Bug Description
This should not happen because I want to be able to get the data in the database out of the database even if it is invalid. The database stores data and if I store something dumb it should just let me get it back.
The only thing that really needs to change is lines 502-504 in statement.pyx:
- elif c.type in (MYSQL_
- MYSQL_TYPE_DATE) and d.t.year == 0:
- val = None
+ elif c.type in (MYSQL_
+ MYSQL_TYPE_DATE) and (d.t.year == 0 or d.t.month == 0 or
+ d.t.day == 0):
+ val = PyString_
much better to deliver a meaningless string than a meaningful absence of data where there wasn't one.
description: | updated |