Re: [Virtuoso-users] triples not reached by the index?

Hi Beppe, The steps to recreate this issue via SQLWorkBench and the JDBC driver is what would be required if that is deemed to be the source of the problem ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- htt

Re: [Virtuoso-users] triples not reached by the index?

Hi Hugh At the beginning I did not realize that the problem was caused before, during the first loading of the table. In fact, in my understanding the index of the table was corrupted somehow during the first bulk loading performed by Sqlworkbench/j + Virtuoso JDBC driver. Later the strange effect

Re: [Virtuoso-users] triples not reached by the index?

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

Re: [Virtuoso-users] triples not reached by the index?

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

Re: [Virtuoso-users] triples not reached by the index?

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 th

Re: [Virtuoso-users] triples not reached by the index?

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) initial

Re: [Virtuoso-users] triples not reached by the index?

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/b

[Virtuoso-users] triples not reached by the index?

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 where {