[fdo-internals] Sqlite provider failed on view with litterals
bscott at geomapgis.com
Wed Jun 20 02:11:45 PDT 2012
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.
More information about the fdo-internals