insert-rows (incorrectly) patches incomplete records

Description

When using sql/insert-rows with a dataset that contains incomplete rows the rows will be patched with values from the preceding rows. The behaviour to be expected is not documented.

I would expect insert-rows either only accepts complete rows. When accepting incomplete rows I would expect patching with nil-values instead of values from other rows.

Attached you find an example and the output when running in comments.

Environment

Postgres database on Debian machine

Status

Assignee

Sean Corfield

Reporter

Cees van Kemenade

Labels

Approval

None

Patch

None

Priority

Major
Configure