Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
21.06.17, 22.08.14, 23.02.11, 23.08.7, 24.02.3, 24.08.0
-
None
Description
If readwritesplit is configured with strict_multi_stmt or strict_sp_calls and a SET tx_isolation='repeatable-read' is executed, the effects of strict_multi_stmt and strict_sp_calls are canceled out. The following test case should return the same server_id value as long as the session is alive but it may return a server_id from a replica.
delimiter $$ ;
|
SELECT @@server_id AS 'before multistmt' $$ |
DO 1; DO 2; $$
|
SELECT @@server_id AS 'after multistmt' $$ |
SET tx_isolation='read-committed' $$ |
SELECT @@server_id AS 'after tx_isolation' $$ |