[ROL-1148] Roller use of BIT type breaks on MySQL 5.0.3 and higher

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1
• Fix Version/s: 2.3
• Component/s: Data Model & JPA Backend
• Database: MySQL 5.0.3 and higher
• Assignee: Anil Gangolli
• Reporter: Anil Gangolli
• Created: 23/May/06 14:26
• Updated: 05/Jan/13 20:46
• Resolved: 24/May/06 06:37

Description

Roller breaks on MySQL 5.0.3+ 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 BIT no longer seems to work to hold a boolean properly. People on the users list have been hitting this left and right with different symptoms.