[sqlite] Trying to insert a new row in a table that has a column specifically set to the rowid data type will cause an error message like "may not be NULL"

[Rami Abughazaleh]

Hi.

Trying to insert a new row in a table that has a column specifically set to
the rowid data type will cause an error message like "value cannot be null".

CREATE TABLE [test] (
    [Id] ROWID NOT NULL,
    [Name] nvarchar(50) NOT NULL,
    [Value] nvarchar(256) NOT NULL
);

INSERT INTO test (Name, Value) VALUES ('test','test');

Error:
test.Id may not be NULL

Is this a known issue?

Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users