-
-
Notifications
You must be signed in to change notification settings - Fork 0
Closed
Labels
bugSomething isn't workingSomething isn't working
Description
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.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working