Update/select Table action fails in Transaction Groups

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.

MySQL on Linux is case sensitive by default since the databases are usually folders in the file system.
You can read up on it here

dev.mysql.com/doc/refman/5.0/en/ … ivity.html