Syntax Error in CRATE TABLE Statement when deploying with PostgreSQL

[JuergenSu]

Hello,

We want do deploy the autosleep service broker in our own CloudFoundry deployment. Unfortunatelly we do not have a mysql but only a postgesql 9.1. When we do so and startup the autowakeup-app it tries to create tables using liquibase. But this fails due to a SQL Syntax Error

Position: 135 [Failed SQL: CREATE TABLE public."SpaceEnrollerConfig" (id VARCHAR(255) NOT NULL, "excludeFromAutoEnrollment" BYTEA, "forcedAutoEnrollment" BOOLEAN(1) NOT NULL, "idleDuration" BYTEA, "organizationId" VARCHAR(255), "planId" VARCHAR(255), secret VARCHAR(255), "serviceDefinitionId" VARCHAR(255), "spaceId" VARCHAR(255), "ignoreRouteServiceError" BOOLEAN(1) DEFAULT FALSE NOT NULL, CONSTRAINT PK_SPACEENROLLERCONFIG PRIMARY KEY (id, "forcedAutoEnrollment"))] 

it seams to be somehow related to the BOOLEAN(1) notation. When Changing to BOOLEAN without the (1) it seems to work.

Could you please have a look at it.

kind regards
Juergen Sussner

[JuergenSu]

HI, it seems to be fixed with the latest liquibase version.

with this the generated SQL is

CREATE TABLE "public"."SpaceEnrollerConfig" ("id" VARCHAR(255) NOT NULL, "excludeFromAutoEnrollment" OID, "forcedAutoEnrollment" BOOLEAN NOT NULL, "idleDuration" OID, "organizationId" VARCHAR(255), "planId" VARCHAR(255), "secret" VARCHAR(255), "serviceDefinitionId" VARCHAR(255), "spaceId" VARCHAR(255), "ignoreRouteServiceError" BOOLEAN DEFAULT FALSE NOT NULL, CONSTRAINT "PK_SPACEENROLLERCONFIG" PRIMARY KEY ("id", "forcedAutoEnrollment"));

Liquibase version: 3.5.4

[gberche-orange]

thanks @JuergenSu for your report. The SpaceEnrollerConfig is related to the org enrollement feature that @pradyutsarma is working on. A pr to bump liquibase version would be most welcomed.