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

2017-05-16 Thread Beppe Mazzola
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?

2017-05-16 Thread Beppe Mazzola
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