[mapserver-users] Connection to SpatiaLite utilizing SQL

[Roman]

Hi list,
I have a working connection to SpatiaLite

  CONNECTION "c:/Temp/test.sqlite"
  DATA "Lines"

For certain layers I need to specify connection by SQL. According to
http://mapserver.org/input/vector/sqlite.html I tried this:

  CONNECTION "c:/Temp/test.sqlite"
  DATA "SELECT geometry FROM Lines"

With 6.2.0 stable it does not render specified layer and does not throw any
error.
With development version taken from http://www.gisinternals.com/sdk/ I get
an error "msOGRFileNextShape(): OGR error. Unable to query table
Lines(geometry) for column definitions : no such table: Lines(geometry)."

Geometry column is correctly registered in geometry_columns table and
"ogrinfo test.sqlite Lines -summary" says "Geometry Column = geometry".
Where could be the problem?

Thank you in advance.

Roman
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130222/0c3f25f0/attachment.html>