I defined the following table:
CREATE TABLE weights(
float REAL,
CONSTRAINT float CHECK(TYPEOF(float) = "real")
);
I try the following insert:
INSERT INTO testing
(float)
VALUES
(0)
But this gives:
CHECK constraint failed: float
When I try this insert:
INSERT INTO testing
(float)
VALUES
(0.0)
I get:
Query executed successfully
But should in the first case the 0 not be cast to a 0.0?
I do this in DBBrowser which uses 3.15.2.
--
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
