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

[Romica Dascalescu]

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.

Thanks,
Romy.
________________________________________
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
CREATE VIEW foo AS
    SELECT *, 'a' AS origin FROM a.foo
    UNION
    SELECT *, 'b' AS origin FROM b.foo;
The problem is when using a fake litteral column like 'a' or 'b' in my
example

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

Bruno

--
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
http://lists.osgeo.org/mailman/listinfo/fdo-internals
-------------- 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>