[fdo-internals] Sqlite provider failed on view with litterals

Romica Dascalescu Romica.Dascalescu at autodesk.com
Wed Jun 20 07:20:43 PDT 2012

Hi Bruno,

I generated a SQLite file and tested your view. I could see the view as a non-feature class.
In case I add a row in geometry_columns table, I can see it as a feature class and even I can select from it.
In order to see a view as a feature class you need to specify in geometry_columns the geometry column(s) and optional is to add in fdo_columns the primary key.
There is no problem with view properties specified as you did. I attached my sample, and you can try it out.

From: fdo-internals-bounces at lists.osgeo.org [fdo-internals-bounces at lists.osgeo.org] on behalf of Bruno Scott [bscott at geomapgis.com]
Sent: Wednesday, June 20, 2012 9:58 AM
To: fdo-internals at lists.osgeo.org
Subject: Re: [fdo-internals] Sqlite provider failed on view with litterals

Hi Romy
The problem is not related to temp view
Standard view has the same problem
    SELECT *, 'a' AS origin FROM a.foo
    SELECT *, 'b' AS origin FROM b.foo;
The problem is when using a fake litteral column like 'a' or 'b' in my

I've tried with AIMS 2013 witch is using some 3.7 build and it does not even
list the view in the available classes


View this message in context: http://osgeo-org.1560.n6.nabble.com/Sqlite-provider-failed-on-view-with-litterals-tp4982600p4982698.html
Sent from the FDO Internals mailing list archive at Nabble.com.
fdo-internals mailing list
fdo-internals at lists.osgeo.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Test.sqlite
Type: application/octet-stream
Size: 196608 bytes
Desc: Test.sqlite
URL: <http://lists.osgeo.org/pipermail/fdo-internals/attachments/20120620/86c6ac1f/attachment-0001.obj>

More information about the fdo-internals mailing list