Skip to content

Inconsistent formatting in ALTER TABLE statement #105

@Huliiiiii

Description

@Huliiiiii

Input

ALTER TABLE "public"."event"
  DROP CONSTRAINT "validate_date",
  ADD CONSTRAINT "validate_date" CHECK (
    end_date IS NULL
    OR (start_date IS NOT NULL AND end_date > start_date)
  );

Actual Output

ALTER TABLE
  "public"."event"
  DROP CONSTRAINT "validate_date",
ADD
  CONSTRAINT "validate_date" CHECK (
    end_date IS NULL
    OR (
      start_date IS NOT NULL
      AND end_date > start_date
    )
  );

Expected Output

ALTER TABLE "public"."event"
  DROP CONSTRAINT "validate_date",
  ADD CONSTRAINT "validate_date" CHECK (
    end_date IS NULL
    OR (
      start_date IS NOT NULL
      AND end_date > start_date
    )
  );
-- or
ALTER TABLE
  "public"."event"
  DROP CONSTRAINT "validate_date",
  ADD CONSTRAINT "validate_date" 
    CHECK (
      end_date IS NULL
      OR (
        start_date IS NOT NULL
        AND end_date > start_date
      )
    );

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions