[jira] [Commented] (OPENJPA-223) columnNames field of @Index annotation is ignored

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ 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)