Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018646Openbravo ERP00. Application dictionarypublic2011-09-28 19:512011-11-03 15:56
Reporteradrianromero 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version3.0MP5 
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
Summary0018646: The "Create columns from table" process does not handle BYTEA columns
DescriptionThe process of creating column from tables fails when creating a new table in the Tables and columns window based on a database table that has BYTEA columns.
Steps To Reproduce* Create a table with a column of type BYTEA in postgresql
* Go to the window "Tables and columns"
* Create a new record for the created table
* Execute the process "Create columns from table"
* See that all columns are created properly but the BYTEA column. The error "Wrong column type" appears in the process message.
Proposed SolutionApply the proposed attached diff.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0014777 closed migueldejuana Create columns from DB not working with columns of type text (PostgreSQL) 
Attached Filesdiff tableimportissue.diff (923) 2011-09-28 19:51
https://issues.openbravo.com/file_download.php?file_id=4603&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-09-28 19:51adrianromeroNew Issue
2011-09-28 19:51adrianromeroAssigned To => iperdomo
2011-09-28 19:51adrianromeroFile Added: tableimportissue.diff
2011-09-28 19:51adrianromeroModules => Core
2011-09-29 08:28iperdomoAssigned Toiperdomo => alostale
2011-10-20 11:23hgbotCheckin
2011-10-20 11:23hgbotNote Added: 0041947
2011-10-20 11:23hgbotStatusnew => resolved
2011-10-20 11:23hgbotResolutionopen => fixed
2011-10-20 11:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6fa410969266067ea730f67b659f254c7466de37 [^]
2011-10-20 15:59hgbotCheckin
2011-10-20 15:59hgbotNote Added: 0041953
2011-10-20 15:59hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/6fa410969266067ea730f67b659f254c7466de37 [^] => http://code.openbravo.com/erp/devel/pi/rev/f91d12c55f35f9756bead6a95cbe7f936e27a249 [^]
2011-10-20 16:03adrianromeroNote Added: 0041954
2011-10-23 13:42hudsonbotCheckin
2011-10-23 13:42hudsonbotNote Added: 0042025
2011-10-23 13:42hudsonbotCheckin
2011-10-23 13:42hudsonbotNote Added: 0042030
2011-11-03 15:56alostaleStatusresolved => closed
2011-11-03 15:56alostaleFixed in Version => 3.0MP5
2012-02-29 11:45migueldejuanaRelationship addedrelated to 0014777

Notes
(0041947)
hgbot   
2011-10-20 11:23   
Repository: erp/devel/pi
Changeset: 6fa410969266067ea730f67b659f254c7466de37
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Oct 20 11:01:15 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6fa410969266067ea730f67b659f254c7466de37 [^]

Fixes issue 0018646: The Create columns from table process does not handle BYTEA columns
It has been added in the PL/SQL proccess AD_TABLE_IMPORT support for BYTEA (Postgresql) and BLOB (Oracle) data types

---
M src-db/database/model/functions/AD_TABLE_IMPORT.xml
---
(0041953)
hgbot   
2011-10-20 15:59   
Repository: erp/devel/pi
Changeset: f91d12c55f35f9756bead6a95cbe7f936e27a249
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Oct 20 15:58:17 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f91d12c55f35f9756bead6a95cbe7f936e27a249 [^]

Fixes issue 0018646: The Create columns from table process does not handle BYTEA columns
It has been added in the PL/SQL proccess AD_TABLE_IMPORT support for TEXT (Postgresql) and CLOB (Oracle) data type

---
M src-db/database/model/functions/AD_TABLE_IMPORT.xml
---
(0041954)
adrianromero   
2011-10-20 16:03   
* Testing the issue

Create a new table with a BYTEA column and with a TEXT column.
Login as System administrator and go to "Tables and Windows"
Create a new table for the new database table created.
Execute the process "Create columns from table"
The process will succeed and all the columns will be created
For the BYTEA column a new Binary column with length 4000 will be created
For the TEXT column a new Text column with length 1000000 will be created.
This must be tested in Postgresql and Oracle.

* Other areas affected

Only the process "Create columns from table" is affected.
(0042025)
hudsonbot   
2011-10-23 13:42   
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/35bf0a7aa166 [^]

Maturity status: Test
(0042030)
hudsonbot   
2011-10-23 13:42   
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/35bf0a7aa166 [^]

Maturity status: Test