Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0049882
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] French Eco Tax Managementmajoralways2022-07-27 10:222022-07-28 12:31
ReportergorkaionView Statuspublic 
Assigned Toigor_trebol 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0049882: Unique index PHIECO_TAXCATEGORY_NAME is missing ad_client_id

DescriptionThe table PHIECO_TAXCATEGORY has the following unique index PHIECO_TAXCATEGORY_NAME

      <unique name="PHIECO_TAXCATEGORY_NAME">
        <unique-column name="NAME"/>
        <unique-column name="AD_ORG_ID"/>
      </unique>


The index should include the ad_client_id column as well to allow having the same name in different clients when the taxcategory is stored in * organization.
Steps To ReproduceOn a instance with 2 clients try to create a taxcategory in both clients using * organization and the same name.
TagsNo tags attached.
Attached Filesdiff file icon fix-49882.diff [^] (678 bytes) 2022-07-27 12:07 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0139658)
hgbot (developer)
2022-07-28 09:01

Merge Request created: https://gitlab.com/openbravo/product/mods/org.openbravo.france.ecotax/-/merge_requests/4 [^]
(0139666)
hgbot (developer)
2022-07-28 12:31

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/mods/org.openbravo.france.ecotax [^]
Changeset: 43e645d6d8196b0a25d33d6a1dd98ce1faf8fe5b
Author: Igor Trebol <igor.trebol@openbravo.com>
Date: 28-07-2022 10:31:54
URL: https://gitlab.com/openbravo/product/mods/org.openbravo.france.ecotax/-/commit/43e645d6d8196b0a25d33d6a1dd98ce1faf8fe5b [^]

Fixes ISSUE-49882: Applied patch to improve PHIECO_TAXCATEGORY_NAME index

---
M src-db/database/model/tables/PHIECO_TAXCATEGORY.xml
---
(0139667)
hgbot (developer)
2022-07-28 12:31

Merge request merged: https://gitlab.com/openbravo/product/mods/org.openbravo.france.ecotax/-/merge_requests/4 [^]

- Issue History
Date Modified Username Field Change
2022-07-27 10:22 gorkaion New Issue
2022-07-27 10:22 gorkaion Assigned To => Triage Omni OMS
2022-07-27 10:31 aferraz Assigned To Triage Omni OMS => igor_trebol
2022-07-27 12:07 gorkaion File Added: fix-49882.diff
2022-07-28 09:01 hgbot Note Added: 0139658
2022-07-28 12:31 hgbot Resolution open => fixed
2022-07-28 12:31 hgbot Status new => closed
2022-07-28 12:31 hgbot Note Added: 0139666
2022-07-28 12:31 hgbot Note Added: 0139667


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker