Uploaded image for project: 'Archiva'
  1. Archiva
  2. MRM-894

Archiva MySQL bit datatype incompatible

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 1.0, 1.0.1, 1.0.2, 1.1
    • Fix Version/s: None
    • Component/s: system
    • Labels:
      None
    • Environment:
      Centos 5.1 (2.6.18-53.e15)
      MySQL 5.0.22
      Java 1.6

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              dandare100 dandare100
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: