Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007623Openbravo ERP00. Application dictionarypublic2009-02-18 13:222009-04-22 00:00
alostale 
alostale 
urgentmajoralways
closedfixed 
5
 
pi2.50beta 
Core
No
0007623: Columnname check is not following the modularity rules
Modularity defines that a column in a module can be added to a table in a different module, in this case the column name should be EM_DBPREFIX_COLUMNNAME.

But the trigger that checks the name correctness for the columns fails when following this policy because it does not check it starts by EM_.
1. Create a new module and set a dbprefix, let's say TEST.
2. Create a new DB column in a core table called EM_TEST_MYCOLUMN
3. Add this column to dictionary and set it to the new module. -> An error is raised.
Check the columnanme in other for tables in different modules starts by EM_
Modularity
has duplicate defect 0007680 closed alostale New Columns cannot be added with EM_XXX prefix 
has duplicate defect 0008630 closed alostale cannot switch module in tables and columns 
related to defect 0007414 closed alostale Auto-prefix AD elements (tables, columns ...) when selecting a "in development" data package 
related to defect 0007792pi closed alostale Not correct default module for column in a module different than their table's one. 
Issue History
2009-02-18 13:22alostaleNew Issue
2009-02-18 13:22alostaleAssigned To => alostale
2009-02-18 13:22alostaleRegression testing => No
2009-02-18 13:22alostaleTag Attached: Modularity
2009-02-18 13:23svnbotCheckin
2009-02-18 13:23svnbotNote Added: 0013647
2009-02-18 13:23svnbotStatusnew => resolved
2009-02-18 13:23svnbotResolutionopen => fixed
2009-02-18 13:23svnbotsvn_revision => 13310
2009-02-20 09:44alostaleRelationship addedrelated to 0007414
2009-02-24 11:04alostaleRelationship addedrelated to 0007792
2009-02-24 12:00alostaleRelationship addedhas duplicate 0007680
2009-04-21 10:33psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777951
2009-04-23 12:25alostaleRelationship addedhas duplicate 0008630

Notes
(0013647)
svnbot   
2009-02-18 13:23   
Repository: openbravo
Revision: 13310
Author: alostale
Date: 2009-02-18 13:23:23 +0100 (Wed, 18 Feb 2009)

fixed bug 0007623: Columnname check is not following the modularity rules

---
U trunk/src-db/database/model/triggers/AD_COLUMN_TRG2.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13310&sc=1 [^]