{"action":"created","issue":{"url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/307","labels_url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/307/labels{/name}","comments_url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/307/comments","events_url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/307/events","html_url":"https://github.com/openlink/virtuoso-opensource/issues/307","id":55191549,"number":307,"title":"Can't retrieve a new inserted entry's label using bif:contains on Virtuoso 7","user":{"login":"fguimara","id":291708,"avatar_url":"https://avatars.githubusercontent.com/u/291708?v=3","gravatar_id":"","url":"https://api.github.com/users/fguimara","html_url":"https://github.com/fguimara","followers_url":"https://api.github.com/users/fguimara/followers","following_url":"https://api.github.com/users/fguimara/following{/other_user}","gists_url":"https://api.github.com/users/fguimara/gists{/gist_id}","starred_url":"https://api.github.com/users/fguimara/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fguimara/subscriptions","organizations_url":"https://api.github.com/users/fguimara/orgs","repos_url":"https://api.github.com/users/fguimara/repos","events_url":"https://api.github.com/users/fguimara/events{/privacy}","received_events_url":"https://api.github.com/users/fguimara/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-01-22T18:40:43Z","updated_at":"2015-01-28T02:02:47Z","closed_at":null,"body":"I've just inserted a node on a DBPedia graph with this query:\r\n\r\n    INSERT DATA {\r\n        GRAPH <http://dbpedia.org> {         \r\n         <http://my.semantics/resources/California%20Assn.%20Of%20Realtors> a dbpedia-owl:Organisation;\r\n                                                                            rdfs:label  'California Assn. Of Realtors'@en .\r\n    }}\r\n\r\nAnd it works fine.\r\nWhen I try:\r\n\r\n    SELECT ?label\r\n    WHERE {\r\n    <http://semantics.twist.systems/resources/California%20Assn.%20Of%20Realtors> rdfs:label ?label . }\r\n\r\nThe result is retrived: `California Assn. Of Realtors`.\r\n\r\nHowever whenever I try something like:\r\n\r\n    select ?label\r\n    where\r\n    {<http://semantics.twist.systems/resources/California%20Assn.%20Of%20Realtors> rdfs:label ?label .\r\n     ?label bif:contains 'California' .}\r\n\r\nNothing is returned. \r\n\r\nI guess it is somehow related to the way virtuoso reindexes the triples.\r\nI've even tried to run `DB.DBA.VT_INC_INDEX_DB_DBA_RDF_OBJ ();` as suggested by https://github.com/openlink/virtuoso-opensource/issues/107 but that didn't help."},"comment":{"url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/comments/71768263","html_url":"https://github.com/openlink/virtuoso-opensource/issues/307#issuecomment-71768263","issue_url":"https://api.github.com/repos/openlink/virtuoso-opensource/issues/307","id":71768263,"user":{"login":"lauramoraes","id":34771,"avatar_url":"https://avatars.githubusercontent.com/u/34771?v=3","gravatar_id":"","url":"https://api.github.com/users/lauramoraes","html_url":"https://github.com/lauramoraes","followers_url":"https://api.github.com/users/lauramoraes/followers","following_url":"https://api.github.com/users/lauramoraes/following{/other_user}","gists_url":"https://api.github.com/users/lauramoraes/gists{/gist_id}","starred_url":"https://api.github.com/users/lauramoraes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lauramoraes/subscriptions","organizations_url":"https://api.github.com/users/lauramoraes/orgs","repos_url":"https://api.github.com/users/lauramoraes/repos","events_url":"https://api.github.com/users/lauramoraes/events{/privacy}","received_events_url":"https://api.github.com/users/lauramoraes/received_events","type":"User","site_admin":false},"created_at":"2015-01-28T02:02:47Z","updated_at":"2015-01-28T02:02:47Z","body":"@HughWilliams \r\n\r\nI work with @fguimara and here is step by step what we did, from installation to query. It still doesn't work...\r\n\r\n```\r\nvirtuoso@virtuoso:~$ git clone https://github.com/openlink/virtuoso-opensource.git\r\nvirtuoso@virtuoso:~/virtuoso-opensource$ git branch\r\n* develop/7\r\nvirtuoso@virtuoso:~/virtuoso-opensource$ ./autogen.sh\r\nvirtuoso@virtuoso:~/virtuoso-opensource$ export CFLAGS=\"-O2 -m64\"\r\nvirtuoso@virtuoso:~/virtuoso-opensource$ ./configure --with-layout=debian --enable-dbpedia-vad --enable-rdfmappers-vad --prefix=/opt/virtuoso\r\nvirtuoso@virtuoso:~/virtuoso-opensource$ make -j3\r\nvirtuoso@virtuoso:~/virtuoso-opensource$ sudo make install\r\nvirtuoso@virtuoso:~/virtuoso-opensource$ cd /opt/virtuoso/var/lib/virtuoso/db\r\nvirtuoso@virtuoso:/opt/virtuoso/var/lib/virtuoso/db$ sudo ../../../../bin/virtuoso-t -f &\r\n[1] 15498\r\nvirtuoso@virtuoso:/opt/virtuoso/var/lib/virtuoso/db$ ../../../../bin/isql\r\nSQL> ld_add('/opt/virtuoso/var/lib/virtuoso/dbpedia/dbpedia_2014.owl', 'http://dbpedia.org/ontology/');\r\nConnected to OpenLink Virtuoso\r\nDriver: 07.10.3211 OpenLink Virtuoso ODBC Driver\r\n\r\nDone. -- 1 msec.\r\nSQL> select ll_file, ll_graph, ll_state from db.dba.load_list;\r\nll_file                                                                           ll_graph                                                                          ll_state\r\nVARCHAR NOT NULL                                                                  VARCHAR                                                                           INTEGER\r\n_______________________________________________________________________________\r\n\r\n/opt/virtuoso/var/lib/virtuoso/dbpedia/dbpedia_2014.owl                           http://dbpedia.org/ontology                                                       0\r\n\r\n1 Rows. -- 2 msec.\r\nSQL> checkpoint;\r\n23:48:00 Checkpoint started\r\n23:48:00 Checkpoint finished, log reused\r\n\r\nDone. -- 61 msec.\r\nSQL> commit WORK;\r\n\r\nDone. -- 1 msec.\r\nSQL> checkpoint;\r\n23:48:10 Checkpoint started\r\n23:48:10 Checkpoint finished, log reused\r\n\r\nDone. -- 71 msec.\r\n\r\nSQL> SPARQL PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> INSERT DATA { GRAPH <http://dbpedia.org> { <http://my.semantics/resources/California_Assn._Of_Realtors> a dbpedia-owl:Organisation; rdfs:label 'California Assn. Of Realtors'@en . }};\r\n\r\nDone. -- 7 msec.\r\nSQL> SPARQL PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> SELECT ?label FROM <http://dbpedia.org> WHERE { <http://my.semantics/resources/California_Assn._Of_Realtors> rdfs:label ?label . };\r\nlabel\r\nLONG VARCHAR\r\n_______________________________________________________________________________\r\n\r\nCalifornia Assn. Of Realtors\r\n\r\n1 Rows. -- 11 msec.\r\nSQL> SPARQL PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> SELECT ?label FROM <http://dbpedia.org> WHERE { <http://my.semantics/resources/California_Assn._Of_Realtors> rdfs:label ?label . ?label bif:contains 'California'. };\r\nlabel\r\nLONG VARCHAR\r\n_______________________________________________________________________________\r\n\r\n\r\n0 Rows. -- 5 msec.\r\nSQL> status('');\r\nREPORT\r\nVARCHAR\r\n_______________________________________________________________________________\r\n\r\nOpenLink Virtuoso  Server\r\nVersion 07.10.3211-pthreads for Linux as of Jan 27 2015 \r\nStarted on: 2015-01-27 23:38 GMT-2\r\n```\r\n"}}