# Update/select Table action fails in Transaction Groups

**URL:** <https://forum.inductiveautomation.com/t/update-select-table-action-fails-in-transaction-groups/11792>\
**Category:** Ignition\
**Created:** [June 8, 2016, 7:08pm UTC](https://forum.inductiveautomation.com/t/update-select-table-action-fails-in-transaction-groups/11792 "2016-06-08T19:08:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![JTurner](https://avatars.discourse-cdn.com/v4/letter/j/b38774/32.png) [@JTurner](https://forum.inductiveautomation.com/u/JTurner)\
**Post date:** [June 8, 2016, 7:08pm UTC](https://forum.inductiveautomation.com/t/update-select-table-action-fails-in-transaction-groups/11792/1 "2016-06-08T19:08:47Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [June 8, 2016, 7:32pm UTC](https://forum.inductiveautomation.com/t/update-select-table-action-fails-in-transaction-groups/11792/2 "2016-06-08T19:32:51Z")

</div>

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](http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html)