Issue 1733085: sqlite3 module trigger problem (original) (raw)

Created on 2007-06-07 21:36 by oinopion, last changed 2022-04-11 14:56 by admin. This issue is now closed.

Messages (7)
msg32246 - (view)	Author: Oinopion (oinopion)	Date: 2007-06-07 21:36
I and my team are building sqlite3 app and when used on Windows XP on Python 2.5.1 we get such an error: File "D:\studia\!bazy_projekt\svn2\src\muzzyk.py", line 39, in __init__ cur.executescript(scheme) OperationalError: near "NOT": syntax error while parsing http://muzzyk.googlecode.com/svn/trunk/src/scheme.sql Bug is about those triggers at the end of file. On linux or with pysqlite2 imported instead of sqlite3 everything is OK.
msg32247 - (view)	Author: Oinopion (oinopion)	Date: 2007-06-07 21:57
File Added: scheme.sql
msg32248 - (view)	Author: Neal Norwitz (nnorwitz) *	Date: 2007-06-08 04:05
Gerhard, could you take a look? I don't have windows.
msg32249 - (view)	Author: Gerhard Häring (ghaering) *	Date: 2007-06-08 08:19
That's because the SQLite3.DLL in Windows is at version 3.3.4, which doesn't support that language construct, yet. As a workaround, just download the SQLite3.DLL from http://sqlite.org and copy it over the one in your Python installation. The real solution for Python is to update the SQLite3.DLL. Martin, can we update the SQLite3.DLL for the 2.5 branch?
msg32250 - (view)	Author: Gerhard Häring (ghaering) *	Date: 2007-06-08 08:19
If so, I'll do the necessary steps of course.
msg32251 - (view)	Author: Martin v. Löwis (loewis) *	Date: 2007-06-08 17:15
I don't know whether it is acceptable for 2.5.x to provide new features through the underlying DLL. That's for the release manager to decide. Anthony?
msg57752 - (view)	Author: Gerhard Häring (ghaering) *	Date: 2007-11-22 10:48
We'll make sure there's an updated SQLite DLL in Python 2.6 and Python 3.0. It's not worth the effort for 2.5.2. There's always the workaround of users installing an updated DLL themselves.