Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0053995Openbravo ERPA. Platformpublic2023-11-22 09:152023-11-22 09:15
Reporteralostale 
Assigned ToTriage Platform Base 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0053995: "Value" named columns generate a sequence
DescriptionWhenever a new column named "Value" is added to any table, a new sequence (AD_Sequence) is created.

This is handled by ad_column_trg2 and ad_client_trg.

Does it still make sense? What are these sequences used for?
Steps To Reproduce1. Create a new "value" column in any db table
2. Import it in AD
   -> Check there is a new sequence for it
Proposed SolutionReview this code, understand its purpose and, if not needed, remove it.

If removed, sample data might also be reviewed to clean it up.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-11-22 09:15alostaleNew Issue
2023-11-22 09:15alostaleAssigned To => Triage Platform Base
2023-11-22 09:15alostaleModules => Core
2023-11-22 09:15alostaleTriggers an Emergency Pack => No

There are no notes attached to this issue.