How to add new column when using MergeAsync?

[flambert860]

How can I change the schema on a table when using the merge?

schema has columns key, a & b
schema2 has columns key, a, b & c
When executing the insert and after merge I do not have the column c

await table.InsertAsync([recordBatchBuilder.Build()], schema, insertOptions, CancellationToken.None);
await table.MergeAsync(query, [recordBatchBuilder2.Build()], schema2, CancellationToken.None);

But I have noticed that if I do the following it works:

await table.InsertAsync([recordBatchBuilder.Build()], schema, insertOptions, CancellationToken.None);
await table.InsertAsync([emptyRecordBatchBuilder.Build()], schema2, insertOptions, CancellationToken.None);
await table.MergeAsync(query, [recordBatchBuilder2.Build()], schema2, CancellationToken.None);

[mightyshazam]

@flambert860 Is your merge query performing an insert with the new columns or an update? Merging also depends on datafusion, so it may just ignore the extra columns when creating the insert statement.