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