Debian Codegraph @

mysql-test/suite/x/r/connection_autocommit_off.result

raw
1 SET GLOBAL autocommit = 0;
2 Verify ["SELECT @@autocommit as value" returns in "value" column, following value 0]
3 Verify ["SELECT autocommit FROM performance_schema.events_transactions_current JOIN performance_schema.threads USING(thread_id) WHERE processlist_id=connection_id()" returns in "autocommit" column, following value NO]
4 Verify ["SELECT state FROM performance_schema.events_transactions_current JOIN performance_schema.threads USING(thread_id) WHERE processlist_id=connection_id()" returns in "state" column, following value COMMITTED]
5 Mysqlx.Ok {
6 msg: "bye!"
7 }
8 ok
9 SET GLOBAL autocommit = DEFAULT;