The documentation states that without the GLOBAL or SESSION keyword, the isolation level will be valid for the next transaction and will be reverted to the session default after the transaction was commited.
With autocommit enabled, what is the scope of an transaction isolation level for a SELECT statement?
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
SELECT * FROM mytable WHERE id = 1;
Is a SELECT statement a complete transaction, meaning the isolation level will be reverted to session default after the SELECT was executed, or does a SELECT somehow not represent its own transaction, meaning that the isolation level will not be restored after a SELECT statement?
SELECT
by itself, without knowing how the resultset will be used.