As a sort of follow on to this, we have switched to using a place holder value, but now we are running into a new issue.
One of our scenarios is we write data that we later update (same FID, just certain attributes have changed). When we update an attribute that is indexed we end up being able to filter on both the new and the old value as if the old attribute index was not removed when the value was changed.
As a simple example:
-I worked up an feature with 3 attributes: geom, date and index_val. The index_val has a full index on it.
-I write a new record and put 'ABC' into index_val.
-I then grab that record via the FID and re-write it with index_val 'XYZ'. Nothing else about the data changes (same fid, date and geom).
-If I run a filter on the FID I only get 1 record with the XYZ as the index_vale
-if I query index_val = 'XYZ' it returns data as expected.
-But if I query index_val = 'ABC' it also still returns data, which with the record having been updated I would not have expected it to do
Any thoughts on how to handle this scenario or if there is another step I need to take to remove attribute indexes?
Thanks,
Brad