Re: [sqlite] 3.1.3 on Windows with python apsw: malformed database schema - near "AUTOINCREMENT": syntax error

[Scott Chapman]

I'm not able to duplicate this on Linux with fresh compiles of everything.  
That leads me to believe the binary I downloaded for Windows is not built on 
3.1.3 after all.

Scott

On Saturday 05 March 2005 06:01 pm, Scott Chapman wrote:
> Windows XP Pro, Python 2.3.4, sqlite 3.1.3
> I'm getting this wierd error from sqlite.  It only happens when I access
> this database with Python/APSW.  I can access it with sqlite and
> sqlite3explorer just fine.
>
>  >sqlite3 test1.db3
>
> SQLite version 3.1.3
> Enter ".help" for instructions
> sqlite> create table test (id INTEGER PRIMARY KEY AUTOINCREMENT,name text);
> sqlite> .quit
>
> C:\Documents and Settings\Scott Chapman\My
> Documents\development\misc\sqlite>python apsw_pragma.py test1.db3
> Traceback (most recent call last):
>   File "apsw_pragma.py", line 37, in ?
>     dosql(sql)
>   File "apsw_pragma.py", line 19, in dosql
>     cursor.execute(query)
> apsw.AbortError: AbortError: malformed database schema - near
> "AUTOINCREMENT": syntax error
>
> Cordially,
> Scott