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

[Bruno Scott]

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.