Re: Transaction isolation

Martin Jenkins <pysqlite-Vfh7fEhEWOlaa/[email protected]>
Newsgroups gmane.comp.python.db.pysqlite.user
Organization XQP Ltd
Message-ID <[email protected]> 
Gerhard Häring wrote:
>> Traceback (most recent call last):
>>     File "<interactive input>", line 1, in <module>
>> OperationalError: SQL logic error or missing database
>>   >>>
> 
> That's why SQLite becomes so confused here. The input doesn't make any
> sense for executemany().

Actually, it's a bug in the wrapper.

SQLite (the database) correctly reports a "nested transaction" error but 
the pysqlite wrapper does not. IIRC this is because the wrapper does not 
reset the statement before reading the error code.

Martin
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.