SQLite Forum

sqlite3 CLI .expert mode returns “Error: not an error”, if suggested index name is created, but does not match suggestion
Login
> The output should be "(no new indexes)" instead of that cryptic error, right?

Not necessarily. Only if the modified index actually results in a presumably optimal plan. If the modified CREATE INDEX statement does not give the prospect of reasonable speed-up, it should still suggest the original index, but preferably with a non-colliding name.

E.g. if the index in the above example were created as

`CREATE INDEX t_idx_00012959 ON t(a);` (i.e. create a useless index on the INTEGER PRIMARY KEY column)., it should still suggest the index creation `ON t(b, c)`