SQLite Forum

CHECK violation during table definition ignored, normal or bug?
Login
```
create table t(
  id integer primary key,
  s text not null default 'abc' check(length(s) < 3) --no error (bug?)
  );

insert into t(id) values(1); --expected error as default value violates CHECK
```