[MRM-894] Archiva MySQL bit datatype incompatible

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.0, 1.0.1, 1.0.2, 1.1
• Component/s: system
• Environment: Centos 5.1 (2.6.18-53.e15); MySQL 5.0.22; Java 1.6
• Assignee: Unassigned
• Reporter: dandare100
• Created: 28/Jul/08 03:41
• Updated: 26/Feb/09 08:27
• Resolved: 21/Oct/08 09:15

Description

The tables are created with data-type BIT to represent boolean type fields.

Before MySQL 5.0.3, BIT was a synonym for TINYINT(1) which works fine.

However 5.0.3 and later versions of MySQL treat the BIT datatype differently.

This leads to problems with all the sql fields that are supposed to represent boolean values. It becomes a big mess.

An example is the column PERMANENT in a lot of the tables.
Also the FROM_PARENT and TRANSITIVE columns in ARCHIVA_DEPENDENCY.

When changing the column data-type in MySQL for existing data, the conversion of the actual data does not take place correctly because it was not inserted correctly in the first place.

Would it not be possible to change the data-types in the code to boolean or another data-type so that when the tables are created in MySQL they have columns that represent boolean values.

This also appears in Continuum.