[Qgis-developer] Built-in functions in Spatialite is not working in Spatialite Manager and Custom Query plugin.

[Noli Sicad]

Hi,

It seems that Built-in functions in Spatialite is not working in
Spatialite Manager and Custom Query plugin.

This query (below) is working in spatialite. However not in Spatialite
Manager and Custom query plugin. See the results in spatialite
terminal result.

Select PK_UID, Area(Geometry) as Area, Glength(Geometry) as Perimeter
from Regions where Name = 'VENETO';


spatialite> Select PK_UID, Area(Geometry) as Area, Glength(Geometry)
as Perimeter from Regions where Name = 'VENETO';
1|646397.805154562|3767.27751498312
2|1290337.68600099|6293.47638232552
3|8784619.91935909|26500.3924111861
4|530524.678980947|3393.68314026964
12|438895.715023518|3113.64992438381
13|1080844.97356853|4257.52369736528
27|631684.999314845|3312.26243379054
28|697028.860538453|3883.34841424143
29|1643348.74578464|7902.1272961186
30|2059950.71955425|9280.26957054055
31|3475156.56185258|8530.46975877753
32|2837714.23986262|11833.608036565
33|760252.960525573|3456.43315003721
34|3548959.66717082|10910.225574648
35|633458.679342464|3350.58352770575
36|732165.134682328|4345.32619131389
37|663225.180475533|3885.78466328978
38|918705.089251876|4344.70107002211
39|552058.274254918|4035.57280567915
40|1054773.22809702|5408.63784325175
41|1330499.79153974|6117.34545132715
42|1400447.12052478|6740.60779784617
43|464557.224632263|3508.45482974964
44|723247.97768569|3599.45282522162
45|651748.85301292|3801.78008569203
46|548118.492645741|3712.45734461941
47|488050.567765743|3177.6569314083
48|752451.875753649|3537.1586256791
49|6069461.72734681|23020.9974671427
50|9739.59230065346|719.590296605301
108|18045728269.4635|1202815.64345084
spatialite>

Thanks.

Noli