[fdo-internals] Sqlite provider failed on view with litterals
Romica.Dascalescu at autodesk.com
Wed Jun 20 07:20:43 PDT 2012
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
The problem is not related to temp view
Standard view has the same problem
CREATE VIEW foo AS
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...
Size: 196608 bytes
More information about the fdo-internals