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.
|Assignee||Sean Corfield [ seancorfield ]|
|Status||Open [ 1 ]||Resolved [ 5 ]|
|Resolution||Completed [ 1 ]|
|Status||Resolved [ 5 ]||Closed [ 6 ]|