What, exactly, is a "misfeature" and where is this documentation?
The problem doesn't seem to occur on sqlite3 proper. Rather, it seems
to only occur when using the python module.
[EMAIL PROTECTED]:~$ sqlite3 testdb.sqlite
SQLite version 3.5.4
Enter ".help" for instructions
sqlite> CREATE TABLE users(id INTEGER PRIMARY KEY, host VARCHAR(16)
NOT NULL, name VARCHAR(16) NOT NULL);
sqlite> INSERT INTO users (host, name) VALUES ("localhost", "monty");
sqlite> DROP TABLE users;
sqlite> CREATE TABLE users(id INTEGER PRIMARY KEY, host VARCHAR(16)
NOT NULL, name VARCHAR(16) NOT NULL);
sqlite> INSERT INTO users (host, name) VALUES (null, "python");
SQL error: users.host may not be NULL
sqlite>
On Feb 15, 10:14 am, Michael Schlenker <[EMAIL PROTECTED]> wrote:
> Michael Bayer schrieb:> no idea. below is a revised version, where the main
> revision is that
> > theres no SQLAlchemy ;). So I think you should submit this to the bug
> > tracker onwww.sqlite.org.
>
> > Actually this is sorta interesting since it would impact our own unit
> > tests regarding sqlite as well (which is why we run them with mysql
> > and postgres as part of our build as well).
>
> This is a known misfeature of sqlite..., its even documented in the CREATE
> TABLE manpage for sqlite.
>
> Michael
>
> --
> Michael Schlenker
> Software Engineer
>
> CONTACT Software GmbH Tel.: +49 (421) 20153-80
> Wiener Straße 1-3 Fax: +49 (421) 20153-41
> 28359 Bremenhttp://www.contact.de/ E-Mail: [EMAIL PROTECTED]
>
> Sitz der Gesellschaft: Bremen
> Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe
> Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
