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

[Bruno Scott]

Hi Romy, i have found the problem
The exact syntax for my view was

CREATE VIEW foo AS 
    SELECT *,* "a" *AS origin FROM a.foo 
    UNION 
    SELECT *, *"b"* AS origin FROM b.foo; 

instead of
CREATE VIEW foo AS 
    SELECT *, *'a'* AS origin FROM a.foo 
    UNION 
    SELECT *,* 'b' *AS origin FROM b.foo; 

"a" means the column a, so this raise an error
The disturding thing is when using sqlite studio, it works fine without any
warning...

Anyway, thanks a lot for your help Romy

Bruno Scott

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