[MDEV-31412] Create sequence causing implicit commit Created: 2023-06-06 Updated: 2023-07-12 Resolved: 2023-07-12 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Documentation, Sequences |
| Affects Version/s: | 10.6 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Seppo Jaakola | Assignee: | Ian Gilfillan |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
CREATE SEQUENCE and
Same happens if the sequence is created like: DBUG traces show that for "create sequence" execution, in mysql_execute_command() the test for implicit commit is carried out by: stmt_causes_implicit_commit(), which returns true and the implicit commit follows. So it looks like the implicit commit was done on purpose for this case. But then, "create sequence" statement should be added to the list of statements causing implicit commit.
In sequence_insert() implicit commit is called unconditionally. This looks like a bug. |
| Comments |
| Comment by Daniel Black [ 2023-06-06 ] |
|
Most DDL is an implicit commit - https://mariadb.com/kb/en/sql-statements-that-cause-an-implicit-commit/ I just added sequences to that page. |