Hi List , We are facing one strange behavior with Monetdb. We have a simple table called test with following structure: CREATE SEQUENCE "testtable_seq" as bigint START WITH 1; CREATE TABLE testtable (dim_id bigint DEFAULT NEXT VALUE FOR "testtable_seq", dim_type varchar(100) NOT NULL, dim_value varchar(100) NOT NULL, CONSTRAINT unique_dimension UNIQUE(dim_type,dim_value) , CONSTRAINT pk_testtable PRIMARY KEY (dim_id)); We have a program which reads and writes to this table along with other tables using JDBC. We are facing below problems interminently: 1. When we query back data from this table with query like : select dim_id,dim_type,dim_value from testtable where dim_type='user' and dim_value='user1' we are getting back ID for some other value present in testable . 2. We are also seeing duplicate values getting inserted in to this table. Please suggest , we are using Oct SP1 build. Regards, Ashish _______________________________________________ developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list