Hi, Suppose we have following DDL: CREATE TABLE TEST ( org_id INT NOT NULL, drug_id INT NOT NULL, price DOUBLE NULL, qtty INT NULL, inter_id INT NULL, trade_id INT NULL, med_id INT NULL, medp_id INT NULL, avgprc DOUBLE NULL, avgprc_region DOUBLE NULL, region_id INTEGER NULL, prctype INTEGER NOT NULL, prccomment VARCHAR(250) NULL, PRIMARY KEY (org_id, drug_id, prctype) ) WITH "CACHE_NAME=TEST,TEMPLATE=REPLICATED,ATOMICITY=ATOMIC,KEY_TYPE=KTest,VALUE_TYPE=TTest";
Execute this script via thin JDBC driver (Ignite 2.3.0). TEST table is created but primary key doesn't exist (this can be seen in DB via H2 web console). If we remove PRIMARY KEY (org_id, drug_id, prctype) section from CREATE TABLE Ignite throws exception: No PRIMARY KEY defined for CREATE TABLE Of course we can CREATE INDEX PK_TEST ON TEST (org_id, drug_id, prctype) instead of PK, but it seems that Ignite 2.3.0 has bug in PK creation. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
