Uploaded image for project: 'Opencast'
  1. MH-9595

Inconsistent data type referenced by ddl script

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed and reviewed
    • Affects versions: 1.4.0
    • Fix versions: 1.4.0
    • Components: Release Management
    • Labels:
      None
    • Severity:
      Non Functioning
    • Steps to reproduce:
      Hide
      The mysql script:

      CREATE TABLE mh_service_registration (
        id BIGINT NOT NULL,
        path VARCHAR(255) NOT NULL,
        job_producer TINYINT(1) DEFAULT 0 NOT NULL,
        service_type VARCHAR(255) NOT NULL,
        online TINYINT(1) DEFAULT 1 NOT NULL,
        active TINYINT(1) DEFAULT 1 NOT NULL,
        online_from DATETIME,
        service_state VARCHAR(32) NOT NULL,

      The pgsql script:
      CREATE TABLE "mh_service_registration" (
        "id" bigint NOT NULL,
        "path" character varying(255) NOT NULL,
        "job_producer" boolean NOT NULL,
        "service_type" character varying(255) NOT NULL,
        "online" boolean NOT NULL DEFAULT TRUE,
        "active" boolean NOT NULL DEFAULT TRUE,
        "online_from" timestamp,
        "service_state" integer NOT NULL,
      Show
      The mysql script: CREATE TABLE mh_service_registration (   id BIGINT NOT NULL,   path VARCHAR(255) NOT NULL,   job_producer TINYINT(1) DEFAULT 0 NOT NULL,   service_type VARCHAR(255) NOT NULL,   online TINYINT(1) DEFAULT 1 NOT NULL,   active TINYINT(1) DEFAULT 1 NOT NULL,   online_from DATETIME,   service_state VARCHAR(32) NOT NULL, The pgsql script: CREATE TABLE "mh_service_registration" (   "id" bigint NOT NULL,   "path" character varying(255) NOT NULL,   "job_producer" boolean NOT NULL,   "service_type" character varying(255) NOT NULL,   "online" boolean NOT NULL DEFAULT TRUE,   "active" boolean NOT NULL DEFAULT TRUE,   "online_from" timestamp,   "service_state" integer NOT NULL,

      TestRail: Results

        Attachments

          Activity

            People

            • Assignee:
              dhorwitz David Horwitz
              Reporter:
              dhorwitz David Horwitz
            • Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                TestRail: Cases