Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0050951 | Openbravo ERP | Y. DBSourceManager | public | 2022-11-18 13:06 | 2022-11-29 08:13 |
|
| Reporter | migueldejuana | |
| Assigned To | caristu | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | PR23Q1 | |
| Merge Request Status | approved |
| Review Assigned To | |
| OBNetwork customer | No |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0050951: onCreateDefault not working for non mandatory columns referencing same table |
| Description | onCreateDefault works properly when we define a new mandatory column referencing another column of the same table, but it is not working if the new column is not mandatory. It would be nice to also support this case.
For example, this new column in AD_ORG is not working because it is not mandatory:
<column name="EM_OBDO_AD_ORG_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
<default/>
<onCreateDefault><![CDATA[AD_LEGALENTITY_ORG_ID]]></onCreateDefault>
</column>
We should update the documentation:
http://wiki.openbravo.com/wiki/How_to_define_an_on_Create_Default [^]
|
| Steps To Reproduce | n/a |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0049897 | PR22Q4 | closed | alostale | Add missing support for referencing other columns in onCreateDefault during importsampledata |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2022-11-18 13:06 | migueldejuana | New Issue | |
| 2022-11-18 13:06 | migueldejuana | Assigned To | => Triage Platform Base |
| 2022-11-18 13:06 | migueldejuana | OBNetwork customer | => No |
| 2022-11-18 13:06 | migueldejuana | Modules | => Core |
| 2022-11-18 13:06 | migueldejuana | Triggers an Emergency Pack | => No |
| 2022-11-18 13:07 | migueldejuana | Description Updated | bug_revision_view_page.php?rev_id=25143#r25143 |
| 2022-11-18 13:41 | caristu | Relationship added | related to 0049897 |
| 2022-11-18 13:41 | caristu | Assigned To | Triage Platform Base => caristu |
| 2022-11-25 09:36 | hgbot | Merge Request Status | => open |
| 2022-11-25 09:36 | hgbot | Note Added: 0144134 | |
| 2022-11-25 10:09 | hgbot | Note Added: 0144135 | |
| 2022-11-29 08:09 | hgbot | Merge Request Status | open => approved |
| 2022-11-29 08:09 | hgbot | Resolution | open => fixed |
| 2022-11-29 08:09 | hgbot | Status | new => closed |
| 2022-11-29 08:09 | hgbot | Note Added: 0144216 | |
| 2022-11-29 08:09 | hgbot | Note Added: 0144217 | |
| 2022-11-29 08:13 | hgbot | Note Added: 0144218 | |
| 2022-11-29 08:13 | hgbot | Fixed in Version | => PR23Q1 |
| 2022-11-29 08:13 | hgbot | Note Added: 0144219 | |
|
Notes |
|
|
(0144134)
|
|
hgbot
|
|
2022-11-25 09:36
|
|
|
|
|
(0144135)
|
|
hgbot
|
|
2022-11-25 10:09
|
|
|
|
|
(0144216)
|
|
hgbot
|
|
2022-11-29 08:09
|
|
Directly closing issue as related merge request is already approved.
Repository: https://gitlab.com/openbravo/product/dbsm [^]
Changeset: 46d2ef154b5a2d92d7c22fe38e8e046f4ba09ce2
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 29-11-2022 07:09:50
URL: https://gitlab.com/openbravo/product/dbsm/-/commit/46d2ef154b5a2d92d7c22fe38e8e046f4ba09ce2 [^]
fixes BUG-50951: non literal OCD doesn't work in non mandatory columns
On create default of a non mandatory column that references to a
column of the same table was not working.
---
A src-test/model/createDefault/M6.xml
A src-test/model/createDefault/M7.xml
A src-test/model/createDefault/NM5.xml
A src-test/model/createDefault/NM6.xml
M src-test/src/org/openbravo/dbsm/test/model/data/OtherDefaults.java
M src/org/apache/ddlutils/platform/SqlBuilder.java
---
|
|
|
|
(0144217)
|
|
hgbot
|
|
2022-11-29 08:09
|
|
|
|
|
(0144218)
|
|
hgbot
|
|
2022-11-29 08:13
|
|
|
|
|
(0144219)
|
|
hgbot
|
|
2022-11-29 08:13
|
|
|