Re: Datatype format exception : float - detect the incorrect triple

[Andy Seaborne]

On 01/01/2022 19:45, Jean-Marc Vanel wrote:

During TDB initialization, I get this warning :
WARN  o.apache.jena.sparql.expr.NodeValue - Datatype format exception:
"4,77962"^^xsd:float

But I am unable to detect the incorrect triple , with this query :
PREFIX xsd:  <http://www.w3.org/2001/XMLSchema#>
SELECT * WHERE {
   ?S ?P "4,77962"^^xsd:float .
}

I also tried this:
SELECT * WHERE {
   ?S ?P ?O.
   FILTER ( STR(?O) = "4,77962" )

Try

FILTER ( CONTAINS(STR(?O), "779") )

}

This uses the latest jena Version 4.3.2 , with TDB 1 .
I suspect this bad data prevents geosparl queries from getting any result.

Did it work in a previous version?
Did you load the TDB database with 4.3.2?
Does it work with TDB2?
Does the original data have a comma in a float?

    Andy

Jean-Marc Vanel
<http://semantic-forms.cc:1952/display?displayuri=http://jmvanel.free.fr/jmv.rdf%23me>
+33 (0)6 89 16 29 52
Twitter: @jmvanel , @jmvanel_fr