Update query to set an inexistent field misses updating index entry for new field

[sanketsarang]

Index not getting updated on running an UPDATE SQL query to set a field that was not originally present on the record being updated.

Existing record
1: {'col1': 1, 'col2': 1}
2: {'col1': 2, 'col3': 2}

Run SQL Update
UPDATE test.test SET col3 = 1 WHERE col1 = 1

Updated Records
1: {'col1': 1, 'col2': 1, 'col3': 1}
2: {'col1': 2, 'col3': 2}

However the index entry for col3 for record #1 does not update. The entire column has to be reindexed after this operation.