so this error is happening to older records in mysql (created before we recently updated Datahub) - when a new schemaMetadata aspect is emitted, the existing version should have been copied to a new record. (calling this case 1)
For newly created datasets, it behaves correctly -> the old aspect is copied to a new record and version 0 is updated (case 2)
looking at the query logs, it appears that mysql is being sent the correct set of instructions each time, yet the outcome is different for the 2 cases.
for case 1, after i emitted the aspect, i only have v0 for schemaMetadata
for case 2, i have both v0 and v1
any ideas?