Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0050951 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
feature request | [Openbravo ERP] Y. DBSourceManager | major | always | 2022-11-18 13:06 | 2022-11-29 08:13 | |||
Reporter | migueldejuana | View Status | public | |||||
Assigned To | caristu | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | PR23Q1 | |||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
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 | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
||||||||
|
![]() |
|
(0144134) hgbot (developer) 2022-11-25 09:36 |
Merge Request created: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/40 [^] |
(0144135) hgbot (developer) 2022-11-25 10:09 |
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/775 [^] |
(0144216) hgbot (developer) 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 (developer) 2022-11-29 08:09 |
Merge request merged: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/40 [^] |
(0144218) hgbot (developer) 2022-11-29 08:13 |
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/775 [^] |
(0144219) hgbot (developer) 2022-11-29 08:13 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/openbravo [^] Changeset: 07b6f9579dcb74a38f3b75dfd60a60300a5e5326 Author: Carlos Aristu <carlos.aristu@openbravo.com> Date: 29-11-2022 08:11:21 URL: https://gitlab.com/openbravo/product/openbravo/-/commit/07b6f9579dcb74a38f3b75dfd60a60300a5e5326 [^] fixes BUG-50951: non literal OCD doesn't work in non mandatory columns Non literal OCD referencing to a column of the same table was not being applied in non mandatory columns --- M src-db/database/lib/dbsourcemanager.jar --- |
![]() |
|||
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 | View Revisions |
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 |
Copyright © 2000 - 2009 MantisBT Group |