[BUDI-7559] Postgres Update Row action step - incorrectly triggers required field validation

[melohagan]

Checklist

• I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker compose
  • Budibase Version: 2.10.10

Describe the bug
When using the Update Row action step in automations, required field validation is incorrectly triggered.

To Reproduce
Steps to reproduce the behavior:

1. Create a Postgres table with some not null constraint fields
2. Insert some rows
3. Add an automation with an Update Row step for the Postgres table
4. Leave those required fields blank in the automation step (i.e. should skip)
5. See that the validation is triggered on update, even though no attempt is being made to remove the required fields

Expected behavior
An Update Row action step in automations should not trigger validation for a required field if that field is left untouched.

Screenshots

Field is empty in the automation step, and should be ignored

Additional context

Having a quick look at the code, it appears that the update row step may need to pass in the allowEmpty flag.

res = validateJs.single(row[fieldName], constraints)