[fdo-internals] Sqlite provider failed on view with litterals
Romica.Dascalescu at autodesk.com
Wed Jun 20 06:45:40 PDT 2012
SQLite 3.7 provider should work against this view and should return the class definition.
In case it's not, could you try to make the view not-temporary and try again?
In case it works then you might hit a bug in the provider with temp views...
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 5:11 AM
To: fdo-internals at lists.osgeo.org
Subject: [fdo-internals] Sqlite provider failed on view with litterals
I want to use some king of view design like this:
CREATE TEMP VIEW foo AS
SELECT *, 'a' AS origin FROM a.foo
SELECT *, 'b' AS origin FROM b.foo;
the 3.6 and 3.7 provider can't list columns for this view.
The problem is in the sqlite api
it failes returning an error "column *a* does not exist"
This api should work, see
This is maybe because the sqlite provider use an old version of the sqlite
I know the sqlite library used in the provider has been modified.
This meen it's not trivial to upgrade to a newer version.
Would it be possible to upgrade the sqlite library to a newer version or we
gone to live with this old one for ever?
View this message in context: http://osgeo-org.1560.n6.nabble.com/Sqlite-provider-failed-on-view-with-litterals-tp4982600.html
Sent from the FDO Internals mailing list archive at Nabble.com.
fdo-internals mailing list
fdo-internals at lists.osgeo.org
More information about the fdo-internals