[New-bugs-announce] [issue28518] execute("begin immediate") throwing OperationalError

[Florian Schulze]

New submission from Florian Schulze:

Using:

conn = sqlite3.connect(':memory:', isolation_level='IMMEDIATE')
conn.execute('begin immediate')

Throws:

sqlite3.OperationalError: cannot start a transaction within a transaction

This didn't happen in previous versions and the conn.in_transaction attribute is False right before the call to execute, so this situation doesn't seem to be detectable upfront for backward compatibility.

----------
components: Library (Lib)
messages: 279301
nosy: fschulze
priority: normal
severity: normal
status: open
title: execute("begin immediate") throwing OperationalError
type: behavior
versions: Python 3.6

_______________________________________
Python tracker <report at bugs.python.org>
<http://bugs.python.org/issue28518>
_______________________________________