Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
How are Update statements tested? Does it actually do the update on the database? Does it start a transaction then end it?
해결 방안
To test Update statements, SQL Optimizer will run the statement and then rollback the transaction so it does not save it. The Update never takes effect.