On Mar 27, 2010, at 5:17 PM, Michael Bayer wrote:

> 
> On Mar 27, 2010, at 4:16 PM, Lloyd Kvam wrote:
> 
>> I've just discovered that some tinyint (8-bit) fields have had their
>> values limited to 0 and 1 regardless of actual value supplied.  Digging
>> through the documentation, I've learned that when MySQL tables are
>> reflected, tinyint(1) fields are processed as booleans.
>> 
>> I did not find emails from others howling in pain, so I suppose most
>> people are either happy with this behavior or unaffected.  I understand
>> why a bool column definition would be mapped to tinyint(1).  However,
>> doing the reverse, mapping tinyint(1) to bool, discards bits that MySQL
>> would not discard.
>> 
>> For me this was a misfeature.  I would think that supplying bools to an
>> integer field would work OK.  In python 2 + True == 3.  So people using
>> booleans should not have too much difficulty, would they?  Is there any
>> chance you'd consider autoloading tinyint(1) as an integer field?
> 
> sure i will remove this behavior today.

it is out in r95ac46ca88ee.


> 
> 
> 
> 
> 
> 
>> 
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "sqlalchemy" group.
>> To post to this group, send email to sqlalch...@googlegroups.com.
>> To unsubscribe from this group, send email to 
>> sqlalchemy+unsubscr...@googlegroups.com.
>> For more options, visit this group at 
>> http://groups.google.com/group/sqlalchemy?hl=en.
>> 
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "sqlalchemy" group.
> To post to this group, send email to sqlalch...@googlegroups.com.
> To unsubscribe from this group, send email to 
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/sqlalchemy?hl=en.
> 

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to