Hello !
First of all, thanks for reply !
I now know that the single quotes is not supposed to be used to specify field
names and I pointed this here because previous versions of sqlite permitted
it and if somehow I improperly used it probably other did so too.
It seems that it's now fixed on trunk.
Cheers !
> Fri Sep 04 2015 3:40:18 pm CEST CEST from "Dominique Devienne"
><ddevienne at gmail.com> Subject: Re: [sqlite] Changes to create index on
>trunk
>is breaking old code
>
> On Fri, Sep 4, 2015 at 2:54 PM, Richard Hipp <drh at sqlite.org> wrote:
>
>
>>On 9/4/15, Domingo Alvarez Duarte <sqlite-mail at dev.dadbiz.es> wrote:
>>
>>>I'm testing sqlite3 trunk on existing code and noticed that the changes
>> to
>>
>>>"create index" using expressions/functions is breaking on old databases.
>>>
>> Should now be fixed on trunk. Please update and try again.
>>
>>
> Neither [1] and [2] clearly spell out the syntaxes allowed to refer to
> column or table names.
> And I don't recall reading about it in the online doc. Did I miss it (quite
> possible), or is it simply not there?
>
> Could someone please point the exact rules ("naked", double-quotes,
> square-brakets, etc...) in the doc please?
>
> Thanks, --DD
>
> https://www.sqlite.org/lang_createtable.html
> https://www.sqlite.org/lang_expr.html
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
?
