jsc42 wrote:
I have not found any specific answer for MySql
Interesting. I couldn't either. I know it happens in C++ so I attempted to find that expression ("short circuit") in the standard and as far as I can tell it does not exist. I used the actual book to look it up. So for that (C++) it is expressed like the following "The operators && and || will not evaluate their second argument unless doing so is necessary" For C it is expressed as the following "Expressions connected by && or || are evaluated left to right, and evaluation stops as soon as the truth of falsehood of the result is known" Then I looked for that terminology in MySQL docs (8) and found nothing on the page that defines AND and OR that would suggest that. I also attempted the same for PL/SQL and also found nothing.