Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0021915 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 07. Sales management | major | always | 2012-10-11 13:32 | 2012-10-19 14:45 | |||
Reporter | dmiguelez | View Status | public | |||||
Assigned To | dmiguelez | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | d5a54ef8d574 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
Product Version | SCM revision | |||||||
Review Assigned To | dmiguelez | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | Automated tests | |||||||
Regression date | 2012-10-11 | |||||||
Regression introduced in release | ||||||||
Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/7fba0985c35d [^] | |||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0021915: DB Consistency broken | |||||||
Description | diff -r d54c2b9fe7f1 src-db/database/model/tables/C_INVOICELINE.xml --- a/src-db/database/model/tables/C_INVOICELINE.xml Thu Oct 11 11:35:17 2012 +0200 +++ b/src-db/database/model/tables/C_INVOICELINE.xml Thu Oct 11 11:04:33 2012 +0000 @@ -161,7 +161,7 @@ <default><![CDATA[0]]></default> <onCreateDefault/> </column> - <column name="grosspricestd" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false"> + <column name="GROSSPRICESTD" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false"> <default><![CDATA[0]]></default> <onCreateDefault/> </column> diff -r d54c2b9fe7f1 src-db/database/model/tables/C_ORDERLINE.xml --- a/src-db/database/model/tables/C_ORDERLINE.xml Thu Oct 11 11:35:17 2012 +0200 +++ b/src-db/database/model/tables/C_ORDERLINE.xml Thu Oct 11 11:04:33 2012 +0000 @@ -213,7 +213,7 @@ <default/> <onCreateDefault/> </column> - <column name="grosspricestd" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false"> + <column name="GROSSPRICESTD" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false"> <default><![CDATA[0]]></default> <onCreateDefault/> </column> | |||||||
Steps To Reproduce | diff -r d54c2b9fe7f1 src-db/database/model/tables/C_INVOICELINE.xml --- a/src-db/database/model/tables/C_INVOICELINE.xml Thu Oct 11 11:35:17 2012 +0200 +++ b/src-db/database/model/tables/C_INVOICELINE.xml Thu Oct 11 11:04:33 2012 +0000 @@ -161,7 +161,7 @@ <default><![CDATA[0]]></default> <onCreateDefault/> </column> - <column name="grosspricestd" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false"> + <column name="GROSSPRICESTD" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false"> <default><![CDATA[0]]></default> <onCreateDefault/> </column> diff -r d54c2b9fe7f1 src-db/database/model/tables/C_ORDERLINE.xml --- a/src-db/database/model/tables/C_ORDERLINE.xml Thu Oct 11 11:35:17 2012 +0200 +++ b/src-db/database/model/tables/C_ORDERLINE.xml Thu Oct 11 11:04:33 2012 +0000 @@ -213,7 +213,7 @@ <default/> <onCreateDefault/> </column> - <column name="grosspricestd" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false"> + <column name="GROSSPRICESTD" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false"> <default><![CDATA[0]]></default> <onCreateDefault/> </column> | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0053307) hgbot (developer) 2012-10-11 13:33 |
Repository: erp/devel/pi Changeset: d5a54ef8d574725650ed66f5e878cf16c37f7f7f Author: David Miguelez <david.miguelez <at> openbravo.com> Date: Thu Oct 11 13:33:05 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/d5a54ef8d574725650ed66f5e878cf16c37f7f7f [^] Fixes issue 21915. Fixes database consistency. --- M src-db/database/model/functions/C_INVOICE_CREATE.xml M src-db/database/model/tables/C_INVOICELINE.xml M src-db/database/model/tables/C_ORDERLINE.xml --- |
(0053313) hgbot (developer) 2012-10-11 17:01 |
Repository: erp/devel/pi Changeset: 3a71027b0600bdc072a205d3ca6f9d1084ead32b Author: David Miguelez <david.miguelez <at> openbravo.com> Date: Thu Oct 11 16:59:59 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/3a71027b0600bdc072a205d3ca6f9d1084ead32b [^] Related to Issue 21915. --- M src-db/database/model/functions/C_INVOICE_CREATE.xml --- |
(0053331) hudsonbot (developer) 2012-10-13 15:50 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/99e438a6f972 [^] Maturity status: Test |
(0053332) hudsonbot (developer) 2012-10-13 15:50 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/99e438a6f972 [^] Maturity status: Test |
(0053496) dmiguelez (developer) 2012-10-19 14:45 |
DB Consistency fixed. |
Issue History | |||
Date Modified | Username | Field | Change |
2012-10-11 13:32 | dmiguelez | New Issue | |
2012-10-11 13:32 | dmiguelez | Assigned To | => dmiguelez |
2012-10-11 13:32 | dmiguelez | Modules | => Core |
2012-10-11 13:33 | hgbot | Checkin | |
2012-10-11 13:33 | hgbot | Note Added: 0053307 | |
2012-10-11 13:33 | hgbot | Status | new => resolved |
2012-10-11 13:33 | hgbot | Resolution | open => fixed |
2012-10-11 13:33 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/d5a54ef8d574725650ed66f5e878cf16c37f7f7f [^] |
2012-10-11 17:01 | hgbot | Checkin | |
2012-10-11 17:01 | hgbot | Note Added: 0053313 | |
2012-10-11 18:40 | shuehner | Regression level | => Automated tests |
2012-10-11 18:40 | shuehner | Regression date | => 2012-10-11 |
2012-10-11 18:40 | shuehner | Regression introduced by commit | => https://code.openbravo.com/erp/devel/pi/rev/7fba0985c35d [^] |
2012-10-13 15:50 | hudsonbot | Checkin | |
2012-10-13 15:50 | hudsonbot | Note Added: 0053331 | |
2012-10-13 15:50 | hudsonbot | Checkin | |
2012-10-13 15:50 | hudsonbot | Note Added: 0053332 | |
2012-10-19 14:45 | dmiguelez | Review Assigned To | => dmiguelez |
2012-10-19 14:45 | dmiguelez | Note Added: 0053496 | |
2012-10-19 14:45 | dmiguelez | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |