SQLite Forum

.lint fkey-indexes output
Login

.lint fkey-indexes output

(1) By Wolfgang Oertl (w.oertl) on 2021-06-25 11:01:24

Hi all,

when `.lint fkey-indexes` reports missing indices, single quotes are used in place of [double quotes](https://sqlite.org/lang_keywords.html), I think. It works, but is not as recommended. Example output:

`CREATE INDEX 'val_parameter_id' ON 'val'('parameter_id'); --> parameter(id)`

When looking into shell.c.in at the function lintFkeyIndexes, the SQL statement  uses the QUOTE function inappropriately, if I'm not mistaken.