[ python-Bugs-1733085 ] sqlite3 module trigger problem

[SourceForge.net]

Bugs item #1733085, was opened at 2007-06-07 23:36
Message generated for change (Comment added) made by ghaering
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1733085&group_id=5470

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Extension Modules
Group: Platform-specific
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Oinopion (oinopion)
>Assigned to: Martin v. Löwis (loewis)
Summary: sqlite3 module trigger problem

Initial Comment:
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.



----------------------------------------------------------------------

>Comment By: Gerhard Häring (ghaering)
Date: 2007-06-08 10:19

Message:
Logged In: YES 
user_id=163326
Originator: NO

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?

----------------------------------------------------------------------

Comment By: Neal Norwitz (nnorwitz)
Date: 2007-06-08 06:05

Message:
Logged In: YES 
user_id=33168
Originator: NO

Gerhard, could you take a look?  I don't have windows.

----------------------------------------------------------------------

Comment By: Oinopion (oinopion)
Date: 2007-06-07 23:57

Message:
Logged In: YES 
user_id=1282560
Originator: YES

File Added: scheme.sql

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1733085&group_id=5470