Hi Hugh Here are the steps to reproduce the problem.
1) Create the table CREATE TABLE DB.PEST.ANNEXES ( ANNEXES_ID NUMERIC NOT NULL , ANNEXES_NAMES VARCHAR(50) NOT NULL , ANNEXES_PART VARCHAR(1) , ANNEXES_SPECIAL CHAR(1) NOT NULL , CONSTRAINT PK_ANNEXES PRIMARY KEY (ANNEXES_ID ) ); 2) initialize it with the attached script initANNEXES.sql 3) create the virtual graph with the attached script ttlpExecTrial.sql 4) query the virtual graph select * from <http://test/rdfGen1> where { #<http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0> ?p ?o. ?s ?p ?o filter regex(str(?s),'annex-0') . } I have used Virtuoso Open Source Edition (multi threaded) Version 7.2.4.3217-threads as of Apr 25 2016 Compiled for Win64 (x86_64-generic-win-64) Cheers Beppe 2017-05-14 22:53 GMT+01:00 Hugh Williams <hwilli...@openlinksw.com>: > Hi > > Can you please provide the actual steps to reproduce the issue being > encountered as it is not clear from the information provided ? > > Best Regards > Hugh Williams > Professional Services > OpenLink Software, Inc. // http://www.openlinksw.com/ > Weblog -- http://www.openlinksw.com/blogs/ > LinkedIn -- http://www.linkedin.com/company/openlink-software/ > Twitter -- http://twitter.com/OpenLink > Google+ -- http://plus.google.com/100570109519069333827/ > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology Providers > > > > On 13 May 2017, at 18:01, Beppe Mazzola <beppemazz...@gmail.com> wrote: > > Hi to everybody > > I have generated with Virtuoso Open Source a virtual graph with the > content of many RDB tables.obtained with an R2RML mapping. > > If I execute the following query I do not get any result. > > select * > from<http://example.com/pesticides/resource> > where { > <http://example.com/pesticides/resource/annex-0> ?p ?o. > } > > but if I execute this query (I suppose without index because it takes many > seconds) > > select * > from<http://example.com/pesticides/resource> > where { > ?s ?p ?o filter regex(str(?s),'annex-0') . > } > > > I get the exact result, that is the content of the corresponding table row. > > http://example.com/pesticides/resource/annex-0 > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0> > http:// > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annexId> > example.com > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0> > /pesticides/resource/annexId 0 > http://example.com/pesticides/resource/annex-0 > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0> > http:// > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annexName> > example.com > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0> > /pesticides/resource/annexName Not Assigned > http://example.com/pesticides/resource/annex-0 > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0> > http:// > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annexSpecial> > example.com > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0> > /pesticides/resource/annexSpecial 0 > http://example.com/pesticides/resource/annex-0 > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0> > http://www.w3.org/1999/02/22-rdf-syntax-ns#type http:// > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/Annex> > example.com > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0> > /pesticides/resource/Annex > > It looks like the index does not catch the triples.... This is the > involved R2RML mapping fragment > > <#TriplesMapANNEXES> a rr:TriplesMap; > rr:logicalTable [ > rr:tableSchema "DB" ; > rr:tableOwner "pest" ; > rr:tableName "ANNEXES" > ]; > rr:subjectMap [ > rr:termType rr:IRI ; > rr:template "http://example.com/pesticides > /resource/annex-{ANNEXES_ID}"; > rr:class pest:Annex; > rr:graph <http://example.com/pesticides/resource> ]; > rr:predicateObjectMap [ > rr:predicateMap [ > rr:constant pest:annexId ] ; > rr:objectMap [ > rr:column "ANNEXES_ID" ]; ] ; > rr:predicateObjectMap [ > rr:predicateMap [ > rr:constant pest:annexName ] ; > rr:objectMap [ > rr:column "ANNEXES_NAMES" ]; ] ; > rr:predicateObjectMap [ > rr:predicateMap [ > rr:constant pest:annexPart ] ; > rr:objectMap [ > rr:column "ANNEXES_PART" ]; ] ; > rr:predicateObjectMap [ > rr:predicateMap [ > rr:constant pest:annexSpecial ] ; > rr:objectMap [ > rr:column "ANNEXES_SPECIAL" ]; > ] . > > of the following Virtuoso table > > CREATE TABLE DB.PEST.ANNEXES > ( > ANNEXES_ID NUMERIC NOT NULL > , ANNEXES_NAMES VARCHAR(50) NOT NULL > , ANNEXES_PART VARCHAR(1) > , ANNEXES_SPECIAL CHAR(1) NOT NULL > , CONSTRAINT PK_ANNEXES PRIMARY KEY (ANNEXES_ID ) > ); > > Had anyone a similar experience? Any hint? > > Thanks! > > Cheers > > Beppe > > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org <http://slashdot.org>! > http://sdm.link/slashdot_______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > >
ttlpExecTrial.sql
Description: Binary data
initANNEXES.sql
Description: Binary data
------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
