Incorrect R script update behaviour

[georgeamason]

• info returns:

  {
  "MigrationType": "Repeatable",
  "Version": null,
  "Description": "Create_managers_view",
  "Type": "SQL",
  "Checksum": "04e9bb47e8d61188700c2794d9392115",
  "InstalledOn": "2024-01-15T23:00:28.593Z",
  "State": "Missing"
  },
  {
  "MigrationType": "Repeatable",
  "Version": null,
  "Description": "Create_managers_view",
  "Type": "SQL",
  "Checksum": "4365bcc725ceb759b81c7be526b57845",
  "InstalledOn": null,
  "State": "Pending"
  }

[georgeamason]

Flyway handles this scenario as such: