On Fri, Sep 4, 2015 at 11:49 AM, Dominique Devienne <ddevienne at gmail.com>
wrote:
> 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-compatibility "quirk" you should not depend on IMHO. --DD
>
s/dependency/compatibility/g
