search

AKSW / Erfurt

PHP5 / Zend based Semantic Web API for Social Semantic Software
41 stars 27 forks source link

Server not responsive when executing date larger filter #97

Open BrummbQ opened 8 years ago

BrummbQ commented 8 years ago

We have a very specifiy issue when running ontowiki with erfurt and virtuoso. Now the strange thing is, the issue only occurs when there are 'dates' typed as strings in the database. If all dates are correctly typed, the system is running fine. Our query:

SELECT DISTINCT ?resourceUri  
FROM <http://ubl.amsl.technology/erm/> 
WHERE { 
?resourceUri <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://vocab.ub.uni-leipzig.de/amsl/AnnualContractData> . 
?resourceUri <http://vocab.ub.uni-leipzig.de/amsl/licenseEndDate> ?licenseenddate 
FILTER (?licenseenddate > "2099-01-01"^^<http://www.w3.org/2001/XMLSchema#date>) 
}

Do you have any ideas?

white-gecko commented 8 years ago

Did you try to load the same data directly into Virtuoso and execute this query? Is the behavior the same for Virtuoso as running it through OntoWiki?

@splattater Can you say more about this, could you maybe try to reproduce this?

BrummbQ commented 8 years ago

Virtuoso is working fine and just returns some results with untyped dates for that query. But its not crashing.

2015-12-08 17:06 GMT+01:00 Natanael Arndt notifications@github.com:

Did you try to load the same data directly into Virtuoso and execute this query? Is the behavior the same for Virtuoso as running it through OntoWiki?

@splattater https://github.com/splattater Can you say more about this, could you maybe try to reproduce this?

— Reply to this email directly or view it on GitHub https://github.com/AKSW/Erfurt/issues/97#issuecomment-162930123.