Hi Jerven,

I have reported this to development to look into ...

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.      //              http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 15 May 2013, at 15:59, Jerven Bolleman <[email protected]> wrote:

> 
> 
> 
> On 15/05/13 16:44, Jerven Bolleman wrote:
>> Hi Developers,
>> 
>> This has probably been raised before but the AVG function in 07.00.3202
>> does not behave as (I think) it should.
>> 
>> Avg(M) = Sum(M) / Count(M), where Count(M) > 0
>> 
>> Where / returns numeric; but xsd:decimal if both operands are xsd:integer
>> 
>> This means that per my reading of the spec avg should return a
>> xsd:decimal but it does not.
>> 
>> This query
>> PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
>> SELECT AVG (?s)
>> WHERE {
>> VALUES ?s {"1"^^xsd:integer "3"^^xsd:integer}
>> }
>> 
>> Should return "1.5"^^xsd:decimal but instead it returns "2"^^xsd:int
> Should return "2.0"^^xsd:decimal but instead it returns "2"^^xsd:int
> 
> Ok, that was rather silly in my maths but the point still stands
> 
> PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
> SELECT (AVG (?s) as ?avg)
> WHERE {
> VALUES (?s) {("1"^^xsd:integer) ("2"^^xsd:integer)}
> }
> 
> returns 1 instead of 1.5 ...
> 
>> 
>> Regards,
>> Jerven
>> 
> 
> 
> -- 
> -------------------------------------------------------------------
>  Jerven Bolleman                        [email protected]
>  SIB Swiss Institute of Bioinformatics  Tel: +41 (0)22 379 58 85
>  CMU, rue Michel Servet 1               Fax: +41 (0)22 379 58 58
>  1211 Geneve 4,
>  Switzerland     www.isb-sib.ch - www.uniprot.org
>  Follow us at https://twitter.com/#!/uniprot
> -------------------------------------------------------------------
> 
> ------------------------------------------------------------------------------
> AlienVault Unified Security Management (USM) platform delivers complete
> security visibility with the essential security capabilities. Easily and
> efficiently configure, manage, and operate all of your security controls
> from a single console and one unified framework. Download a free trial.
> http://p.sf.net/sfu/alienvault_d2d
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Attachment: smime.p7s
Description: S/MIME cryptographic signature

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to