What does <code> select sqlite_version(); </code>say? Your DDL runs fine with SQLite 3.32.2 and 3.33.0 .