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

Bruno Scott bscott at geomapgis.com
Wed Jun 20 06:58:07 PDT 2012


Hi Romy
The problem is not related to temp view
Standard view has the same problem
CREATE VIEW foo AS 
    SELECT *, 'a' AS origin FROM a.foo 
    UNION 
    SELECT *, 'b' AS origin FROM b.foo; 
The problem is when using a fake litteral column like 'a' or 'b' in my
example

I've tried with AIMS 2013 witch is using some 3.7 build and it does not even
list the view in the available classes

Bruno

--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Sqlite-provider-failed-on-view-with-litterals-tp4982600p4982698.html
Sent from the FDO Internals mailing list archive at Nabble.com.


More information about the fdo-internals mailing list