SQLite Forum

sqlite3 CLI .expert mode returns “Error: not an error”, if suggested index name is created, but does not match suggestion
Login
> Please accept my belated: Thanks.

Accepted.

Please also accept my thanks for fixing this issue in a timely manner. :-)

> The problem is fixed on trunk

Tried it on both my reported,reduced case and the [original query](http://1337net.duckdns.org:8080/MTGProxyPrinter/wiki?name=Interesting+Card+database+queries) it came up with, and it indeed works as expected now.

The new error message “Cannot find a unique index name to propose.” that is output in case no free name can be found is also really clear.

> Please let us know of any more strange corners of the .expert input space that you find infested.

Will do, if something comes up.

The expert mode already was of great help: I would never have thought of creating a COLLATE NOCASE index for LIKE matches, which sped up a frequently occurring query by factor ~1000.