Why doesn't the ForeignKey constraint work in SQLite?

Question

SQLite

I can not understand why the restriction on ForeignKey in SQLite does not work. My schema:

CREATE TABLE "address"(
  "id" Integer NOT NULL PRIMARY KEY,
  "email" Text,
CONSTRAINT "unique_id" UNIQUE ( "id" ) );

CREATE TABLE "mans"(
  "id" Integer NOT NULL PRIMARY KEY,
  "mail_id" Integer,
  "name" Text,
  "age" Integer,
  CONSTRAINT "mans_address_NO ACTION_NO ACTION_mail_id_id_0" FOREIGN KEY ( "mail_id" ) REFERENCES "address"( "id" )
 );

However, the following queries work:

INSERT INTO "address" ( "email", "id")  VALUES ( '[email protected]', 4 );

INSERT INTO "mans" ("id", "mail_id", "name") VALUES ( 1 , 2 , 'mike' );