Hi Beppe, I am confused now as the original test case provided for recreating did not use SQLWorkbench or JDBC, so how can the issue then be recreated ?
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 22 May 2017, at 14:52, Beppe Mazzola <beppemazz...@gmail.com> wrote: > > Hi Hughs > > It seems the problem is not related to the RDF views tied to the tables, > because it happens even before executing the mapping. > The problem arises only when I bulk load data into the tables with the tool > Sqlworkbench/J using the Virtuoso JDBC driver virtjdbc4_2.jar. > So there is something in the Sqlworkbench/j or (it seems to me more likely) > in the JDBC driver that causes the issue. > > Cheers > > Beppe > > > > 2017-05-16 10:27 GMT+01:00 Beppe Mazzola <beppemazz...@gmail.com > <mailto:beppemazz...@gmail.com>>: > Hi Hugh > > I have noticed something strange related to the PK index of the table > provided to you. > > After having run all the scripts I executed again by chance the first INSERT > statement and VOS allowed me to do it! And I could see both the rows with > ID=0 in the table... > At this point if you delete the rows with ID=0 one of them is deleted, and > the remaining one is visible only with select not using the PK index. This > might have a relation with the original RDF view issue.... > > I have used the Conductor Interactive SQL. > > Cheers > > Beppe > > > 2017-05-16 9:25 GMT+01:00 Beppe Mazzola <beppemazz...@gmail.com > <mailto:beppemazz...@gmail.com>>: > 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 <http://test/rdfGen1>> > where { > #<http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0 > <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 > <mailto: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/ > <http://www.openlinksw.com/> > Weblog -- http://www.openlinksw.com/blogs/ > <http://www.openlinksw.com/blogs/> > LinkedIn -- http://www.linkedin.com/company/openlink-software/ > <http://www.linkedin.com/company/openlink-software/> > Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink> > Google+ -- http://plus.google.com/100570109519069333827/ > <http://plus.google.com/100570109519069333827/> > Facebook -- http://www.facebook.com/OpenLinkSoftware > <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 >> <mailto: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 >> <http://example.com/pesticides/resource>> >> where { >> <http://example.com/pesticides/resource/annex-0 >> <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 >> <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://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} >> <http://example.com/pesticides/resource/annex-%7BANNEXES_ID%7D>"; >> rr:class pest:Annex; >> rr:graph <http://example.com >> <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_______________________________________________ >> <http://sdm.link/slashdot_______________________________________________> >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> <mailto:Virtuoso-users@lists.sourceforge.net> >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users> > > > >
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ 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
