[jira] [Commented] (OFBIZ-11998) Demo Data in conflict with Entity Unique Index when loading data during creation

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-11998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17196728#comment-17196728 ]

ASF subversion and git services commented on OFBIZ-11998:
---------------------------------------------------------

Commit 231f97f030ad14b04542f6214ef48a8b74b551b4 in ofbiz-framework's branch refs/heads/trunk from Jacques Le Roux
[ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=231f97f ]

Improved: Demo Data in conflict with Entity Unique Index when loading data during creation (OFBIZ-11998)

This is a known issue with MsSQL since
http://ofbiz.135035.n4.nabble.com/Unique-constraint-on-Person-cardId-breaks-ofbiz-on-SQL-Server-td4656840.html
The problem does not exist with Derby, nor with the mostly open source DBMS
used with OFBiz: Postres, MySQL, MariaDB, etc.
So we will not change the current OOTB setting and suggest to simply change
your own configuration

Thanks: Schumann Ye for report

> Demo Data in conflict with Entity Unique Index when loading data during creation
> --------------------------------------------------------------------------------
>
>                 Key: OFBIZ-11998
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-11998
>             Project: OFBiz
>          Issue Type: Bug
>          Components: party
>    Affects Versions: 17.12.04
>         Environment: Win10, Java JDK1.8, MSSQL.
>            Reporter: Schumann Ye
>            Assignee: Jacques Le Roux
>            Priority: Minor
>              Labels: patch
>             Fix For: 18.12.01
>
>
> In party-entitymodel.xml line nr. 2,814 the following is defined:
>  <index name="CARD_ID_IDX" {color:#FF0000}unique="true"{color}>
>       <index-field name="cardId"/>
> </index>
> which goes against with the following code in applications\securityext\data\UserDemoData.xml.
> <Person partyId="_NA_"/>.
> This would cause inserting records into Entity Person failing because the field CARD_ID should not be identical in this case.
> Therefore it's suggested to change the party-entitymodel.xml from :
>  <index name="CARD_ID_IDX" {color:#FF0000}unique="true"{color}>
>       <index-field name="cardId"/>
> </index>
> to
>  <index name="CARD_ID_IDX">
>       <index-field name="cardId"/>
> </index>

--
This message was sent by Atlassian Jira
(v8.3.4#803005)