Skip to content

Increase limit of body fields for evidence

What does this MR do?

This MR increases the limit of the body field for Vulnerability Finding Evidences. 2048 is a guidance, and not a hard rule, so doubling the allowed field value. This is part of MR #267489

Screenshots (strongly suggested)

Does this MR meet the acceptance criteria?

Conformity

Availability and Testing

Database

Migration

== 20210617200551 IncreaseEvidenceBodyLimit: migrating ========================
-- execute("ALTER TABLE vulnerability_finding_evidence_requests\nDROP CONSTRAINT IF EXISTS check_7e37f2d01a\n")
   -> 0.0030s
-- execute("ALTER TABLE vulnerability_finding_evidence_responses\nDROP CONSTRAINT IF EXISTS check_76bac0c32b\n")
   -> 0.0010s
-- transaction_open?()
   -> 0.0000s
-- current_schema()
   -> 0.0002s
-- execute("ALTER TABLE vulnerability_finding_evidence_requests\nADD CONSTRAINT check_7e37f2d01a\nCHECK ( char_length(body) <= 4096 )\nNOT VALID;\n")
   -> 0.0019s
-- current_schema()
   -> 0.0002s
-- execute("ALTER TABLE vulnerability_finding_evidence_requests VALIDATE CONSTRAINT check_7e37f2d01a;")
   -> 0.0039s
-- transaction_open?()
   -> 0.0000s
-- current_schema()
   -> 0.0002s
-- execute("ALTER TABLE vulnerability_finding_evidence_responses\nADD CONSTRAINT check_76bac0c32b\nCHECK ( char_length(body) <= 4096 )\nNOT VALID;\n")
   -> 0.0010s
-- current_schema()
   -> 0.0002s
-- execute("ALTER TABLE vulnerability_finding_evidence_responses VALIDATE CONSTRAINT check_76bac0c32b;")
   -> 0.0030s
== 20210617200551 IncreaseEvidenceBodyLimit: migrated (0.0391s) ===============

Rollback

== 20210617200551 IncreaseEvidenceBodyLimit: reverting ========================
-- execute("ALTER TABLE vulnerability_finding_evidence_requests\nDROP CONSTRAINT IF EXISTS check_7e37f2d01a\n")
   -> 0.0015s
-- execute("ALTER TABLE vulnerability_finding_evidence_responses\nDROP CONSTRAINT IF EXISTS check_76bac0c32b\n")
   -> 0.0008s
-- transaction_open?()
   -> 0.0000s
-- current_schema()
   -> 0.0002s
-- execute("ALTER TABLE vulnerability_finding_evidence_requests\nADD CONSTRAINT check_7e37f2d01a\nCHECK ( char_length(body) <= 2048 )\nNOT VALID;\n")
   -> 0.0013s
-- current_schema()
   -> 0.0002s
-- execute("SET statement_timeout TO 0")
   -> 0.0005s
-- execute("ALTER TABLE vulnerability_finding_evidence_requests VALIDATE CONSTRAINT check_7e37f2d01a;")
   -> 0.0010s
-- execute("RESET ALL")
   -> 0.0006s
-- transaction_open?()
   -> 0.0000s
-- current_schema()
   -> 0.0002s
-- execute("ALTER TABLE vulnerability_finding_evidence_responses\nADD CONSTRAINT check_76bac0c32b\nCHECK ( char_length(body) <= 2048 )\nNOT VALID;\n")
   -> 0.0011s
-- current_schema()
   -> 0.0002s
-- execute("ALTER TABLE vulnerability_finding_evidence_responses VALIDATE CONSTRAINT check_76bac0c32b;")
   -> 0.0011s
== 20210617200551 IncreaseEvidenceBodyLimit: reverted (0.0333s) ===============
Edited by Jonathan Schafer

Merge request reports