[ 
https://issues.apache.org/jira/browse/MARMOTTA-627?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sergio Fernández updated MARMOTTA-627:
--------------------------------------
                Labels: Arithmetic  (was: Arithmetic Bug Critical)
    Remaining Estimate: 48h
     Original Estimate: 48h
           Description: 
Hy,

I'm trying to calculate some distances and I need to make some arithmetic 
operations with some numbers below 1.

Unfortunately, this kind of operation seems not to work with the latest version 
of Apache Marmotta (I'm using Apache Marmotta built from repo).

For example, the following query returns -39.5!!!!

{code}SELECT  (  (4.5-4.4)*0.1 as ?c)  WHERE {}{code}

I've tried many combinations with {{xsd:decimal}}, {{xsd:float}}, 
{{xsd:double}}, but the answer is or 1.000 or -39.5.

Other examples: 

{code}SELECT  (0.1*0.1 as ?c) WHERE {}   => 1.00{code}
{code}SELECT  ( 0.10*0.01 as ?c) WHERE {} => 10.0 {code}
{code}SELECT  ( 1.00*3.10 as ?c) WHERE {} => 0.32258064516129032258{code}
{code}SELECT  ( 2.00*4.00 as ?c) WHERE {} => 0.500{code}
{code}SELECT (xsd:decimal(2.80)*xsd:decimal(3.00) as ?c) WHERE {} => 
0.9333{code}



Thank you,


  was:
Hy,

I'm trying to calculate some distances and I need to make some arithmetic 
operations with some numbers below 1.

Unfortunately, this kind of operation seems not to work with the latest version 
of Apache Marmotta (I'm using Apache Marmotta built from repo).

For example, the following query returns -39.5!!!!

SELECT  (  (4.5-4.4)*0.1 as ?c)  WHERE {}

I've tried many combinations with xsd:decimal, xsd:float, xsd:double, but the 
answer is or 1.000 or -39.5.

Other examples: 

SELECT  (0.1*0.1 as ?c) WHERE {}   => 1.00
SELECT  ( 0.10*0.01 as ?c) WHERE {} => 10.0 
SELECT  ( 1.00*3.10 as ?c) WHERE {} => 0.32258064516129032258
SELECT  ( 2.00*4.00 as ?c) WHERE {} => 0.500
SELECT (xsd:decimal(2.80)*xsd:decimal(3.00) as ?c) WHERE {} => 0.9333



Thank you,


           Component/s: KiWi Triple Store

> Arithmetic operation in Sparql query not working properly
> ---------------------------------------------------------
>
>                 Key: MARMOTTA-627
>                 URL: https://issues.apache.org/jira/browse/MARMOTTA-627
>             Project: Marmotta
>          Issue Type: Bug
>          Components: KiWi Triple Store
>    Affects Versions: 3.4.0
>         Environment: Postgresql: 9.3.10
> Server version: Apache Tomcat/7.0.52 (Ubuntu)
> OS Name:        Ubuntu 14.04
> OS Version:     3.13.0-74-generic
> Architecture:   amd64
> JVM Version:    1.7.0_91-b02
> JVM Vendor:     Oracle Corporation
> Marmotta: 3.4.0
>            Reporter: Rinciog Octavian
>              Labels: Arithmetic
>   Original Estimate: 48h
>  Remaining Estimate: 48h
>
> Hy,
> I'm trying to calculate some distances and I need to make some arithmetic 
> operations with some numbers below 1.
> Unfortunately, this kind of operation seems not to work with the latest 
> version of Apache Marmotta (I'm using Apache Marmotta built from repo).
> For example, the following query returns -39.5!!!!
> {code}SELECT  (  (4.5-4.4)*0.1 as ?c)  WHERE {}{code}
> I've tried many combinations with {{xsd:decimal}}, {{xsd:float}}, 
> {{xsd:double}}, but the answer is or 1.000 or -39.5.
> Other examples: 
> {code}SELECT  (0.1*0.1 as ?c) WHERE {}   => 1.00{code}
> {code}SELECT  ( 0.10*0.01 as ?c) WHERE {} => 10.0 {code}
> {code}SELECT  ( 1.00*3.10 as ?c) WHERE {} => 0.32258064516129032258{code}
> {code}SELECT  ( 2.00*4.00 as ?c) WHERE {} => 0.500{code}
> {code}SELECT (xsd:decimal(2.80)*xsd:decimal(3.00) as ?c) WHERE {} => 
> 0.9333{code}
> Thank you,



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to