[sqlite] Should the INTEGER not be cast to a REAL

[Cecil Westerhof]

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