[MARMOTTA-627] Arithmetic operation in Sparql query not working properly

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: KiWi Triple Store
• Labels: Arithmetic

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

• Flags: Important
• Assignee: Sergio Fernández
• Reporter: Rinciog Octavian
• Created: 09/Feb/16 00:51
• Updated: 18/Jun/18 19:31
• Resolved: 11/Feb/16 13:46

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!!!!

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,

Issue Links

• is superceded by: MARMOTTA-628 Arithmetic operation in SPARQL use wrong operator precedence