Setting this back to triaged because I disagree with the fix. Both name and flavorid are unique string keys, so you have just swapped one for the other. Now get_all_flavors will only return the latest version of a deleted flavor with the same flavorid. If you really want all copies the key needs to be 'id' which is autoinc and unique across all rows.
Setting this back to triaged because I disagree with the fix. Both name and flavorid are unique string keys, so you have just swapped one for the other. Now get_all_flavors will only return the latest version of a deleted flavor with the same flavorid. If you really want all copies the key needs to be 'id' which is autoinc and unique across all rows.