search

openlink / virtuoso-opensource

Virtuoso is a high-performance and scalable Multi-Model RDBMS, Data Integration Middleware, Linked Data Deployment, and HTTP Application Server Platform
https://vos.openlinksw.com
Other
856 stars 210 forks source link

xsd:gYear format issue #185

Open jakubklimek opened 10 years ago

jakubklimek commented 10 years ago

In 616e55a4f8c14c124479594e743fed76062d313b

In addition to https://github.com/openlink/virtuoso-opensource/issues/125

there is another bug with xsd:gYear datatype.

See http://linked.opendata.cz/resource/domain/election-to-chamber-of-deputies-czech-republic/dataset/result-of-political-parties-elections-nuts/2006/21/CZ041

What was loaded was "2006"^^xsd:gYear the "year" value as shown in fct is "2006-01-01 00:00:00"^^xsd:date When I click on JSON in fct, what I get is "2006+01:00"

When I execute


prefix xsd:     <http://www.w3.org/2001/XMLSchema#> 
prefix ecdcz:   <http://linked.opendata.cz/ontology/domain/election-to-chamber-of-deputies-czech-republic/>
SELECT *
WHERE {  
       ?uri ecdcz:refPeriod ?year
      }
LIMIT 1

on http://linked.opendata.cz/sparql, I get "2006+01:00"^^<http://www.w3.org/2001/XMLSchema#gYear&gt;

HughWilliams commented 10 years ago

There was the following committal of initial support for xsd:gYear added in develop/7 on 20th May, at https://github.com/openlink/virtuoso-opensource/commit/b290861e6f8dc1adff31a6e11f64106d8d817942 , but this is not complete, thus we need to check this current behaviour ...