MySQL Forums
Forum List  »  Triggers

Re: trigger newbie: odd "fail" behavior?
Posted by: 7 reeds
Date: July 05, 2012 12:37PM

oops, I said in the initial post that I have not seen the odd behavior of 5 grouped inserts producing 6 resulting records. That was not true. I mis-stated that section. To recap:

I had 5 inserts grouped together and executed as a block. I expected table testA to have the 5 original vales. I expected testB to have 4 of the original values minus the "fail". I also expected to see a message about the missing SP.

Instead, the result was SIX records in testA: 'a', 'b', 'fail', 'fail', 'fail', 'fail'. testB had just two records: 'a', 'b'.

I have reproduced this with a grouped insert.

Options: ReplyQuote

Written By
July 05, 2012 12:13PM
Re: trigger newbie: odd "fail" behavior?
July 05, 2012 12:37PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.