dolthub / dolthub/dolt

`@@dolt_transaction_commit` not persisted

Open
#7,187 0 comments 0 reactions 1 assignee Claimed by @zachmu View on GitHub
bug configuration
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 5h
Merged PRs (30d)
108

Description

```
% dolt sql
# Welcome to the DoltSQL shell.
# Statements must be terminated with ';'.
# "exit" or "quit" (or Ctrl-D) to exit.
persist> set @@persist.dolt_transaction_commit=1;
persist> set @@global.dolt_transaction_commit=1;
persist> exit
Bye
zachmu@zachmu-thinkpad:dolt-scratch/test/persist% dolt sql
# Welcome to the DoltSQL shell.
# Statements must be terminated with ';'.
# "exit" or "quit" (or Ctrl-D) to exit.
persist> select @@dolt_transaction_commit
-> ;
+-----------------------------------+
| @@SESSION.dolt_transaction_commit |
+-----------------------------------+
| 0 |
+-----------------------------------+
1 row in set (0.00 sec)
```

This error message is also bad:

```
select @@persist.dolt_transaction_commit=1;
unknown scope `GLOBAL, PERSIST` on system variable `dolt_transaction_commit`
```

MySQL error is more reasonable:

```
> select @@persist.max_connections;
ERROR 1193 (HY000): Unknown system variable 'persist.max_connections'
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.