79203815

Date: 2024-11-19 14:31:13
Score: 1
Natty:
Report link

As Richard Hipp from the SQLite forum has told me:

You cannot use a WITHOUT ROWID table as an external content table. The external content table must be a rowid table. The "content_rowid=" argument to FTS5 must refer to a column of type INTEGER PRIMARY KEY. If you make the "content_rowid=" refer to a TEXT PRIMARY KEY column, it won't work.

Removing the WITHOUT ROWID and content_rowid=path fixes the issue.

Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: ThreeRoundedSquares