I read the source and find it seems MSYear's get_search_list() method
returns a sequence of (TEXT, MSYear, String, TypeEngine,
AbstractType).In this case, the first item, Text, is used.
I'm not familiar with the SQLAlchemy's whole archtecture, so now I'm
avoiding this problem adding get_search_list() method in MSYear like
this:
------------------------------------------
class MSYear(sqltypes.String):
"""MySQL YEAR type, for single byte storage of years 1901-2155"""
def get_col_spec(self):
if self.length is None:
return "YEAR"
else:
return "YEAR(%d)" % self.length
def get_search_list(self):
return [self.__class__]
------------------------------------------
I think this should be fixed in proper manner.
Regards,
Hiroshi Ayukawa
Sorry about that. This is now fixed in the trunk for 0.4 and in
the 0.3 maintenance branch.
Cheers,
Jason