Hi all, I have a question about data type BIGINT: from docs
(http://www.sqlite.org/datatype3.html) I understand that INTEGER and
BIGINT results in the same affinity (INTEGER), so datatypes are same, is
it correct?
Unfortunately if I create a table with a field "Id BIGINT PRIMARY KEY
AUTOINCREMENT" I got the error "AUTOINCREMENT is only allowed on an
INTEGER PRIMARY KEY"
from those lines:
#ifndef SQLITE_OMIT_AUTOINCREMENT
sqlite3ErrorMsg(pParse, "AUTOINCREMENT is only allowed on an "
"INTEGER PRIMARY KEY");
#endif
Is there a way to sue AUTOINCREMENT with BIGINT? what's the reason for
this check?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
