Setup: Ignition 7.8.2, Standard transaction group, MySQL server 5.7, Ubuntu Linux gateway
“Table action” section set to “insert new row” succeeds
“Table action” section set to “update/select”->“key/value pairs” fails
I noticed that when I tried update/select, the query that resulted was using an all-caps version of the table name. When I changed my table name to that all-caps table name, update/select started working. I don’t know if this is mentioned anywhere else or is working as designed, but this looks like a possible bug.