There are more similar issues, like disabling foreign key constraints by default "for compatibility reasons". Makes me wonder if there was a time when SQLite supported foreign key syntax, but didn't actually implement the functionality.

▲

formerly_proven an hour ago | parent [-]

> This document describes the support for SQL foreign key constraints introduced in SQLite version 3.6.19 (2009-10-14).

	▲	ahartmetz an hour ago \| parent [-]
		That quote leaves open whether SQLite "pretended" to support foreign keys by allowing to create tables with them, but didn't implement them. Otherwise, I don't see the compatibility problem.