1 2--source include/not_embedded.inc 3 4--echo # 5--echo # WL#5968: Implement START TRANSACTION READ (WRITE|ONLY); 6--echo # 7 8--echo # 9--echo # Test9: The --transaction-read-only startup option. 10 11--echo # Check that the option was set by the .opt file. 12SELECT @@tx_read_only; 13 14--echo # Also for new connections. Switching to con1 15connect (con1, localhost, root); 16SELECT @@tx_read_only; 17SET SESSION TRANSACTION READ WRITE; 18SELECT @@tx_read_only; 19disconnect con1; 20--source include/wait_until_disconnected.inc 21 22--echo # Connection default 23connection default; 24SELECT @@tx_read_only; 25 26 27--echo # 28--echo # Test 10: SET TRANSACTION / START TRANSACTION + implicit commit. 29 30SET SESSION TRANSACTION READ WRITE; 31--disable_ps_protocol 32SET TRANSACTION READ ONLY; 33--echo # Since DDL does implicit commit before starting, SET TRANSACTION 34--echo # will have no effect because the "next" transaction will already 35--echo # be over before the DDL statement starts. 36CREATE TABLE t1 (a INT); 37 38START TRANSACTION READ ONLY; 39--echo # The same happens with START TRANSACTION 40DROP TABLE t1; 41--enable_ps_protocol 42