On 21 Jun 2019, at 10:29am, ingo <i...@ingoogni.nl> wrote: > Is this because max() is not deterministic, > or because current_timestamp is not, > or both?
The max(). For the reason you identified: it would have to recalculate the index values for all rows in the table every time any of the rows changed. You will note that SQLite is perfectly happy with CREATE UNIQUE INDEX idx_test_c ON test(id, ts_from, ts_eol) WHERE ts_eol = NULL ; _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users