| 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; |