[Qgis-developer] Questions/Suggestion on virtual layers

Hugo Mercier hugo.mercier at oslandia.com
Thu Mar 3 04:26:15 PST 2016

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.

More information about the Qgis-developer mailing list