Sounds good to me.
-- Allen
Anil Gangolli 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.
