[ https://issues.apache.org/jira/browse/OPENJPA-223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16414997#comment-16414997 ]
ASF GitHub Bot commented on OPENJPA-223: ---------------------------------------- Github user chibenwa commented on a diff in the pull request: https://github.com/apache/james-project/pull/107#discussion_r177304978 --- Diff: mailbox/jpa/src/main/java/org/apache/james/mailbox/jpa/mail/model/JPAProperty.java --- @@ -38,7 +38,7 @@ @Column(name = "PROPERTY_ID", nullable = true) // TODO The columnNames are not interpreted, see OPENJPA-223 to fix // MAILBOX-186 - @Index(name = "INDEX_PROPERTY_MSG_ID", columnNames = { "MAILBOX_ID", "MAIL_UID" }) + //@Index(name = "INDEX_PROPERTY_MSG_ID", columnNames = { "MAILBOX_ID", "MAIL_UID" }) --- End diff -- IMO we should remove completly these 3 comments line. **git** history and JIRA are here to remind us about it. Could you please delete these lines? > columnNames field of @Index annotation is ignored > ------------------------------------------------- > > Key: OPENJPA-223 > URL: https://issues.apache.org/jira/browse/OPENJPA-223 > Project: OpenJPA > Issue Type: Bug > Components: jdbc > Affects Versions: 0.9.6 > Reporter: Marc Prud'hommeaux > Priority: Major > > It looks like we completely ignore the "columnNames" field of the > org.apache.openjpa.persistence.jdbc.Index annotation. From Jonathan Feinberg > on the mailing list: > Is there any way to cause the OpenJPA schema builder to emit an index across > multiple columns? My attempt, > @Column(columnDefinition = "bytea") > @Index(name = "i_owner_md5", columnNames = { "owner_id, md5" }) > public byte[] getMd5() > { > return md5; > } > is silently misinterpreted, in that only the annotated field (md5) gets > indexed. -- This message was sent by Atlassian JIRA (v7.6.3#76005)