{"action":"created","issue":{"url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/649","repository_url":"https://api.github.com/repos/openlink/virtuoso-opensource","labels_url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/649/labels{/name}","comments_url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/649/comments","events_url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/649/events","html_url":"https://github.com/openlink/virtuoso-opensource/issues/649","id":225627046,"node_id":"MDU6SXNzdWUyMjU2MjcwNDY=","number":649,"title":"SPARQL for NaN values fails","user":{"login":"joernhees","id":464192,"node_id":"MDQ6VXNlcjQ2NDE5Mg==","avatar_url":"https://avatars1.githubusercontent.com/u/464192?v=4","gravatar_id":"","url":"https://api.github.com/users/joernhees","html_url":"https://github.com/joernhees","followers_url":"https://api.github.com/users/joernhees/followers","following_url":"https://api.github.com/users/joernhees/following{/other_user}","gists_url":"https://api.github.com/users/joernhees/gists{/gist_id}","starred_url":"https://api.github.com/users/joernhees/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joernhees/subscriptions","organizations_url":"https://api.github.com/users/joernhees/orgs","repos_url":"https://api.github.com/users/joernhees/repos","events_url":"https://api.github.com/users/joernhees/events{/privacy}","received_events_url":"https://api.github.com/users/joernhees/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-05-02T08:36:02Z","updated_at":"2018-09-17T13:30:30Z","closed_at":"2018-09-17T13:30:30Z","author_association":"NONE","body":"i think there's a bug in the query parser when trying to query for NaN values:\r\n```\r\nselect ?s where {\r\n  ?s ?p \"NaN\"^^<http://www.w3.org/2001/XMLSchema#float> .\r\n}\r\nlimit 10\r\n```\r\n\r\ntry on [dbpedia](http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&qtxt=select+%3Fs+where+%7B%0D%0A++%3Fs+%3Fp+%22NaN%22%5E%5E%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23float%3E+.%0D%0A%7D%0D%0Alimit+10&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on)\r\n\r\n\r\n```\r\nVirtuoso 22005 Error SR334: Invalid floating point value converting 'NaN'\r\n\r\nSPARQL query:\r\ndefine sql:big-data-const 0 \r\n#output-format:text/html\r\ndefine sql:signal-void-variables 1 define input:default-graph-uri <http://dbpedia.org> select ?s where {\r\n  ?s ?p \"NaN\"^^<http://www.w3.org/2001/XMLSchema#float> .\r\n}\r\nlimit 10\r\n```"},"comment":{"url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/comments/422016655","html_url":"https://github.com/openlink/virtuoso-opensource/issues/649#issuecomment-422016655","issue_url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/649","id":422016655,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMjAxNjY1NQ==","user":{"login":"HughWilliams","id":4868081,"node_id":"MDQ6VXNlcjQ4NjgwODE=","avatar_url":"https://avatars3.githubusercontent.com/u/4868081?v=4","gravatar_id":"","url":"https://api.github.com/users/HughWilliams","html_url":"https://github.com/HughWilliams","followers_url":"https://api.github.com/users/HughWilliams/followers","following_url":"https://api.github.com/users/HughWilliams/following{/other_user}","gists_url":"https://api.github.com/users/HughWilliams/gists{/gist_id}","starred_url":"https://api.github.com/users/HughWilliams/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/HughWilliams/subscriptions","organizations_url":"https://api.github.com/users/HughWilliams/orgs","repos_url":"https://api.github.com/users/HughWilliams/repos","events_url":"https://api.github.com/users/HughWilliams/events{/privacy}","received_events_url":"https://api.github.com/users/HughWilliams/received_events","type":"User","site_admin":false},"created_at":"2018-09-17T13:30:30Z","updated_at":"2018-09-17T13:30:30Z","author_association":"COLLABORATOR","body":"@joernhees This issue has been resolved in the latest Virtuoso 7.2.5 open source stable/7 release made in Aug 2018 , see http://vos.openlinksw.com/owiki/wiki/VOS/\r\n\r\n```\r\nSQL> SPARQL select ?s where {   ?s ?p \"NaN\"^^<http://www.w3.org/2001/XMLSchema#float> . } limit 10;\r\ns\r\nLONG VARCHAR\r\n_______________________________________________________________________________\r\n\r\n\r\n0 Rows. -- 1 msec.\r\nSQL> \r\n```"}}
{"actor":{"display_login":"HughWilliams"}}