I'd like to change BOOLEAN_SQL_TYPE (and the other related definitions) for
mysql to use TINYINT(1) instead of BIT at least in the trunk. Any
objections?
We can decide separately whether this warrants merging to the 2.3 branch and
re-spinning.
--a.
----- Original Message -----
From: "Anil Gangolli" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, May 23, 2006 7:29 AM
Subject: Roller breaking on MySQL 5.0.3 and higher releases
Roller breaks on MySQL 5.0.3 and higher releases due to the use of the BIT
type instead of TINYINT. I think MySQL is up beyond 5.0.18 now, and lots of
people are running recent versions of 5.x.
Prior to 5.0.3, BIT was a synoynym for TINYINT(1). It no longer is, and it
seems not to hold a boolean type properly (not sure why). People on the
users list have been hitting this left and right with different symptoms.
We probably should change the MySQL createdb and upgrade scripts to use
TINYINT(1) instead of BIT before 2.3 releases. Users have figured out to
do this themselves. A release note is a (much less preferable) second
option.
