mariadb/mysql-test/suite/galera/r/galera_transaction_read_only.result
2015-07-14 16:05:29 -04:00

21 lines
350 B
Text

CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
COMMIT;
wsrep_last_committed_diff
1
START TRANSACTION READ ONLY;
SELECT COUNT(*) = 0 FROM t1;
COUNT(*) = 0
1
COMMIT;
wsrep_last_committed_diff
1
START TRANSACTION;
SELECT COUNT(*) = 0 FROM t1;
COUNT(*) = 0
1
COMMIT;
wsrep_last_committed_diff
1
DROP TABLE t1;