On 5/27/2017 9:47 AM, Aflah Bhari wrote:
I'm using SQLITE version 3.16.0 on macOS Sierra 10.12.4. I'm experiencing a
unique bug where if I put in an primary key constraint with underscores
then the primary key does not auto increment when I insert values.
*For example:*
CREATE TABLE sensor_status(status_id INTEGER *PRIMARY_KEY*, status text
NOT_NULL UNIQUE);
Here, INTEGER PRIMARY_KEY is the type. SQLite accepts pretty much any sequence
of characters as the column type - e.g.
create table t(col FOO_BAR BAZ);
For details, see http://sqlite.org/datatype3.html
I'm not sure what the implications of this are on other constraints such as
NOT_NULL
Ain't no such constraint.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users