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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040131
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementmajoralways2019-02-04 13:052019-02-13 09:02
ReportervmromanosView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutioninvalidFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version3.0PR18Q3.5
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToSandrahuguet
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040131: Set two new columns in C_Invoice as nullable and do not set a default value

DescriptionIn Create Lines From Refactor introduced in 18Q4, two new columns were added to C_Invoice table: CREATEFROMORDERS and CREATEFROMINOUTS.

They were set as mandatory and default value 'N'.

In versions before PG 11 this configuration adds an important overhead when creating the columns. So to avoid a performance issue in the update process, it would be better to set both columns as nullable and without a default value.

Basically is to revert the changeset: https://code.openbravo.com/erp/devel/pi/rev/7d6426933ab5 [^]
Steps To ReproduceIn a HV table, like c_order, run:
ALTER TABLE c_order add COLUMN test character varying(1) default 'N';
Check it's very slow.

Now run:
ALTER TABLE c_order add COLUMN test2 character varying(1);
It's almost immediate.

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0040119 closedAtulOpenbravo Set two new columns in C_Invoice as nullable and do not set a default value 

-  Notes
(0109789)
Sandrahuguet (developer)
2019-02-13 09:02

Create lines from refactor is introduced in 18Q4

- Issue History
Date Modified Username Field Change
2019-02-04 20:10 AtulOpenbravo Type defect => backport
2019-02-04 20:10 AtulOpenbravo Target Version => 3.0PR18Q3.5
2019-02-13 09:02 Sandrahuguet Review Assigned To => Sandrahuguet
2019-02-13 09:02 Sandrahuguet Note Added: 0109789
2019-02-13 09:02 Sandrahuguet Status scheduled => closed
2019-02-13 09:02 Sandrahuguet Resolution open => invalid


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker