VACUUM depends on upper cased "CREATE [UNIQUE] INDEX" sql text in sqlite_master when " pragma case_sensitive_like = on " , or the VACUUM will not work properly ________________________________ ???: Simon Slavin<mailto:slavins at bigfraud.org> ????: ?2016/?3/?2 17:27 ???: SQLite mailing list<mailto:sqlite-users at mailinglists.sqlite.org> ??: Re: [sqlite] Why does the stored schema strings have their beginning upper-cased?
On 2 Mar 2016, at 9:16am, Clemens Ladisch <clemens at ladisch.de> wrote: > It does not say _why_ these normalizations are applied, but I'd guess it > makes searching for specific entries easier. In an informal, non-programming way, I'll just comment that the style here is that keywords are written in upper case and entity names (table names, column names, etc.) are written with at least one lower case character. This doesn't help much, but when it does it saves a lot of time. Like the time I saw someone trying to use a table called "cast". Simon. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
