On Fri, Sep 4, 2015 at 11:40 AM, Domingo Alvarez Duarte < sqlite-mail at dev.dadbiz.es> wrote:
> CREATE INDEX companies_number_idx ON companies ('number');
>
That's a string literal (single-quotes), not a column name. Should be
either number (no quotes), or "number" (double-quotes). (Maybe also
[number], a la MS SQL Server.)
It's a change of behavior, sure, by relies on an SQLite backward-dependency
"quirk" you should not depend on IMHO. --DD
