➜
This issue tracker has been migrated to GitHub,
and is currently read-only.
For more information,
see the GitHub FAQs in the Python's Developer Guide.
Created on 2007-06-07 21:36 by oinopion, last changed 2022-04-11 14:56 by admin. This issue is now closed.
| Files | ||||
|---|---|---|---|---|
| File name | Uploaded | Description | Edit | |
| scheme.sql | oinopion, 2007-06-07 21:50 | SQL cousing trouble | ||
| 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. |
|||
| History | |||
|---|---|---|---|
| Date | User | Action | Args |
| 2022-04-11 14:56:24 | admin | set | github: 45053 |
| 2007-11-22 10:48:02 | ghaering | set | status: open -> closed resolution: later messages: + msg57752 |
| 2007-06-07 21:36:53 | oinopion | create | |