In the vdbeaux.c source, the function


is not resetting p->readOnly when it encounters an OP_VUpdate opcode

is not setting p->bIsReader when it encounters an OP_VFilter opcode

Additionally, the frunction


is only checking p->bIsReader and omitting to check p->readOnly

even though the comment claims to check "if the program never started or if the 
SQL Statement does not read or write a database file".

These omissions conspire to make SQLite refrain from calling the xSync and 
xCommit entrypoints of the virtual table named in an UPDATE, DELETE or INSERT 

 Gunter Hick
Software Engineer
Scientific Games International GmbH
FN 157284 a, HG Wien
Klitschgasse 2-4, A-1130 Vienna, Austria
Tel: +43 1 80100 0

This communication (including any attachments) is intended for the use of the 
intended recipient(s) only and may contain information that is confidential, 
privileged or legally protected. Any unauthorized use or dissemination of this 
communication is strictly prohibited. If you have received this communication 
in error, please immediately notify the sender by return e-mail message and 
delete all copies of the original communication. Thank you for your cooperation.

sqlite-users mailing list

Reply via email to