I have a transaction group that executes (every second) based on two key/value pairs. One pair is a string, and the other is a datetime object. The datetime tag value changes only once every few minutes. (Its format is
yyyy-MM-dd hh:mm:ss, if that’s relevant at all.)
When I have the group use just the string pair, it updates or inserts exactly how you’d expect. However, when I have the group use the datetime pair (either alone or in conjunction with the string pair), the group inserts a new row every execution, even if the datetime value hasn’t changed at all; I’ve yet to see it match and update when using the datetime pair.
Do the transaction group key/value pair updates just not work with datetime pairs? Or is there some subtle difference between what’s in the tag and what gets stored into the (MySQL) database by default that causes it to mismatch, and how can I address that?