Re: NOLOCK in MySQL VIEW
Quote
I have this idea to have this setting at the beginning of the VIEW declaration and SET back to REPEATABLE READ at the end. However, I am not sure if this is going to work.
It won't.
Transaction Isolation applies to a "living" connection, not to a static definition like a View.
Regards, Phill W.
Subject
Written By
Posted
November 07, 2022 07:38PM
Re: NOLOCK in MySQL VIEW
November 08, 2022 05:12AM
November 08, 2022 11:40PM
November 09, 2022 06:23AM
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.