Explicitly setting a boolean attribute on a mysql object results fails: undefined method `to_i'

ActiveRecord uses 'show create table' to infer the types of columns. However, even if a column was declared as a bool when the table was created, mysql's "show create table" displays it as a tinyint, thus causing ActiveRecord to consider that the column type is integer. Thus if you say: @faz.a = false, you get the exception from line 194 in abstract_adaptor.rb, which is:

when :integer then value.to_i

mysql> create table faz (a bool); Query OK, 0 rows affected (0.01 sec) mysql> show create table faz; +-------+------------------------------------------------------------------+ | Table | Create Table | +-------+------------------------------------------------------------------+ | faz | CREATE TABLE faz (

a tinyint(1) default NULL

) TYPE=MyISAM | +-------+------------------------------------------------------------------+ 1 row in set (0.00 sec)

Probable work-around should probably be to explicitly cover the case that a 'tinyint(1)' can be a boolean.

This is fixed in 0.10, see #226