Inconsistent data type referenced by ddl script

Steps to reproduce

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,

Activity

Show:
David Horwitz
April 23, 2013, 2:19 PM

Testing indicates the pgsql is the correct one

Greg Logan
April 23, 2013, 2:46 PM

I don't have any outstanding merges that touch the DB or ddl scripts, so I don't think this is a merge issue in 1.4.x at least.

David Horwitz
April 24, 2013, 11:21 AM

Made the type consistent in the script (int is the correct type)

dhorwitz@david-horwitz:~/matterhorn/matterhorn-trunk/docs/scripts/ddl> grep service_state *
mysql5.sql: service_state int NOT NULL,
mysql5.sql:CREATE INDEX IX_mh_service_registration_service_state ON mh_service_registration (service_state);
postgres84.sql: "service_state" integer NOT NULL,
postgres84.sql:CREATE INDEX "IX_mh_service_registration_service_state" ON "mh_service_registration" ("service_state");

Greg Logan
May 15, 2013, 8:46 PM

Merged into 1.4.x with rev 14646.

Assignee

David Horwitz

Reporter

David Horwitz

Severity

Non Functioning

Tags (folksonomy)

None

Components

Fix versions

Affects versions

Priority

Blocker
Configure