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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018646
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionaryminoralways2011-09-28 19:512011-11-03 15:56
ReporteradrianromeroView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0MP5
StatusclosedFix in branchFixed in SCM revisionf91d12c55f35
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018646: 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.
TagsNo tags attached.
Attached Filesdiff file icon tableimportissue.diff [^] (923 bytes) 2011-09-28 19:51 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0014777 closedmigueldejuana Create columns from DB not working with columns of type text (PostgreSQL) 

-  Notes
(0041947)
hgbot (developer)
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 (developer)
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 (viewer)
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 (viewer)
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 (viewer)
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

- Issue History
Date Modified Username Field Change
2011-09-28 19:51 adrianromero New Issue
2011-09-28 19:51 adrianromero Assigned To => iperdomo
2011-09-28 19:51 adrianromero File Added: tableimportissue.diff
2011-09-28 19:51 adrianromero Modules => Core
2011-09-28 19:51 adrianromero OBNetwork customer => No
2011-09-29 08:28 iperdomo Assigned To iperdomo => alostale
2011-10-20 11:23 hgbot Checkin
2011-10-20 11:23 hgbot Note Added: 0041947
2011-10-20 11:23 hgbot Status new => resolved
2011-10-20 11:23 hgbot Resolution open => fixed
2011-10-20 11:23 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6fa410969266067ea730f67b659f254c7466de37 [^]
2011-10-20 15:59 hgbot Checkin
2011-10-20 15:59 hgbot Note Added: 0041953
2011-10-20 15:59 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/6fa410969266067ea730f67b659f254c7466de37 [^] => http://code.openbravo.com/erp/devel/pi/rev/f91d12c55f35f9756bead6a95cbe7f936e27a249 [^]
2011-10-20 16:03 adrianromero Note Added: 0041954
2011-10-23 13:42 hudsonbot Checkin
2011-10-23 13:42 hudsonbot Note Added: 0042025
2011-10-23 13:42 hudsonbot Checkin
2011-10-23 13:42 hudsonbot Note Added: 0042030
2011-11-03 15:56 alostale Status resolved => closed
2011-11-03 15:56 alostale Fixed in Version => 3.0MP5
2012-02-29 11:45 migueldejuana Relationship added related to 0014777

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker