Would this cause any breakage for people using an older version of MySQL?
On 5/23/06, Anil Gangolli <[EMAIL PROTECTED]> wrote:
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.
