On 5/19/18, Kenichi Ishigaki <kishig...@gmail.com> wrote:
> Hi.
>
> VACUUM ANALYZE without a semicolon in-between used to work, but it
> seems not since 3.15.0. I couldn't find an entry for this in
> releaselogs. Is it an intentional change, or a regression?

If by "used to work" you mean that it didn't raise an error, then you
are correct.  But it never did work in the sense that it never did
both VACUUM and ANALYZE (I'm guessing that's what you thought it was
doing).  The ANALYZE keyword was silently and mistakenly ignored.  The
documentation showed that anything following the VACUUM was a syntax
error, but the engine did not enforce that restriction.

That bug was fixed in 3.15.0.

Beginning with 3.15.0, if anything comes after the VACUUM verb, it
must be the name one of the ATTACH-ed databases that is to be
vacuumed.

-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to