SQLite Forum

.lint fkey-indexes output

.lint fkey-indexes output

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

Hi all,

when .lint fkey-indexes reports missing indices, single quotes are used in place of double quotes, 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.