All We have just noticed that when you issue the same delete statement twice, the delete statement reports rows deleted the second time, when there are in fact no rows available to delete.
I have created a test case and attached it with a log of the results I am seeing. Note specifically in the attached log:- Line 33 - first delete Line 39 - shows delete was successful as count(*) returns no rows for the key deleted. Line 53 - second delete reports 1 row affected Michael McAllister Staff Data Warehouse Engineer | Decision Systems [email protected]<mailto:[email protected]> | C: 512.423.7447 | skype: michael.mcallister.ha<mailto:[email protected]> | webex: https://h.a/mikewebex
This electronic communication (including any attachment) is confidential. If you are not an intended recipient of this communication, please be advised that any disclosure, dissemination, distribution, copying or other use of this communication or any attachment is strictly prohibited. If you have received this communication in error, please notify the sender immediately by reply e-mail and promptly destroy all electronic and printed copies of this communication and any attachment. |
delete_test_case.sql
Description: delete_test_case.sql
delete_test_case.log
Description: delete_test_case.log
