sqlite3.OperationalError: no such column: id

[simonw]

Got this error trying to enable chronicle on a table that didn't have an id column. Turns out it was because of the new window function:

sqlite-chronicle/sqlite_chronicle.py

Lines 75 to 80 in 1e06725

	SELECT
	{', '.join([f'"{col[0]}"' for col in primary_key_columns])},
	{current_time_expr},
	{current_time_expr},
	ROW_NUMBER() OVER (ORDER BY id)
	FROM "{table_name}";

ROW_NUMBER() OVER (ORDER BY id)

That needs to be ORDER BY then the full set of primary keys.