Re: [sqlite] UNIQUE constraint fails when setting legacy_file_format=true

Addressed by https://www.sqlite.org/src/info/713caa382cf7ddef On 5/1/19, Manuel Rigger wrote: > Hi everyone, > > I think that I found a bug that occurs when setting legacy_file_format to > true and calling REINDEX, which then results in "Error: UNIQUE constraint > failed: index 'index_0'" in the

[sqlite] UNIQUE constraint fails when setting legacy_file_format=true

Hi everyone, I think that I found a bug that occurs when setting legacy_file_format to true and calling REINDEX, which then results in "Error: UNIQUE constraint failed: index 'index_0'" in the specific example below: CREATE TABLE test (c0, c1 TEXT); CREATE UNIQUE INDEX IF NOT EXISTS index_0 ON