SAVE TO TABLE Does First Update, Then Insert
Last updated on AUGUST 22, 2016
Applies to:Oracle Utilities Meter Data Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
The SAVE TO TABLE statement first tries to update the record and if that fails it tries to insert the record. This is inconsistent with the Rules Language documentation which states that the SAVE TO TABLE statement first tries to add the record and if that fails it tries to update the record.
Steps to Reproduce
1. Enable SQL Logging by placing lsdb.cfg.xml in the \LODESTAR\cfg directory.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms