On 28 Mar 2019, at 10:25am, Dominique Devienne <ddevie...@gmail.com> wrote:
> Some info about the statement from EXPLAIN QUERY PLAN, that DRH would agree
> to, and accept to "publicly document" and thus support would be nice,
You want something like
EXPLAIN EFFECTS OF <statement>
and it should answer with zero or more lines. Each line contains a single
string column. The strings are things like 'change data', 'change schema',
'change pragma', 'return nothing', 'return table', 'return one row'.
The 'change' results do not mean that anything actually changes, they mean that
the command is the kind of command intended to make that change. For example,
an UPDATE command that changes no rows (or perhaps even refers to a table which
doesn't exist) still returns 'changes data'. The 'return' results are similar.
'return table' means the command can return any number of rows, not how many
rows it actually will return.
If 'changes pragma' appears, then perhaps another line could say which one,
like 'changes pragma journal_mode'.
This would be useful for people writing a SQLite tool, or those with a setup
which might involve an injection vulnerability. Whether it's actually worth
building into SQLite I have no idea.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
