Two triggers, one event
Two BEFORE INSERT triggers exist on the same table. One uppercases
code, the other rejects rows whose code is not in a reference table
holding uppercase values only.
Rows with lowercase codes are being rejected intermittently across environments. What is the most likely cause?