[Qgis-developer] Questions/Suggestion on virtual layers

[Hugo Mercier]

On 03/03/2016 13:22, Bernhard Ströbl wrote:
> Hi Hugo,
> 
> Am 03.03.2016 um 13:14 schrieb Hugo Mercier:
>> Hi,
>>
>> Adding double quotes when the table name contains dots and is inserted
>> from the completion dialog would help, sure. Thanks for the feedback.
> 
> I would prefer to generally add double quotes (easier to code anyways :)

Indeed, that's better.

>>
>> We can as well add something in the documentation about dots in the
>> query. But this is not specific to virtual layers. The same is true for
>> postgis / sqlite.
> 
> You are right but PostgreSQL e.g. is not case sensitive whereas the
> virtual layer's SQL is case sensitive (I have no idea if this is the
> same in sqlite)
> 

Hmmm, actually sqlite is case insensitive, but the virtual layer is case
sensitive when looking for a loaded layer. I probably should change this
to be more consistent.