SQLite Why FOREIGN KEY vseravno allows to interpose a nonexistent field of other table?

Question

SQL

CREATE TABLE category (
  name TEXT NOT NULL
);

INSERT INTO category(name) VALUES
  ('food')	
;

CREATE TABLE item (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  category TEXT NOT NULL,
  FOREIGN KEY (category) REFERENCES category(name)
);

INSERT INTO item(name, category) VALUES
  ('cookie', 'ololo') -- ok. no error
;

Answer 1

Foreign keys in sqlite are disabled by default, they must be manually enabled. Everything is written
here https://www.sqlite.org/foreignkeys.html#fk_enable