Re: [h2] BUG? odd behavior involving automatic foreign key indices and multiple-column primary keys

Hi, Yes, H2 creates unique indexes for constraints. If you have a complete, standalone, simple reproducible test case, we can have a look. But please remove all columns that are not needed to analyze this. Regards, Thomas On Fri, Mar 3, 2017 at 8:58 PM, Laird Nelson wrote:

[h2] BUG? odd behavior involving automatic foreign key indices and multiple-column primary keys

I have a table with multiple columns in its primary key. CREATE TABLE GAV ( GROUP_ID VARCHAR(255) NOT NULL, ARTIFACT_ID VARCHAR(255) NOT NULL, VERSION_ID VARCHAR(20) NOT NULL, CLASSIFIER VARCHAR(20) DEFAULT 'jar' NOT NULL PRIMARY KEY (GROUP_ID, ARTIFACT_ID, VERSION_ID, CLASSIFIER) )