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

[Romica Dascalescu]

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...

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 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:
CREATE TEMP VIEW foo AS
    SELECT *, 'a' AS origin FROM a.foo
    UNION
    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
http://www.mail-archive.com/sqlite-users@sqlite.org/msg12590.html
http://www.mail-archive.com/sqlite-users@sqlite.org/msg12590.html

This is maybe because the sqlite provider use an old version of the sqlite
library!
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
http://lists.osgeo.org/mailman/listinfo/fdo-internals