[Qgis-user] qgis - virtual layers

[Jozef Riha]

hello list,

not sure if this is a known problem but during virtual layers feature
testing i discovered that this tool has issues when source used in query
contains characters such as space, forward slash, dash and possibly others
in column names. it would be nice if user would be presented with a
meaningful error message rather than a cryptic message about syntax error.

to reproduce:
- import test.geojson to qgis
- add virtual layer - run select * from test
- you'll get:

Query execution error on DROP TABLE IF EXISTS "test"; CREATE VIRTUAL TABLE
"test" USING QgsVLayer(test20160305235656402);: 1 - near "1": syntax error

br, j
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160306/b724497f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.geojson
Type: application/octet-stream
Size: 430 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160306/b724497f/attachment.obj>