[issue8145] Documentation about sqlite3 isolation_level

[Laszlo Nagy]

Laszlo Nagy <nagy...@gmail.com> added the comment:

2010/7/11 Terry J. Reedy <rep...@bugs.python.org>

>
> Terry J. Reedy <tjre...@udel.edu> added the comment:
>
> If the content of the patch is correct, it looks ready to apply, with only
> a touch of editing. Do we have a resident expert of sqlite3? Or Laszlo, do
> you have a reference for the statements made?
>

Sorry, the only reference I have is that mailing list thread (
http://mail.python.org/pipermail/python-list/2010-March/1239374.html ).

There you can find an example with SQL statements, showing the problem.

Ryan Kelly wrote the following:

<quote>
I have a theory, based on a quick perusal of the sqlite3 bindings
source.

The bindings think that "SAVEPOINT sp1" is a "non-DML, non-query"
statement. So when isolation_level is something other than None, this
statement implicitly commits the current transaction and throws away
your savepoints!
</quote>

So the problem is with the sqlite binding code, not sqlite itself. I'm not
an expert in C, so I'm not sure I can help more.

Thanks,

   Laszlo

----------
Added file: http://bugs.python.org/file17940/unnamed

_______________________________________
Python tracker <rep...@bugs.python.org>
<http://bugs.python.org/issue8145>
_______________________________________
<br><br><div class="gmail_quote">2010/7/11 Terry J. Reedy <span 
dir="ltr">&lt;<a 
href="mailto:rep...@bugs.python.org";>rep...@bugs.python.org</a>&gt;</span><br><blockquote
 class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid 
rgb(204, 204, 204); padding-left: 1ex;">
<br>
Terry J. Reedy &lt;<a href="mailto:tjre...@udel.edu";>tjre...@udel.edu</a>&gt; 
added the comment:<br>
<br>
If the content of the patch is correct, it looks ready to apply, with only a 
touch of editing. Do we have a resident expert of sqlite3? Or Laszlo, do you 
have a reference for the statements made?<br></blockquote><br>Sorry, the only 
reference I have is that mailing list thread ( <a 
href="http://mail.python.org/pipermail/python-list/2010-March/1239374.html";>http://mail.python.org/pipermail/python-list/2010-March/1239374.html</a>
 ).<br>
<br>There you can find an example with SQL statements, showing the problem. 
<br><br>Ryan Kelly wrote the following:<br><br>&lt;quote&gt;<br>
I have a theory, based on a quick perusal of the sqlite3 bindings<br>
source.<br>
<br>
The bindings think that &quot;SAVEPOINT sp1&quot; is a &quot;non-DML, 
non-query&quot;<br>
statement. So when isolation_level is something other than None, this<br>
statement implicitly commits the current transaction and throws away<br>
your savepoints!<br>
&lt;/quote&gt;<br><br>So the problem is with the sqlite binding code, not 
sqlite itself. I&#39;m not an expert in C, so I&#39;m not sure I can help 
more.<br><br>Thanks,<br><br>   Laszlo<br><br></div>

_______________________________________________
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com