Are checks constraints supported?

[ricardo8990]

What would you like to be added or enhanced

I haven't try it yet, but I can't find in the docs if CHECK CONSTRAINT is supported.

Why is this needed

Suppose I want to have a table to validate that a certain field is always bigger than 0. For instance an account model where the balance should always be bigger or equal 0. Is it something like this supported?

CREATE TABLE IF NOT EXISTS accounts (
    id INTEGER,
    name VARCHAR(100),
    balance INTEGER
    CHECK (balance >= 0)
);

Thanks in advance

[jeroiraz]

What would you like to be added or enhanced

I haven't try it yet, but I can't find in the docs if CHECK CONSTRAINT is supported.

Why is this needed

Suppose I want to have a table to validate that a certain field is always bigger than 0. For instance an account model where the balance should always be bigger or equal 0. Is it something like this supported?

CREATE TABLE IF NOT EXISTS accounts (

    id INTEGER,

    name VARCHAR(100),

    balance INTEGER

    CHECK (balance >= 0)

);

Thanks in advance

Hi @ricardo8990, thanks for reaching out. Constraint checking are not yet implemented but it could be added.

Would you mind opening a feature request for it?