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

Romica Dascalescu Romica.Dascalescu at autodesk.com
Wed Jun 20 06:45:40 PDT 2012

Hi Bruno,

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

Hi all,

I want to use some king of view design like this:
    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
PRAGMA table_info(foo);
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?

Bruno Scott

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 mailing list