D 2020-02-16T10:59:28.781
J foundin 1.1.1\s(latest\strunk)
J icomment Currently\sthe\sconfig\shandling\sfor\s-isolation\suses\sSQL\scommands\slike:\r\nSET\sTRANSACTION\sISOLATION\sLEVEL\sREAD\sSERIALIZABLE\r\nto\seffect\sthe\schange.\s\sThis\sonly\ssets\sthe\stransaction\sisolation\slevel\sfor\sthe\r\nnext\stransaction,\safter\swhich\sit\sreverts\sto\swhatever\sthe\scurrent\ssession\r\nisolation\slevel\sis.\s\sTo\sset\sthe\ssession\sisolation\slevel\sinstead\s(which\spersists\r\non\sthis\sconnection\suntil\schanged\sto\ssomething\selse),\sit\sshould\suse\r\nSET\sSESSION\sTRANSACTION\sISOLATION\sLEVEL\sSERIALIZABLE\r\ninstead.\r\n\r\nThis\sfixes\sthe\sfailure\son\stest\stdbc::mysql-19.11,\swhich\suses\r\nSELECT\s'',\sLCASE(REPLACE(@@TX_ISOLATION,\s'-',\s''))\r\nto\sinterrogate\sthe\scurrent\ssession\sisolation\slevel\s-\s@@tx_isolation\sreports\sthe\r\nsession\stransaction\sisolation\slevel,\sand\sthere\sis\sno\sway\sto\sreport\son\sthe\slevel\r\nset\sfor\sthe\snext\stransaction\s(which\sis\swhat\r\n"SET\sTRANSACTION\sISOLATION\sLEVEL\sfoo"\sdoes)
J login anonymous
J mimetype text/x-fossil-plain
J private_contact 54152f94cb1628c0c148b4b5708ace53216227b0
J severity Severe
J status Open
J title -isolation\sconfiguration\soption
J type Code_Defect
K 9bf0e3e2e71a07d57923a5b789cd78f8ac925fbc
U anonymous
Z 5cb14a3411a16c239564890646a00f65
